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