register.aspx.cs

这是一个会员管理系统,有管理员与会员的两种权限,基于VS2005和SQL2000上进行的开发,适合初学者.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class register : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        string strconn = ConfigurationManager.ConnectionStrings["MMSConnectionString"].ConnectionString.ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        string mysql = "select * from Users where UID='" + this.TextBox1.Text + "'";
        SqlCommand cm = new SqlCommand(mysql, cn);
        SqlDataReader dr = cm.ExecuteReader();
        if (dr.Read())
        {
            args.IsValid= false;
        }
        else
        {
            args.IsValid= true;
        }
        cn.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            //存储过程的实现
            string strconn = ConfigurationManager.ConnectionStrings["MMSConnectionString"].ConnectionString.ToString();
            SqlConnection cn = new SqlConnection(strconn);
            cn.Open();
            SqlCommand cm = new SqlCommand("ueradd", cn);
            cm.CommandType = CommandType.StoredProcedure;
            cm.Parameters.Add("@UID", SqlDbType.VarChar);
            cm.Parameters.Add("@UPassword", SqlDbType.VarChar);
            cm.Parameters.Add("@UQuestion", SqlDbType.VarChar);
            cm.Parameters.Add("@UAnswer", SqlDbType.VarChar);
            cm.Parameters.Add("@USex", SqlDbType.Bit);
            cm.Parameters.Add("@UCitiID",SqlDbType.Int);
            cm.Parameters.Add("@Email",SqlDbType.VarChar);
            cm.Parameters["@UID"].Value=this.TextBox1.Text.ToString();
            cm.Parameters["@UPassword"].Value = this.TextBox2.Text.ToString();
            cm.Parameters["@UQuestion"].Value = this.TextBox4.Text.ToString();
            cm.Parameters["@UAnswer"].Value = this.TextBox5.Text.ToString();
            if (this.RadioButton1.Checked)
            {
                cm.Parameters["@USex"].Value = 1;
            }
            if (this.RadioButton2.Checked)
            {
                cm.Parameters["@USex"].Value = 0;
            }
            cm.Parameters["@UCitiID"].Value = this.DropDownList1.SelectedItem.Value;
            cm.Parameters["@Email"].Value = this.TextBox6.Text.ToString();
            cm.ExecuteNonQuery();
          
            cn.Close();
            Response.Redirect("registersuccess.aspx");
        }
    }
}