xueshengzhuce.aspx.cs

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

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

public partial class xueshengzhuce : System.Web.UI.Page
{
    DBLink db = new DBLink();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            yuanxiInfo();
        }
    }
    private void yuanxiInfo()
    {
        string sql;
        sql = "select * from yuanxi order by id desc";
        DataSet result = new DataSet();
        result = db.hsggetdata(sql);
        for (int i = 0; i < result.Tables[0].Rows.Count; i++)
        {
            DropDownList2.Items.Add(result.Tables[0].Rows[i]["Name"].ToString());
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string xuehao = this.Number.Text;
        string xingming = this.xingming.Text;
        string xingbie = this.xingbie.Text;
        string nianling = this.nianling.Text;
        string dianhua = this.Tel.Text;
        string xibu = this.DropDownList2.Text;
        string strsql = "select * from xuesheng where xuehao='" + xuehao + "'";
        DataSet result = new DataSet();
        result = db.hsggetdata(strsql);
        if (result.Tables[0].Rows.Count > 0)
        {
            Response.Write("<script>javascript:alert('学生学号已经存在，不能重复注册！');</script>");
            return;
        }
        strsql = "Insert into xuesheng(xuehao,xingming,xingbie,nianling,dianhua,xibu,mima)values('" + xuehao + "','" + xingming + "','" + xingbie + "','" + nianling + "','" + dianhua + "','" + xibu + "','"+this.Pass1.Text+"')";
        int n;
        n = db.hsgexucute(strsql);
        if (n == 1)
        {
            Response.Write("<script language=javascript>alert('注册成功！');location='Default.aspx'</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('系统错误，请检查数据库的连接！');</script>");
        }
    }
}