studInfo.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class personalInformation : System.Web.UI.Page
{
    SqlConnection conn;
    SqlCommand cmd1, cmd2;
    SqlDataReader dr1,dr2;

    protected void Page_Load(object sender, EventArgs e)
    {
        conn = sqldata.createCon();
        conn.Open();
        string claasID = Session["classID"].ToString();
        int homeID = Convert.ToInt32(Session["homeID"].ToString());

        string sql1 = "select deptName from dept inner join class on class.deptID=dept.deptID and classID=@classID";
        cmd1 = new SqlCommand(sql1, conn);
        SqlParameter id1 = new SqlParameter("@classID", SqlDbType.VarChar, 10);
        id1.Value = claasID;
        cmd1.Parameters.Add(id1);
        dr1=cmd1.ExecuteReader();
        if (dr1.Read())
        {
            this.Dept.Text = dr1["deptName"].ToString() + " "+ claasID.ToString()+"班";
        }
        conn.Close();

        conn.Open();
        string sql2 = "select eareName,floodName,homeNo from (eare inner join flood on eare.eareID=flood.eareID)inner join home on flood.floodID=home.floodID and homeID=@homeID";      
        cmd2 = new SqlCommand(sql2, conn);
        SqlParameter id2 = new SqlParameter("@homeID",SqlDbType.Int,4);
        id2.Value = homeID;
        cmd2.Parameters.Add(id2);
        dr2 = cmd2.ExecuteReader();
        if (dr2.Read())
        {
            this.home.Text = dr2["eareName"].ToString() + " " + dr2["floodName"].ToString() + " " + dr2["homeNo"].ToString();

        }
        this.studName.Text = Session["studName"].ToString();
        this.studNo.Text = Session["studNo"].ToString();
        this.Sex.Text = Session["Sex"].ToString();
        this.birthday.Text = Session["birthday"].ToString();
        this.shenfen.Text = Session["shenfen"].ToString();
        this.enterDate.Text = Session["enterDate"].ToString();
    }
}