把数据库里面的内容导入到文本中（数据库导出）

   protected void Button2_Click(object sender, EventArgs e)
        {
            using (StreamReader sr = new StreamReader(@"F:\1109ADO\tclUser.txt"))
            {
                string connStr = @"data source=.\SQLEXPRESS;initial catalog=Test;User ID=sa;Password=admin";
                using (SqlConnection conn = new SqlConnection(connStr))
                {
                    string sql = "insert into Login(UserName,Password)values(@username,@password)";
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                    {
                        SqlParameter p1 = new SqlParameter("@username",System.Data.SqlDbType.VarChar);
                            SqlParameter p2 = new SqlParameter("@password", System.Data.SqlDbType.VarChar);
                            cmd.Parameters.Add(p1);
                            cmd.Parameters.Add(p2);
                        while (!sr.EndOfStream)
                        {
                           
                            string line = sr.ReadLine();
                            string[] columns = line.Split(',');
                            //Response.Write(columns[0]+"&nbsp"+columns[1]+"<br>");
                            //SqlParameter p1 = new SqlParameter("@name", columns[0]);
                            //SqlParameter p2 = new SqlParameter("@pwd", columns[1]);
                            conn.Open();
                            p1.Value=columns[0];
                            p2.Value=columns[1];
                           
                           
                            cmd.ExecuteNonQuery();
                            conn.Close();
                        }
                    }
                }
            }
        }