数据表中批量添加数据fortest

完整代码示例：

1. using System;  
2. using System.Data;  
3. using System.Configuration;  
4. using System.Linq;  
5. using System.Web;  
6. using System.Web.Security;  
7. using System.Web.UI;  
8. using System.Web.UI.HtmlControls;  
9. using System.Web.UI.WebControls;  
10. using System.Web.UI.WebControls.WebParts;  
11. using System.Xml.Linq;  
12. using System.Diagnostics;  
13. using SubSonic;  
14. using UsersDAL;  
15. using System.Data.SqlClient;  
16. namespace UserManage.Code  
17. {  
18.     public class SqlBulkCopy1  
19.     {  
20.         public static long SqlBulkCopyInsert(DataTable dt,string connectionString)  
21.         {  
22.             Stopwatch stopwatch = new Stopwatch();  
23.             stopwatch.Start();  
24.             DataTable dataTable = dt;  
25.             string passportKey;  
26.               
27.             for (int i = 0; i < 100000; i++)  
28.             {  
29.                 passportKey = Guid.NewGuid().ToString();  
30.                 DataRow dataRow = dataTable.NewRow();  
31.                 dataRow = passportKey;  
32.                 dataRow = "aaaaaa";  
33.                 dataRow = "男";  
34.                 dataRow = "address";  
35.                 dataTable.Rows.Add(dataRow);  
36.             }  
37.             SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(connectionString);  
38.             sqlBulkCopy.DestinationTableName = "Users";  
39.             sqlBulkCopy.BatchSize = dataTable.Rows.Count;  
40.             SqlConnection sqlConnection = new SqlConnection(connectionString);  
41.             sqlConnection.Open();  
42.             if (dataTable != null && dataTable.Rows.Count != 0)  
43.             {  
44.                 sqlBulkCopy.WriteToServer(dataTable);  
45.             }  
46.             sqlBulkCopy.Close();  
47.             sqlConnection.Close();  
48.              
49.             return stopwatch.ElapsedMilliseconds;  
50.         }    
51.  
52.  
53.     }  
54. }