数据库编程

开发平台：
Visual C++

stu_details.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 administration_details : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string stu_Id = Request.QueryString["stu_Id"].ToString();
        SqlConnection connection = DB.connect_la();
        connection.Open();
        string commandString = "SELECT exam_stu_table.* FROM exam_stu_table,stu_id_num WHERE stu_id_num.exam_id=exam_stu_table.exam_id and stu_id_num.stu_id='" + stu_Id+ "'";
        SqlCommand cmd = new SqlCommand(commandString, connection);
        SqlDataReader sdr = cmd.ExecuteReader();
        if (sdr.Read())
        {
            Label11.Text = sdr.GetValue(1).ToString();
            Label13.Text = sdr.GetValue(27).ToString();
            if (sdr.GetInt32(3) == 0)
                Label12.Text = "男";
            else
                Label12.Text = "女";
            Label14.Text = sdr.GetValue(13).ToString();
           
        }
        sdr.Close();
        commandString = "SELECT avg_point FROM stu_id_num WHERE  stu_id_num.stu_id=" + stu_Id;
        SqlCommand cmd1 = new SqlCommand(commandString, connection);
        SqlDataReader sdr1 = cmd1.ExecuteReader();
        if (sdr1.Read())
        {
            Label15.Text = sdr1.GetDecimal(0).ToString();
        }
        sdr1.Close();
        commandString = "SELECT * FROM thsis_data WHERE stu_id= " + stu_Id;
        SqlCommand cmd2 = new SqlCommand(commandString, connection);
        SqlDataReader sdr2 = cmd2.ExecuteReader();
        if (sdr2.Read())
        {
            Label6.Text = sdr2.GetValue(3).ToString();
            Label7.Text = sdr2.GetValue(4).ToString();
            Label8.Text = sdr2.GetValue(2).ToString();
            Label9.Text = sdr2.GetValue(1).ToString();
        }
        sdr2.Close();
        commandString = "SELECT thesis_state FROM thesis where stu_id=" + stu_Id;
        SqlCommand cmd3 = new SqlCommand(commandString, connection);
        SqlDataReader sdr3 = cmd3.ExecuteReader();
        if (sdr3.Read())
            Label10.Text = sdr3.GetValue(0).ToString();
        sdr3.Close();
        string teacherlists = "";
        Label1.Text = stu_Id;
       commandString = "SELECT thesis_total FROM thesis WHERE stu_id= " + stu_Id;
        SqlCommand cmd4 = new SqlCommand(commandString, connection);
        SqlDataReader sdr4 = cmd4.ExecuteReader();
        if (sdr4.Read())
            Label5.Text = sdr4.GetValue(0).ToString();
        sdr4.Close();
        commandString = "SELECT * FROM rep_to_arg where stu_id=" + stu_Id;
        SqlCommand cmd5 = new SqlCommand(commandString, connection);
        SqlDataReader sdr5 = cmd5.ExecuteReader();
        if (sdr5.Read())
        {
            teacherlists = sdr5.GetValue(3).ToString();
            Label3.Text = sdr5.GetValue(1).ToString();
            Label4.Text = sdr5.GetValue(2).ToString();
        }
        sdr5.Close();
        int beginIndex = 0;
        //提取答辩老师姓名
        for (int i = 0; (beginIndex + i) < teacherlists.Length; i++)
        {
            commandString = "SELECT tea_name FROM tea_table where tea_id=" + teacherlists.Substring(beginIndex, 8);
            SqlCommand cmd6 = new SqlCommand(commandString, connection);
            SqlDataReader sdr6 = cmd6.ExecuteReader();
            Label1.Text = stu_Id;
            if (sdr6.Read())
            {
                if (0 == beginIndex)
                {
                    Label2.Text = sdr6.GetValue(0).ToString();
                }
                else
                {
                    Label2.Text += ", ";
                    Label2.Text += sdr6.GetValue(0).ToString();
                }
            }
            sdr6.Close();
            beginIndex += 9;
        }
        commandString = "SELECT tea_table.tea_name FROM tea_table,stu_tea where tea_table.tea_id = stu_tea.tea_id and stu_tea.sut_id = " + stu_Id;
        SqlCommand cmd7 = new SqlCommand(commandString, connection);
        SqlDataReader sdr7 = cmd7.ExecuteReader();
        if (sdr7.Read())
        {
            Label6.Text = sdr7.GetValue(0).ToString();
        }
        sdr7.Close();
        connection.Close();
    }
}

						