![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
![](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
1 c# 分批处理数据录入 2 3 //using System.Text; 4 5 //using System.Data; 6 7 //using System.Data.SqlClient; 8 9 //using System; 10 11 //namespace InsertEfficiency 12 13 //{ 14 15 // class Program 16 17 // { 18 19 // static void Main(string[] args) 20 21 // { 22 23 // //构造数据源 24 25 // DataTable dt = new DataTable(); 26 27 // dt.Columns.Add(new DataColumn("ID", typeof(int))); 28 29 // dt.Columns.Add(new DataColumn("CreateDateTime", typeof(DateTime))); 30 31 // dt.Columns.Add(new DataColumn("TestMethod", typeof(string))); 32 33 34 35 // for (int i = 1; i <= 30; i++) 36 37 // { 38 39 // dt.Rows.Add(new object[] { i, DateTime.Now, "ExecuteSqlBulkCopy" }); 40 41 // } 42 43 44 45 // Test t = new Test(); 46 47 48 49 // DateTime begin1 = DateTime.Now; 50 51 // t.ExecuteRowByRow(dt); 52 53 // DateTime end1 = DateTime.Now; 54 55 // Console.WriteLine("ExecuteRowByRow:{0}ms", (end1 - begin1).Milliseconds); 56 57 58 59 // DateTime begin2 = DateTime.Now; 60 61 // t.ExecuteOnce(dt); 62 63 // DateTime end2 = DateTime.Now; 64 65 // Console.WriteLine("ExecuteOnce:{0}ms", (end2 - begin2).Milliseconds); 66 67 68 69 // DateTime begin3 = DateTime.Now; 70 71 // t.ExecuteSqlBulkCopy(dt); 72 73 // DateTime end3 = DateTime.Now; 74 75 // Console.WriteLine("ExecuteSqlBulkCopy:{0}ms", (end3 - begin3).Milliseconds); 76 77 78 79 // Console.ReadLine(); 80 81 // } 82 83 // } 84 85 86 87 // class Test 88 89 // { 90 91 // public Test() 92 93 // { 94 95 // } 96 97 98 99 // public void ExecuteRowByRow(DataTable dt) 100 101 // { 102 103 // using (SqlConnection conn = new SqlConnection(GetConnectionString)) 104 105 // { 106 10