/// <summary>
/// 拷贝数据表到数据库中
/// </summary>
/// <param name="connectionString"></param>
/// <param name="dt"></param>
public static void CopyTableToSql(string connectionString, DataTable dt)
{
using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction))
{
sqlbulkcopy.DestinationTableName = dt.TableName;
for (int i = 0; i < dt.Columns.Count; i++)
{
sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
}
sqlbulkcopy.WriteToServer(dt);
}
}
/// <summary>
/// 拷贝DataSet里的多个表到数据库中
/// </summary>
/// <param name="connectionString"></param>
/// <param name="DS"></param>
public static void CopyTableToSql(string connectionString, DataSet DS)
{
using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction))
{
foreach (DataTable item in DS.Tables)
{
if (item.Rows.Count > 0)
{
sqlbulkcopy.ColumnMappings.Clear();
sqlbulkcopy.DestinationTableName = item.TableName;
foreach (DataColumn Column in item.Columns)
{
sqlbulkcopy.ColumnMappings.Add(Column.ColumnName, Column.ColumnName);
}
sqlbulkcopy.WriteToServer(item);
}
}
}
}
/// <summary>
/// 克隆表结构,并制定新的表名
/// </summary>
/// <param name="source"></param>
/// <param name="newTableName"></param>
/// <returns></returns>
public static DataTable Clone(this DataTable source, String newTableName)
{
DataTable dt = source.Clone();
dt.TableName = newTableName;
return dt;
}
DataTable.Name 是表名字
DataTable Table_A = new DataTable("Table_A");
Table_A.Columns.Add("Name", Type.GetType("System.String"));
Table_A.Columns.Add("Value", Type.GetType("System.Decimal")).AllowDBNull = true;
//克隆结构
DataTable Table_B = Tb_Histroy_A.Clone("Table_B");
DataTable Table_C = Tb_Histroy_A.Clone("Table_C");
CopyTableToSql("ConnectionString",Table_A);