求一个用户注册的程序

Question

一个用户名，两个密码框，用C#写一个用户注册的代码，麻烦写详细一点包括怎么连数据库，怎么往表里面插入数据，谢谢

Answer 1

哦NO才20分给你写一个吧数据库里表名为users ，四个字段UserName,UserPwd,Email,question,answer代码如下 protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {            if (TextBox2.Text.Length < 5 || TextBox2.Text.Length > 15)
            {
                label1.Text = "密码长度不合规则密码长度为:8-15";
            }
            if (TextBox5.Text.Length == 0 || TextBox6.Text.Length == 0)
            {
                Response.Write("安全提问和安全回答不能为空");
            }
            else
            {
                SqlConnection sqlconnection = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
                sqlconnection.Open();
                SqlCommand sqlcommadn = new SqlCommand("select UserName from Users where UserName='" + Request.Form["TextBox1"].Trim() + "'", sqlconnection);
                SqlDataReader sqlread = sqlcommadn.ExecuteReader();
                if (sqlread.Read() == false)
                {
                    sqlread.Close();
                    string mystring = "insert into users (UserName,UserPwd,Email,question,answer)values ('" + Request.Form["TextBox1"].Trim() + "','" + Request.Form["TextBox2"].Trim() + "','" + Request.Form["TextBox4"].Trim() + "','" + Request.Form["TextBox5"].Trim() + "','" + Request.Form["TextBox6"].Trim() + "')";
                    SqlCommand sqlcommand2 = new SqlCommand(mystring, sqlconnection1);
                    sqlcommand2.ExecuteNonQuery();
                    Response.Write("<script>alert('恭喜你,注册成功！');</script> ");
                    Response.Write("<script>window.location.href='login.aspx';</script>");
                    sqlconnection1.Close();
                }
                else
                {
                    Response.Write("<script>alert('对不起,这个用户已经注册了！请重新换一个试试看！！');</script> ");
                }
                sqlread.Close();
                sqlconnection.Close();
            }
        }
        catch(Exception abc)
        {
            Response.Write("有错误发生！<br/>"+abc.ToString());
        }
    }web.config里这样写
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings>
<add key="conStr" value="Server=(local);database=你的数据库名;Uid=sa;Pwd="/>
</appSettings>
<connectionStrings>
OK手里还有活简单写一个

Answer 2

运行怎么有错误啊，大哥
System.InvalidOperationException: ConnectionString 属性尚未初始化。 在 System.Data.SqlClient.SqlConnection.PermissionDemand() 在 System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) 在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 在 System.Data.SqlClient.SqlConnection.Open() 在 userReg.Button1_Click(Object sender, EventArgs e)