student_basicinfo.aspx.cs

该系统是一个集成多功能的信息管理系统

        SqlCommand sd23 = new SqlCommand("select entranceDate  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string entranceDate = Convert.ToString(sd23.ExecuteScalar());
        this.entranceDate.Text = entranceDate;
        SqlCommand sd24 = new SqlCommand("select graduateSchool  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string graduateSchool = Convert.ToString(sd24.ExecuteScalar());
        this.graduateSchool.Text = graduateSchool;
        SqlCommand sd25 = new SqlCommand("select dormitoryCode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string dormitoryCode = Convert.ToString(sd25.ExecuteScalar());
        this.dormitoryCode.Text = dormitoryCode;
        SqlCommand sd26 = new SqlCommand("select email  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string email = Convert.ToString(sd26.ExecuteScalar());
        this.email.Text = email;
        SqlCommand sd27 = new SqlCommand("select tel  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string tel = Convert.ToString(sd27.ExecuteScalar());
        this.tel.Text = tel;
        SqlCommand sd28 = new SqlCommand("select postalCode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string postalCode = Convert.ToString(sd28.ExecuteScalar());
        this.postalCode.Text = postalCode;
        SqlCommand sd29 = new SqlCommand("select testproveCode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string testproveCode = Convert.ToString(sd29.ExecuteScalar());
        this.testproveCode.Text = testproveCode;
        SqlCommand sd30 = new SqlCommand("select educationalLevel  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string educationalLevel = Convert.ToString(sd30.ExecuteScalar());
        this.educationalLevel.Text = educationalLevel;
        SqlCommand sd31 = new SqlCommand("select gangaotaiCode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string gangaotaiCode = Convert.ToString(sd31.ExecuteScalar());
        this.gangaotaiCode.Text = gangaotaiCode;
        SqlCommand sd32 = new SqlCommand("select reportCode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string reportCode = Convert.ToString(sd32.ExecuteScalar());
        this.reportCode.Text = reportCode;
        SqlCommand sd33 = new SqlCommand("select ifathlete  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string ifathlete = Convert.ToString(sd33.ExecuteScalar());
        this.ifathlete.Text = ifathlete;
        SqlCommand sd34 = new SqlCommand("select englishGrade  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string englishGrade = Convert.ToString(sd34.ExecuteScalar());
        this.englishGrade.Text = englishGrade;
        SqlCommand sd35 = new SqlCommand("select englishMark  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string englishMark = Convert.ToString(sd35.ExecuteScalar());
        this.englishMark.Text = englishMark;
        SqlCommand sd36 = new SqlCommand("select lujianCode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string lujianCode = Convert.ToString(sd36.ExecuteScalar());
        this.lujianCode.Text = lujianCode;
        SqlCommand sd37 = new SqlCommand("select strongSuit  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string strongSuit = Convert.ToString(sd37.ExecuteScalar());
        this.strongSuit.Text = strongSuit;
        SqlCommand sd38 = new SqlCommand("select partyTime  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string partyTime = Convert.ToString(sd38.ExecuteScalar());
        this.partyTime.Text = partyTime;
        SqlCommand sd39 = new SqlCommand("select trainDestination  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string trainDestination = Convert.ToString(sd39.ExecuteScalar());
        this.trainDestination.Text = trainDestination;
        SqlCommand sd40 = new SqlCommand("select handphoneStyle  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string handphoneStyle = Convert.ToString(sd40.ExecuteScalar());
        this.handphoneStyle.Text = handphoneStyle;
        SqlCommand sd41 = new SqlCommand("select handphoneNumber  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string handphoneNumber = Convert.ToString(sd41.ExecuteScalar());
        this.handphoneNumber.Text = handphoneNumber;
        SqlCommand sd42 = new SqlCommand("select homePostalcode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string homePostalcode = Convert.ToString(sd42.ExecuteScalar());
        this.homePostalcode.Text = homePostalcode;
        SqlCommand sd43 = new SqlCommand("select homeTel  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string homeTel = Convert.ToString(sd43.ExecuteScalar());
        this.homeTel.Text = homeTel;
        SqlCommand sd44 = new SqlCommand("select fatherName  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string fatherName = Convert.ToString(sd44.ExecuteScalar());
        this.fatherName.Text = fatherName;
        SqlCommand sd45 = new SqlCommand("select fatherWorkplace  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string fatherWorkplace = Convert.ToString(sd45.ExecuteScalar());
        this.fatherWorkplace.Text = fatherWorkplace;
        SqlCommand sd46 = new SqlCommand("select fatherPostalcode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string fatherPostalcode = Convert.ToString(sd46.ExecuteScalar());
        this.fatherPostalcode.Text = fatherPostalcode;
        SqlCommand sd47 = new SqlCommand("select motherName  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string motherName = Convert.ToString(sd47.ExecuteScalar());
        this.motherName.Text = motherName;
        SqlCommand sd48 = new SqlCommand("select motherWorkplace  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string motherWorkplace = Convert.ToString(sd48.ExecuteScalar());
        this.motherWorkplace.Text = motherWorkplace;
        SqlCommand sd49 = new SqlCommand("select motherPostalcode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string motherPostalcode = Convert.ToString(sd49.ExecuteScalar());
        this.motherPostalcode.Text = motherPostalcode;
        SqlCommand sd50 = new SqlCommand("select fatherTel  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string fatherTel = Convert.ToString(sd50.ExecuteScalar());
        this.fatherTel.Text = fatherTel;
        SqlCommand sd51 = new SqlCommand("select motherTel  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string motherTel = Convert.ToString(sd51.ExecuteScalar());
        this.motherTel.Text = motherTel;
        SqlCommand sd52 = new SqlCommand("select homeAddress  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string homeAddress = Convert.ToString(sd52.ExecuteScalar());
        this.homeAddress.Text = homeAddress;
        SqlCommand sd53 = new SqlCommand("select homeLocus  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string homeLocus = Convert.ToString(sd53.ExecuteScalar());
        this.homeLocus.Text = homeLocus;
        SqlCommand sd54 = new SqlCommand("select remark  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string remark = Convert.ToString(sd54.ExecuteScalar());
        this.remark.Text = remark;
        
    }
}