XDF/Student/ModifyInfo.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.SqlClient;
using System.Configuration;
using BLL;

namespace XDF.Student
{
    public partial class ModifyInfo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack == false)
            {

                if (Session["UserRole"] == null)
                    Response.Redirect("~/Login.aspx");
                
                 
                string stuname = getStuName(Session["UserID"].ToString());
                string stuID = Session["UserID"].ToString();
                string sex = getSex(Session["UserID"].ToString());
                string grade = getGrade(Session["UserID"].ToString());
                string phone = getPhone(Session["UserID"].ToString());
                string email = getEmail(Session["UserID"].ToString());
                LabelStuID.Text = stuID;
                TextBoxStuName.Text=stuname;
                RadioButtonListSex.SelectedValue = sex;
                DropDownListGrade.SelectedValue =grade;
                TextBoxPhone.Text=phone;
                TextBoxEmail.Text=email;
            }
        }
       
         private string getStuName(string stuID)
        {
            string result = "";
            try
            {
                // 1. 创建连接
                SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

                // 2. 打开连接
                connection.Open();

                // 2.1 创建命令对象
                SqlCommand command = null;
                
                    command = new SqlCommand("select StuName from Student where StuID=@StuID", connection);
                    command.Parameters.AddWithValue("@StuID", stuID);
               
               
                // 2.2 执行命令对象
                result = command.ExecuteScalar().ToString();

                // 3. 关闭连接