The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment