Anil Jain Blogs
Monday, August 2, 2010
Use of SqlBulkCopy Function to insert row in Bulk in table.
System.Data.DataTable table = dt;
SqlConnection cn = new SqlConnection(dbc.Constr.ToString());
SqlBulkCopy cc = new SqlBulkCopy(cn);
cc.DestinationTableName = "dbo.Temp_Report";
cn.Open();
cc.WriteToServer(table);
cn.Close();
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment