TXT导入到数据库

                openFileDialog1.Filter = "文本文件(*.txt)|*.txt";
                openFileDialog1.ShowDialog();
                textBox1.Text = openFileDialog1.FileName;
                StreamReader SReader = new StreamReader(textBox1.Text, Encoding.Default);

                //ArrayList arr = new ArrayList();
                List<string> arr = new List<string>();

                string s;
                while ((s = SReader.ReadLine()) != null)
                {
                    arr.Add(s);
                }

                for (int i = 1; i < arr.Count; i++)
                {



                    string pattern = @"\s*,\s*|\s+";//表达式模式（正则表达式）   
                    // “\s”表示空格，“\s*”表示0个或多个空格，“\s+”表示1个或多个空格 
                    string[] tabhead = Regex.Split(arr[i], pattern);

                   
                       // textBox2.AppendText(tabhead[j] + '\n');


                        string sql = "insert testtxtIn1(wellname,x,y,z,h) values(@wellname,@x,@y,@z,@h)";
                        SqlParameter[] paras = new SqlParameter[] 
                        {
            
                            new SqlParameter("@wellname",tabhead[0]),
                            new SqlParameter("@x",Convert.ToDecimal(tabhead[1])),
                            new SqlParameter("@y",Convert.ToDecimal(tabhead[2])),
                            new SqlParameter("@z",Convert.ToDecimal(tabhead[3])),
                            new SqlParameter("@h",Convert.ToDecimal(tabhead[4]))
                            //    new SqlParameter("@x",tabhead[1]),
                            //new SqlParameter("@y",tabhead[2]),
                            //new SqlParameter("@z",tabhead[3]),
                            //new SqlParameter("@h",tabhead[4])
 
                            };

                        sqlhelper.ExecuteNonQuery(sql, paras, CommandType.Text);
                    




                }