将文本中的数据写入数据库

       string sLine = "";
       string txtFileName = "D:\\fanti.txt";     //完整路径
         
        StreamReader TxtReader = new StreamReader(txtFileName,Encoding.Default);

        string str="server=.\\sqlexpress;initial catalog=lianxi;integrated security=true";   //链接字符串

        using (SqlConnection con = new SqlConnection(str))
        {
           try
           {
               do
                {
                    sLine = TxtReader.ReadLine();
                 
                    if (sLine == null)
                        break;
                   
                    using (SqlCommand com = con.CreateCommand())
                    {
                        com.CommandText = "insertJianti";
                        com.CommandType = CommandType.StoredProcedure;    //sql的类型为存储过程
                        com.Parameters.AddWithValue("@readline",sLine);
                        con.Open();
                        com.ExecuteNonQuery();
                    }
                    con.Close();

                } while (true);
                TxtReader.Close();
            }
            catch (Exception ex)
            {
                Response.Write("<script>alert('" + ex.Message + "')</script>");
            }
            finally
            {
                if (con.State.ToString() == "Open")
                    con.Close();
                if (TxtReader != null)
                    TxtReader.Close();
            }

           
        }