DataTable table = new DataTable();//在内存中建立一个临时表
table.Columns.Add("DAXIAO1");//为表添加列名
table.Columns.Add("ID1");
for (int i = 0; i < 155280; i++)
{
//在循环中得到w的值
w=i:
row["DAXIAO1"] = w;
table.Rows.Add(row); //把行数据添加到临时表中
}
String conn = "Data Source=WEINIU;Initial Catalog=CESHI;Persist Security Info=True;User ID=sa;Password=m";
using (SqlBulkCopy bulkcopy = new SqlBulkCopy(conn))
{
bulkcopy.DestinationTableName = "jiuqisi";//sql中的表名
bulkcopy.ColumnMappings.Add("DAXIAO1", "DAXIAO");//建立内存表和sql表的对应关系
bulkcopy.ColumnMappings.Add("ID1", "ID");
bulkcopy.WriteToServer(table);//执行写入操作
}
table.Columns.Add("DAXIAO1");//为表添加列名
table.Columns.Add("ID1");
for (int i = 0; i < 155280; i++)
{
//在循环中得到w的值
w=i:
DataRow row = table.NewRow(); //生成一行
row["ID1"] = i+1;
row["DAXIAO1"] = w;
table.Rows.Add(row); //把行数据添加到临时表中
}
String conn = "Data Source=WEINIU;Initial Catalog=CESHI;Persist Security Info=True;User ID=sa;Password=m";
using (SqlBulkCopy bulkcopy = new SqlBulkCopy(conn))
{
bulkcopy.DestinationTableName = "jiuqisi";//sql中的表名
bulkcopy.ColumnMappings.Add("DAXIAO1", "DAXIAO");//建立内存表和sql表的对应关系
bulkcopy.ColumnMappings.Add("ID1", "ID");
bulkcopy.WriteToServer(table);//执行写入操作
}