April 24, 2011

Using SQLBulkCopy to transfer data in ASP.Net

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(cnMaster))
{

bulkCopy.DestinationTableName = "APHDetails";

bulkCopy.ColumnMappings.Add("POLNUM", "POLNUM");
bulkCopy.ColumnMappings.Add("PH_Tag", "PH_Tag");
bulkCopy.ColumnMappings.Add("[Update Date]", "[Update Date]");

bulkCopy.WriteToServer(dtCPS);
}

No comments:

Post a Comment