stu_course_info.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 coursemessage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["user_id"] == null)
        {
            Response.Redirect("default.aspx");
        }
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections = new SqlConnection(strconn);
        string strsql = "select Crname,Tname,Tcol,Crelse from tabcour,tabtea,tabtea_cour where tabcour.Crid=@Crid and tabtea.Tid=tabtea_cour.Tid and tabtea_cour.Crid=tabcour.Crid";
        SqlCommand commnd = new SqlCommand(strsql, connections);
        commnd.Parameters.Add(new SqlParameter("@crid", SqlDbType.VarChar, 50));
        commnd.Parameters["@crid"].Value = Request.QueryString["Crid"];
        connections.Open();
        SqlDataReader sdreader = commnd.ExecuteReader();
        if (sdreader.Read())
        {
            lblCourse.Text = sdreader["Crname"].ToString();
            lblTeacher.Text = sdreader["Tname"].ToString();
            lblCollege.Text = sdreader["Tcol"].ToString();
        }
        else
        {
            Response.Write("该课程尚未分配教师，请首先执行【课程分配】操作！");            
        }
        connections.Close();
    }
    protected void lbtnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("stu_course.aspx");
    }
}