1 string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
2 DataTable dt = new DataTable();
3 dt.Columns.Add("Sname");
4 dt.Columns.Add("SAge");
5
6 for (int i = 0; i < 80000;i++ )
7 {
8 DataRow row = dt.NewRow();
9 row["Sname"] = "aa" + i;
10 row["Sage"] = i * i;
11 dt.Rows.Add(row);
12 }
13
14
15 using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connstr))
16 {
17 bulkCopy.DestinationTableName = "student";
18 bulkCopy.ColumnMappings.Add("Sname", "Sname");
19 bulkCopy.ColumnMappings.Add("Sage", "Sage");
20 bulkCopy.WriteToServer(dt);
21 }
