sql SqlBulkCopy
标签：stat this column class tin des ble add style
sql SqlBulkCopy
void BuckCopy(DataTable dt, string destinationTableName)
{
using (SqlConnection sqlConn = (SqlConnection)this.CurrentDataBase.CreateConnection())
{
if (sqlConn.State != ConnectionState.Open)
sqlConn.Open();
using (SqlBulkCopy buckCopy = new SqlBulkCopy(sqlConn))
{
buckCopy.DestinationTableName = destinationTableName;
buckCopy.ColumnMappings.Add("ID", "ID");
buckCopy.WriteToServer(dt);
}
}
}