【用户注册主要代码】源程序如下：

protected void Button1_Click(object sender, EventArgs e)
{
   DB db = new DB();//新建数据库连接
   string cmdtxt = "select count(*)from login where UserName='" + this.txtUserName.Text + "'";
   string cmd = "select count(*)from login where AuthorityNum='" + this.AuthorityNum.Text + "'";
   if (db.reDt(cmd).Rows[0][0].ToString() != "0")//判断是否授权
   {
    if (db.reDt(cmdtxt).Rows[0][0].ToString() == "0")//判断用户名是否存在
    {
     if (Session["validateNum"].ToString().ToLower() == txtValidateNum.Text.ToLower())//判断验证码
     {
     string sqlStr = "insert into login(UserName,PassWord,Email,AuthorityNum)values('" + txtUserName.Text + "','" + txtPwd1.Text + "','" + MailBox.Text + "','" + AuthorityNum.Text + "')";//向数据库中插入注册用户
     db.sqlEx(sqlStr);//执行
     this.DataBind();
     // Response.Write("
     Response.Write("
     Clear();
     }
     else
     {
      Response.Write("
     }
    }
    else
    {
     Response.Write("
     Clear();
     }

     }
   else
   {
    Response.Write("
    Clear();
    }

 }

//清除注册信息
public void Clear()
{
 this.txtUserName.Text = "";
 this.MailBox.Text = "";
 this.txtValidateNum.Text = "";
}

//返回登录【注意要是该按键起作用必须使它的属性中CausesValidation改为false。否则不起作用】
protected void BackButton_Click(object sender, EventArgs e)
{
 Response.Redirect("/Login/login.aspx");
}

    public class DB
    {
        public DB()
        { 
        }
/// SQL数据库连接SqlConnection
/// 连接的数据库

//

//..

//
//
//

//..

//

public SqlConnection GetCon()
{
return new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());
}

/// SQL执行语句
/// 可以改为想要的类型并实现返回值
public void sqlEx(string cmdstr)
{
 SqlConnection con = GetCon();
 con.Open();
 SqlCommand cmd = new SqlCommand(cmdstr, con);
 cmd.ExecuteNonQuery();
}

/// SQL执行查询语句
/// 将符合条件的数据已表格形式返回
public DataTable reDt(string cmdstr)
{
 SqlConnection con = GetCon();
 SqlDataAdapter da = new SqlDataAdapter(cmdstr, con);
 DataSet ds=new DataSet();
 da.Fill(ds);
 return (ds.Tables[0]);
}

/// 执行查询语句
/// 无法继承此类
/// 返回SqlDataReader对象dr
public SqlDataReader reDr(string str)
{
 SqlConnection conn = GetCon();
 conn.Open();
 SqlCommand com = new SqlCommand(str, conn);
 SqlDataReader dr=com.ExecuteReader(CommandBehavior.CloseConnection);
 return dr;
}

}