SqlBulkCopy 封装 CopyTableToSql

        /// <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);