ASP.NET with C# and SQL SERVER , some vb.net . asp.net examples, asp.net codes, asp.net programs, c# code, sql server queries, important codes.
Tuesday, 16 October 2012
Bulk Copy in Asp.Net C#
public int BulkCopyBL(DataTable dt,SqlTransaction Trans)
{
try
{
using (SqlBulkCopy copy = new SqlBulkCopy(Trans.Connection, SqlBulkCopyOptions.Default, Trans))
{
copy.ColumnMappings.Clear();
copy.DestinationTableName = "tblTxtToReceipts";
copy.ColumnMappings.Add(0,0);
copy.ColumnMappings.Add(1,1);
copy.ColumnMappings.Add(2,2);
copy.ColumnMappings.Add(3,3);
copy.ColumnMappings.Add(4,4);
copy.ColumnMappings.Add(5,5);
copy.ColumnMappings.Add(6,6);
copy.ColumnMappings.Add(7,7);
copy.ColumnMappings.Add(8,8);
copy.ColumnMappings.Add(9,9);
copy.ColumnMappings.Add(10, 10);
copy.ColumnMappings.Add(11, 11);
copy.ColumnMappings.Add(12, 12);
copy.ColumnMappings.Add(13, 13);
copy.ColumnMappings.Add(14, 14);
copy.ColumnMappings.Add(15, 15);
copy.ColumnMappings.Add(16, 16);
copy.ColumnMappings.Add(17, 17);
copy.ColumnMappings.Add(18, 18);
copy.WriteToServer(dt);
}
return -1;
}
catch (Exception ex)
{
Trans.Rollback();
return 0;
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment