黑马程序员 使用SqlBulkCopy大批量导入数据

//使用SqlBulkCopy大批量导入数据         
        private void btnBulk_Click(object sender, RoutedEventArgs e)
        {
            string connStr = ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString;
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "文本文件|*.txt";
            if (ofd.ShowDialog() == false)
            {
                return;
            }
            string[] lines =
                File.ReadLines(ofd.FileName, Encoding.Default).ToArray();
            //构造一个Datatable存储将要批量导入的数据
            DataTable table = new DataTable();
            table.Columns.Add("StartTelNum");
            table.Columns.Add("City");
            table.Columns.Add("TelType");
            for (int i = 1; i < lines.Count(); i++)
            {
                string line = lines;
                string[] strs = line.Split('\t');//去掉两边的双引号："北京市"
                string startTelNum = strs[0];
                string city = strs[1];
                city = city.Trim('"');
                string telType = strs[2];
                telType = telType.Trim('"');
                DataRow dr = table.NewRow();
                dr["StartTelNum"] = startTelNum;
                dr["City"] = city;
                dr["TelType"] = telType;
                table.Rows.Add(dr);
            }
            //实际的开发可能会遇到数据大批量插入数据的问题，若是一条条的循环导入效率非常低下,使用SqlBulkCopy大批量导入数据。
            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connStr))
            {
                //设置要批量写入的表
                bulkCopy.DestinationTableName = "T_TelNum";
                //自定义的datatable和数据库的字段进行对应
                bulkCopy.ColumnMappings.Add("StartTelNum","StartTelNum");
                bulkCopy.ColumnMappings.Add("City", "TelArea");
                bulkCopy.ColumnMappings.Add("TelType", "TelType");
                //自定义的datatable和数据库的字段进行对应
                bulkCopy.WriteToServer(table);
            }
        }

        //一条一条的循环导入数据
        private void btnImport_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "文本文件|*.txt";
            if (ofd.ShowDialog() == false)
            {
                return;
            }
            string[] lines =
                File.ReadLines(ofd.FileName, Encoding.Default).ToArray();
            //跳过第一行表头
            for (int i = 1; i < lines.Count(); i++)
            {
                string line = lines[i];
                string[] strs = line.Split('\t');
                string startTelNum = strs[0];
                string city = strs[1];
                city = city.Trim('"');
                string telType = strs[2];
                telType = telType.Trim('"');

                SqlHelper.ExecuteNonQuery("insert into T_TelNum(StartTelNum,TelType,TelArea) values(@StartTelNum,@TelType,@TelArea)",
                    new SqlParameter("@StartTelNum", startTelNum),
                    new SqlParameter("@TelType", telType),
                    new SqlParameter("@TelArea", city));
            }
            MessageBox.Show("导入成功");
        }