向数据库导入数据

            OpenFileDialog Ofd = new OpenFileDialog();
            Ofd.Filter = "文本文件|*.txt";
            if (Ofd.ShowDialog () !=true )
            {
                return;
            }
            string fileName = Ofd.FileName ;

            //File.ReadLines是吧文件一次读取到string 集合中
            //对于大文件，用 FileStream
            IEnumerable <string >lines = File.ReadLines (fileName,Encoding.Default  );
            foreach(string line in  lines)
            {
                //把 行按照 空格 分隔
                string[] segs = line.Split(' '); //new string {"hhh","20"}
                string name = segs[0];
                string age = segs[1];
                SqlHelper.ExecuteNonQuery("Insert into T_Customer(Name,Age) values(@Name,@Age)"
                    , new SqlParameter("@Name", name)
                    , new SqlParameter("@Age", Convert.ToInt32(age)));
            }

            MessageBox .Show ("导入成功！"+ lines.Count ()+"条数据");