导入手机归属地

  /// <summary>
    /// TelSearchWindow.xaml 的交互逻辑
    /// </summary>
    public partial class TelSearchWindow : Window
    {
        public TelSearchWindow()
        {
            InitializeComponent();
        }

        private static string connStr = ConfigurationManager.ConnectionStrings["adConnStr"].ConnectionString;
        private void btnImport_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "文本文件 |*.txt";
            if (ofd.ShowDialog() == false )
            {
                return;

            }
         IEnumerable <string > lines
             = File.ReadLines(ofd.FileName, Encoding.Default);
         using (SqlConnection conn = new SqlConnection(connStr))
         {
             conn.Open();
             //for (int i = 1; i < lines.Count(); i++)
                 for (int i = 1; i < 10000; i++)
                 {
                     string line = lines.ElementAt(i);
                     string[] strs = line.Split('\t'); //VS里‘\t’为制表符
                     string startTelNum = strs[0];
                     string city = strs[1];
                     city = city.Trim('"');
                     string telType = strs[2];
                     telType = telType.Trim('"');

                     using (SqlCommand cmd = conn.CreateCommand())
                     {
                     cmd.CommandText = "Insert into T_TelNum(StartTelNum, TelType,TelArea) values(@StartTelNum,@TelType,@TelArea)";
                     cmd.Parameters.Add(new SqlParameter("@StartTelNum", startTelNum));
                     cmd.Parameters.Add(new SqlParameter("@TelType", telType));
                     cmd.Parameters.Add(new SqlParameter("@TelArea", city));
                     cmd.ExecuteNonQuery();
                     //  cmd.ExecuteNonQuery(); //执行
//                     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("导入成功！");
         }
          
        }
    }