private static void BulkCopyTable(DataTable table, SqlConnection dbConnection)
{
using (SqlBulkCopy s = new SqlBulkCopy(dbConnection))
{
s.BatchSize = 1000;
s.DestinationTableName = table.TableName;
Debug.WriteLine("Table: {0}",table.TableName);
foreach (var column in table.Columns)
{
s.ColumnMappings.Add(column.ToString(), column.ToString());
Debug.WriteLine(column.ToString());
}
s.WriteToServer(table);
}
table.Clear();
}
Does this help?
Hard to know from your question.