UserReg.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

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


    protected void Button1_Click(object sender, EventArgs e)
    {
        string SQL = "select * from tb_Member where MemberName='" + this.TextBox1.Text.Trim() + "'";
        DataSet ds = DBHelper.GetDataSet(SQL);
        if (ds.Tables[0].Rows.Count > 0)
        {
            Response.Write("<script language='javascript'>alert('该用户已经被注册，请重新注册！');window.navigate('UserReg.aspx');</script>");
        }
        else
        {
            string name = this.TextBox1.Text.Trim();
            string pwd = this.TextBox2.Text.Trim();
            string sex = this.DropDownList1.SelectedItem.Text.Trim();
            string realname = this.TextBox4.Text.Trim();

            string mobiletel = this.TextBox7.Text.Trim();
            string email = this.TextBox8.Text.Trim();
            string address = this.TextBox5.Text.Trim();
            string code = this.TextBox6.Text.Trim();

            string sql1 = "insert into tb_Member(MemberName,MemberPwd,Sex,RealName,MobileTel,Email,Address,Code) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
            string sql2 = string.Format(sql1, name, pwd, sex, realname, mobiletel, email, address, code);//有几个占位符，就要传递几个变量值，而且要一一对应

            bool iRet = DBHelper.ExecSql(sql2);
            if (iRet)
            {

                Response.Write("<script language='javascript'>alert('注册成功！');window.navigate('Default.aspx');</script>");
            }
            else
            {
                Response.Write("<script language='javascript'>alert('注册失败！');location='javascript:history.go(-1)';</script>");
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.TextBox1.Text = "";
        this.TextBox2.Text = ""; this.TextBox3.Text = "";
        this.TextBox4.Text = "";
        this.TextBox5.Text = "";