ADO.NET :: Insert Collection Into A SQL Table?

Mar 1, 2011

I've a collection defined in .NET. The collection contains a few hundred items.

example of the object in collection:

Tag.Name = "Tag1"
Tag.ID = "2"
Tag.Location = "Home"

and so on (a few hundred items).

I've a stored procedure to insert that data into the datatable. The logic in the sp checks first if the tag name already exists in the table.

If not, then insert.

Now I can use a loop to insert the data, but is there another way to do the same more efficient ?

View 1 Replies

Similar Messages:

Can Insert Rows To Table A Based On Values In Table B By A Single INSERT Statement

Dec 7, 2010

I am doing a data warehouse project.I have two tables tblA (id, type) and tblB(city, no_crimes, type).I want to create (insert) a number of rows based on the value of no_crimes.For Example, in tblB(Leeds, 2000, murder). SO, I need to insert 2000 rows into tblA by a single INSERT statement (not 2000 statements).

View 3 Replies

ADO.NET :: Insert Data Into Two Table At The Same Time - Multiple INSERT Statements?

Oct 26, 2010

I am trying to insert data into two table at the same time , but i'm successding in inserting data into only one table at a time on button click .

[Code]....

When i run the code, data gets inserted into table "implantDetails" only. Are multiple INSERT statments allowed?

View 1 Replies

Subsonic 2.2 Paging Linked Table Collection

Dec 26, 2010

I'm creating a small forum for my CMS and I'm using subsonic 2.2 as my DAL.
I'm loading my theads like this:

DAL.ForumThread item = DAL.ForumThread.FetchByID(id);

In my database my ForumPosts table looks like this:

ForumPostID | ThreadID | Description | UserID | CreatedOn| etc

So now when I have my DAL.ForumThread item I can load the connected post collection by using:

item.ForumPosts();

This all works great, but the problem is that I'm using serverside paging and want to add some additional select parameters too like showing only active records.

Is this even possible when using SubSonic 2.2 ? The workaround I have now is just creating a new SubSonic.Query and select the posts by threadid and there I can set pageindex and pagesize without problems but I think this can be done easier?

I also would like to know if it makes any difference performance wise by just using item.ForumPosts() or starting a new query, I think the forumposts are already in the ForumThreads collection and don't require a new database call right?

View 1 Replies

Creating Html Table From Listitem Collection?

Jul 8, 2010

I am creating a html table from a list collection. I am able to create the table, but I am not able to group the related items and add into a single table.

[Code]....

I have 3 items in the list collection, in which Student Name is same for 2 items.

Now I am getting 3 tables. I want to group the student Name and get a single table for unique student name.

This is my list collection:

Student ID Student Name Mark1

1 John 25
2 Mac 22
3 John 24

I am getting 3 tables now, but i would like to group the student Name and then get a single table for John having his marks and another table for Mac.

View 15 Replies

DataSource Controls :: Fetch Set Of Records From Table (Db) Into Collection?

Jul 12, 2010

Equivalent of recordset.Edit, Movefirst,NoMatch of vb6 in vb.Net? I want to fetch records from single table of database(Sql server 2005) and collect in collections. How can we do that by dataset and dataadapter ? We want to fetch not to display.

View 1 Replies

ADO.NET :: Table Collection Missing In LINQ Query / DataContext?

Aug 13, 2010

I'm new to LINQ and have a problem with my query not showing me the Table Collection. I manually created my Cart class and specified the table attributes on each property (works fine for inserting records via LINQ see below). DataContext dc = new DataContext(Conn);

var q = (from c in dc.NOTABLES?? where ((c.UserID == userID)) orderby c.CreateDateTime Based on examples I would expect to see dc.Cart But I don't, so I tried to access it via dc.GetTable<Cart>() which at least gets me data but doesn't seem to convert the rows to my Cart object since this:
foreach (var cart in q) Log.Info("UserID: " + cart.UserID + " CartID: " + cart.ID.ToString());
blows up with a "Specified Cast is Not Valid" exception.

No Problem Inserting Also, I had no problem inserting data into the database:

DataContext dc = new DataContext(Conn);
Table<Cart> Carts = dc.GetTable<Cart>();
Cart aCart = new Cart();
aCart.UserID = userId;
aCart.Description = description;
aCart.CreateDateTime = System.DateTime.Now;
aCart.UpdateDateTime = System.DateTime.Now;
Carts.InsertOnSubmit(aCart);
Carts.Context.SubmitChanges();

View 1 Replies

Pass An Enity-framework Table/collection As A Parameter Into A Function (asp.net/C#)?

Dec 7, 2010

Is this possible?

using (Entities db = new Entities())
{
LoadDropDownList(ddlFirst, db.MyTable , (bool)(myMember.Id == 0), (int)myMember.RevenueRangeID);
LoadDropDownList(ddlSecond, db.OtherTable , (bool)(myMember.Id == 0), (int)myMember.OtherID);
}

I am stumbling on what the type of the second parameter should be - I am essentially trying to pass in the Entity-Framework 'table' into a generic routine that loads the DropDownList with data from the 'MyTable' table using custom logic/filtering.SInce I do the same thing about 6 times for 6 different dropdownlist/table combos I wanted to use a generic function to accomplish this.

View 2 Replies

DataSource Controls :: Select A Record From A Table And Insert Into B Table Using Linq?

Jun 29, 2010

how can i select a record from A table and insert into B table using linq?

View 2 Replies

DataSource Controls :: Way To Retrieve Data From A Table, Modify And Insert It Into Another Table

Jun 13, 2010

Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token

ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...

View 2 Replies

Forms Data Controls :: Error When Inserting Into Table - Cannot Insert Explicit Value For Identity Column In Table

Aug 11, 2010

I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".

I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.

I am getting an error when I try to insert a new row.

Here is a screenshot of the page with a shot of the dropdown list.

The Categories are user-specific. I am getting the correct values retrieved.

[URL]

There are two pretty simple database tables involved here.

NOTE: The CategoryID and PIctureID are both autoincrement integer columns.

[URL]

The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)

The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.

When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)

My problem is that I am getting this error:

Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.

(FYI: I have the full version of both Visual Studio and SQL Server.)

Here is my source code for the page:

[Code]....

View 3 Replies

DataSource Controls :: How To Insert StudentId From One Table Into Its Foreign Key In Another Table

Jun 9, 2010

I have two tables - Student and Advert.

I want to do the following;

1. Student is logged into their account (session is authenticated)

2. StudentID is primary key for that table, it is a foreign key for table Advert

3. When student is logged in, they create advert

What I want is their student Id to be input into the advert table when this new advert is created. How is this possible?

View 1 Replies

Trigger In Sql Server - Insert Data In A Table It Gets Enter In Another Table?

Oct 8, 2010

im new to trigger concept

when i insert data in a table [DSR_OUT_PRO] data get enter in another table ie [trg_Insert_DSR_OUT_PRO] but 2 times..

Is it ok, or something is wrong..

View 1 Replies

Insert Info From One Table Into Its LINK Table?

Dec 15, 2010

I'm trying to build an asp.net application, where I have three tables.

tblRoute
tblHalte
tblHalteRoute

I want to insert a routeID into tblHalteRoute and for every routeID multiple halteID's

TblRoute has the needed fields (routeID(1) & allHaltes[halteID1,halteID2,halteID3])
--> so Every route has multiple Haltes that I can access by parsing the allHaltes field and using the IDS.

What I want to do is update tblHalteRoute like this

tblRoute.routeID(1), tblRoute.allHaltes(halteID1)
tblRoute.routeID(1), tblRoute.allHaltes(halteID2)
tblRoute.routeID(1), tblRoute.allHaltes(halteID3)

inserting these values into the tblHalteRoute .. I'm really not sure on where to look or how to start, I tried using SUBquerys with an Insert before a select, but no success.

View 1 Replies

Forms Data Controls :: Bind A Collection Within A Collection To A Gridview?

Jul 26, 2010

I have a list of objects that I want to bind to a gridview. Creating that list and binding it works fine for most of the public properties in that list.

There are some objects contained in each of those objects... for instance there is an Address object.

object.Address.Line1;

object.Address.Line2;

When I bind this to my gridview, I have no issues with stuff like object.DateRegistered, but how can I access things like object.Address.WhatEverProperty? I always get this error:

"A field or property with the name 'xxx.xxxx' was not found on the selected data source."

View 7 Replies

Insert Data From Table To Another Table?

Jan 7, 2011

i have table called templates, when user ordered a new template then the All the values are needed to be inserted into the User Template Table

How can we do this?

SQL For this? ..........

View 4 Replies

Select A Value From One Table And Insert To Another Table?

Jan 5, 2011

I have two tables in a database and I want to select one value from one of that table. For that I want to pass one value and if that value stored in the table I want pick the id representing the value in the next table.

That means the operation is that first I select a row of data from first table by using a user control in that row there is a value (example "apple") and I want pass that value("apple") to the second table. In the second table the value ("apple") having a id (example "australian") and I want that the query search for that id ("australian") and show that in the text box.

[code]....

Imagine that this is the two tables using a usercontrol I select first a row from first table and I want to pass that value "apple" to second table and find out the id of "australian" (that is equivalent id for apple in the second tabl ) from the second table and show that in a text box.

View 1 Replies

Web Forms :: How To Use Collection Class For Collection Of Data

Mar 31, 2010

I want to know that how i use the collection class for storing some data and save it letter in the data base.

View 4 Replies

Add Controls To A Collection And Update From Collection?

Mar 25, 2011

I have an ASP.NET app with lots of textboxes all over the page that need updating at various points through program execution.

These textboxes actually belong to a certain class, so for easy updating I thought I could create a Dictionary(Of string, object) and add the control.ID and the control to it and then for updating do something like this:

(in case of updating textbox.text):

[code]....

However the text property of the textbox does not actually get updated. I'm mainly trying to avoid having to manually do textbox.text = somestring for each one of my textboxes every time I have to update them.

View 3 Replies

Want To Insert A Table With 60 Rows Or More?

Jul 26, 2010

I want to insert a table with 60 rows or more. When I do it, an error pop out.

[Code]....

How can I reset this default size?

View 6 Replies

C# - Insert GUID Into SQL Table?

Mar 26, 2011

I'm using ASP.Net/C# and I have a form that allows people to add information into a table and along with it I want to collect the Current Users GUID and insert it.

I have a field setup (UserID) as a unique identifier and I have the following code:

protected void Page_Load(object sender, EventArgs e)
{
MembershipUser currentUser = Membership.GetUser();
Guid temp = (Guid)(Membership.GetUser(User.Identity.Name).ProviderUserKey);
Guid @currentUserID = temp;
}
SqlConnection con = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True");
SqlCommand cmd;
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
cmd = new SqlCommand("insert into Accom (UserID) values('" + @currentUserID + "')", con);
cmd.ExecuteNonQuery();
}

I basically want to link the variable to the Database how as the above gives errors.

View 4 Replies

ADO.NET :: Insert Data To Two Table?

Feb 9, 2011

I have In my database 2 table

The 1st:

Userid and username

the 2sd:

ID and senderid and userID

and I have Relation between Userid in the (1st) and userID in the (2sd)

In tha ASP.net forma For registration I have

usern name (gust for test)

now I need:

when the user regist insert the username to the 1st tabel and the same userid insert int 2sd table

View 3 Replies

Insert ADO.Net DataTable Into A SQL Table?

Mar 18, 2010

The current solution i implemented is awful!

I use a for... loop for inserting records from an ADO.NET data-table into an SQL table.

I would like to insert at once the data-table into the SQL table, without iterating...

View 2 Replies

Web Forms :: Insert ID Of Two In Table

Sep 3, 2013

I have a database table name user and post

format of user
userid - int
username-nvarchar
format of post
postid int
userid int
post
postdate

now how can i store the user id in the post table.