快速读取TXT几百万行数据， 然后插入到数据，SqlBulkCopy功能的确是有效率

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61

public static void Main(string[] args)         {             string strPath = "F:\\Download\\600.txt";             int lines = 1;             Console.WriteLine("正在读取行数...."+DateTime.Now.ToString());             DataTable dt = new DataTable();             dt.Columns.Add("ID", System.Type.GetType("System.Int32"));             dt.Columns.Add("UserName",System.Type.GetType("System.String"));                        dt.Columns.Add("Password", System.Type.GetType("System.String"));             dt.Columns.Add("Email", System.Type.GetType("System.String"));               using (var sr = new StreamReader(strPath))             {                 var ls = "";                 while ((ls = sr.ReadLine()) != null)                 {                     if (ls.Contains("#"))                     {                         string[] templine = ls.Split('#');                         if (templine.Length == 3)                         {                             DataRow item = dt.NewRow();                             item["ID"] = lines;                             item["UserName"] = templine[0].Trim();                             item["Password"] = templine[1].Trim();                             item["Email"] = templine[2].Trim();                             dt.Rows.Add(item);                             lines++;                         }                     }                 }             }               if (dt.Rows.Count > 0)             {                 string strConnection = "server=localhost;database=Data;uid=sa;pwd=123456;Connect Timeout=50000";                 SqlBulkCopyInsert(strConnection, "tb_csdn_data", dt);             }               Console.WriteLine("结束读取行数" + dt.Rows.Count + "...." + DateTime.Now.ToString());             Console.ReadLine();         }           public static void SqlBulkCopyInsert(string strConnection, string strTableName, DataTable dt)         {             try             {                 using (SqlBulkCopy sqlRevdBulkCopy = new SqlBulkCopy(strConnection))                 {                     sqlRevdBulkCopy.BulkCopyTimeout = 50000;                     sqlRevdBulkCopy.DestinationTableName = strTableName;                     sqlRevdBulkCopy.NotifyAfter = dt.Rows.Count;                     sqlRevdBulkCopy.WriteToServer(dt);                     sqlRevdBulkCopy.Close();                 }             }             catch (Exception ex)             {                 throw (ex);             }         }