bulk insertion in sqlserver

Posted by Klbaiju under ASP.NET on 8/5/2010 | Views : 1040 | Status : [Member] | Replies : 1
Hi,
i want to add multiple records at one time.
suppose my dataset contains 20 rows .i want to add 20 rows at one time.
how it is possible.
i need just like this

i fill datas in a dataset.

SqlDataAdapter daitinerary = new SqlDataAdapter("select vcpackagecode from packageextras where vclanguage='english' and btpublished=1", con);
DataSet dsitinerary = new DataSet();
daitinerary.Fill(dsitinerary);
Int32 count = dsitinerary.Tables[0].Rows.Count;
for(i=1;i<=count;i++)
{
//insert command




}

how it is possible

Regards

K L BAIJU




Responses

Posted by: Poster on: 8/5/2010 [Member] Starter

Up
0
Down
Read through this article, http://www.codeproject.com/KB/database/relationaladonet.aspx

Thanks

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response