- public static voidSqlBulkCopyByDatatable(string tableName, DataTable dt)
- {
- using(varconnection =new SqlConnection(connectionString))
- {
- using(varsqlbulkcopy =new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction))
- {
- sqlbulkcopy.DestinationTableName = tableName;
- for(inti =0; i < dt.Columns.Count; i++)
- {
- sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
- }
- sqlbulkcopy.WriteToServer(dt);
- connection.Close();
- }
- }
- }
来源: http://www.cnblogs.com/xiuguang/p/6572176.html