DataTable，sqlServer批量写入

       static void Main(string[] args)
        {

             List<string> a = new List<string>();
            //生成数据
             while (a.Count<100000) 
             {
                 var result = new StringBuilder();
                 int length = 10;
                 for (var i = 0; i < length; i++)
                 {
                     var r = new Random(Guid.NewGuid().GetHashCode());
                     result.Append(r.Next(0, 10));
                 }
            a.Add(result.ToString().Trim());

            }
           
            
            //创建一个表存数据
            DataTable OrderInfo = new DataTable("OrderInfo");
            OrderInfo.Columns.Add("orderId");
            
            //把数据存到表里
            foreach (string  item in a)
            {
                DataRow dr = OrderInfo.NewRow();
                dr["orderId"] = item;
                OrderInfo.Rows.Add(dr);
                
            }
            string c = "";
          
            ExecuteNoquery("",OrderInfo);
            
            
        }

        public static void ExecuteNoquery(string sqlStr,DataTable info) {
            //读取连接字符串
            string strReadFilePath = @"D:\sqlStr.txt";
            // 读取文件的源路径及其读取流
            StreamReader srReadFile = new StreamReader(strReadFilePath);
            // 读取流直至文件末尾结束
            string strReadLine = "";
            while (!srReadFile.EndOfStream)
            {
                 strReadLine = srReadFile.ReadLine(); //读取每行数据
            }
            // 关闭读取流文件
            srReadFile.Close();
            
            //通过存储过程写入数据
            string conStr = strReadLine;
            SqlConnection con = new SqlConnection(conStr);
            con.Open();
            SqlCommand cmd = new SqlCommand("AddOrderInfo", con);//存储过程名称
            cmd.CommandType = CommandType.StoredProcedure;//调用类型
            cmd.Parameters.Add("orderId","nvarchar(20)"); //存储过程 参数1
            cmd.Parameters.Add("info", "nvarchar(20)");   // 参数 2
            foreach (DataRow item in info.Rows)
	       {
               cmd.Parameters["orderId"].Value = item["orderId"].ToString(); //参数赋值
               cmd.ExecuteNonQuery(); //执行 存储过程
		    }
            
            con.Close();
            /*
             * 
             * //通过 SqlBulkCopy 批量写入数据
            SqlBulkCopy copy = new SqlBulkCopy(con); 
            copy.DestinationTableName = "orderInfo";
            copy.BatchSize = info.Rows.Count;
            
            Stopwatch sw = new Stopwatch(); //程序计时
            sw.Start();
            copy.WriteToServer(info);
            sw.Stop();
            Console.WriteLine("用时：" + sw.ElapsedMilliseconds);
            copy.Close();
            con.Close();


                //通过insert语句写入数据
            con.Open();
            SqlCommand cmd = new SqlCommand(sqlStr, con);
            int rows = cmd.ExecuteNonQuery();
            con.Close();
            return rows;
             */
        }