xueshengReg.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

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

    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        //验证学生学号是否已经存在
        if (DbHelperSQL.Exists("select count(*) from student where number = '" + txt_number.Text + "' "))
        {
            MessageBox.Show(this, "该学生学号已存在，请重新输入！");
            return;
        }
        if (txt_pass2.Text != txt_pass.Text)
        {
            MessageBox.Show(this, "两次密码不一致, 请确认！");
            return;
        }
        string number = this.txt_number.Text;
        string pass = this.txt_pass.Text;
        string name = this.txt_name.Text;
        string age = this.txt_age.Text;
        string sex = this.sex.Text;
        string tel = this.txt_tel.Text;
        string college = this.txt_college.Text;
        string major = this.txt_major.Text;
        string family = this.txt_family.Text;
        string strsql = "Insert into student(number,pass,name,age,sex,tel,college,major,family)values(";
        strsql += " '" + number + "','" + pass + "','" + name + "','" + age + "','" + sex + "','" + tel + "','" + college + "','" + major + "','" + family + "')";
        int n = DbHelperSQL.ExecuteSql(strsql);
        if (n > 0)
        {
            MessageBox.ShowAndRedirect(this, "注册成功！", "default.aspx");
        }
        else 
        {
            MessageBox.Show(this, "注册失败！");
        }
    }
}