MyInfo.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 MyInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            string sql;
            sql = "select * from xuesheng where ID=" + Session["userid"].ToString().Trim();

            DataSet result = new DataSet();
            sqlConn conn = new sqlConn();
            result = conn.hsggetdata(sql);
            if (result != null)
            {
                this.xuehao.Text = result.Tables[0].Rows[0]["xuehao"].ToString();
                this.xingming.Text = result.Tables[0].Rows[0]["xingming"].ToString();
                this.xingbie.Text = result.Tables[0].Rows[0]["xingbie"].ToString();
                this.xueyuan.Text = result.Tables[0].Rows[0]["xueyuan"].ToString();
                this.zhuanye.Text = result.Tables[0].Rows[0]["zhuanye"].ToString();
                this.dianhua.Text = result.Tables[0].Rows[0]["dianhua"].ToString();

            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        sqlConn conn = new sqlConn();
        string xingming = this.xingming.Text;
        string xingbie = this.xingbie.Text;
        string dianhua = this.dianhua.Text;
        string xueyuan = this.xueyuan.Text;
        string zhuanye = this.zhuanye.Text;
        string strsql = "Update xuesheng set xingming='" + xingming + "',xingbie='" + xingbie + "',dianhua='" + dianhua + "',xueyuan='" + xueyuan + "',zhuanye='" + zhuanye + "' where ID=" + Session["userid"].ToString().Trim();
        int result;
        result = conn.hsgexucute(strsql);
        if (result == 1)
        {
            Response.Write("<script language=javascript>alert('修改成功！');location='Default.aspx'</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('系统错误，请检查数据库的连?);</script>");
        }
    }
}