xiugaiInfo.aspx.cs

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

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

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 xiugaiInfo : System.Web.UI.Page
{
    DBLink db = new DBLink();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            yuanxiInfo();
            string sql;
            sql = "select * from xuesheng where id=" + Session["xueshengID"].ToString().Trim();
            DataSet result = new DataSet();
            result = db.hsggetdata(sql);
            if (result.Tables[0].Rows.Count > 0)
            {
                this.Number.Text = result.Tables[0].Rows[0]["xuehao"].ToString().Trim();
                this.xingming.Text = result.Tables[0].Rows[0]["xingming"].ToString().Trim();
                this.xingbie.Text = result.Tables[0].Rows[0]["xingbie"].ToString().Trim();
                this.nianling.Text = result.Tables[0].Rows[0]["nianling"].ToString().Trim();
                this.Tel.Text = result.Tables[0].Rows[0]["dianhua"].ToString().Trim();
                DropDownList2.Text = result.Tables[0].Rows[0]["xibu"].ToString().Trim();  
            }
        }
       
    }
    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 + "' and id !=" + Session["xueshengID"].ToString().Trim() + "";
        DataSet result = new DataSet();
        result = db.hsggetdata(strsql);
        if (result.Tables[0].Rows.Count > 0)
        {
            Response.Write("<script>javascript:alert('学生学号已经存在，不能重复！');</script>");
            return;
        }