从文本文件中往数据库中导入数据

 

{
            #endregion
            #region 数据导入
            string constr = "data source=.;initial catalog=itcast2013;integrated security=true";
            using (StreamReader sr = new StreamReader(@"f:\person.txt"))
            {
                using (SqlConnection con = new SqlConnection(constr))
                {
                    string sqlstr = "insert into tblperson values(@uname,@uage,@uheight)";
                    using (SqlCommand cmd = new SqlCommand(sqlstr, con))
                    {
                        //使用带参数的sql语句时,不要把增加参数的代码写在循环中...否则就重复增加参数啦
                        //解决思路:先声明参数对象,不赋值,在循环里再赋值.如下
                        SqlParameter[] spt = new SqlParameter[]
                   {
                   new SqlParameter("@uname",System.Data.SqlDbType.NVarChar,50),
                   new SqlParameter ("@uage",System.Data.SqlDbType.Int),
                   new SqlParameter("@uheight",System.Data.SqlDbType.Int)
                   };
                        //添加参数
                        cmd.Parameters.AddRange(spt);

                        string line = sr.ReadLine();
                        con.Open();
                        while ((line = sr.ReadLine()) != null)
                        {
                            string[] parts = line.Split(',');
                            //Console.WriteLine("{0}, {1}, {2} ,{3}",parts[0],parts[1],parts[2],parts[3]);
                            string uname = parts[1];
                            int uage = parts[2].Length > 0 ? Convert.ToInt32(parts[2]) : -1;
                            int uheight = parts[3].Length > 0 ? Convert.ToInt32(parts[3]) : -1;
                            //给参数赋值
                            spt[0].Value = uname;
                            spt[1].Value = uage == -1 ? DBNull.Value : (object)uage;
                            spt[2].Value = uheight == -1 ? DBNull.Value : (object)uheight;
                            cmd.ExecuteNonQuery();

                            //如果想要在循环中增加参数,需要每次执行完毕之后再清空一下
                            //cmd.Parameters.Clear();
                        }

                    }
                }
            }
            #endregion
            Console.ReadKey();
        }