st_course_teacher.aspx.cs

来自「学生管理系统。C#开发。偏重与数据库的应用。」· CS 代码 · 共 35 行

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 ST_course_teacher : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 在此处放置用户代码以初始化页面
        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
        SqlConnection st_conn = new SqlConnection(st_connstr);
        string st_sqlstr = "select ST_Course_name,ST_Teacher_name,ST_Teacher_college,ST_Course_describe,ST_Class_name from ST_course,ST_teacher,ST_teacher_course,ST_class where ST_course.ST_Course_id=@id and ST_teacher.ST_Teacher_id=ST_teacher_course.ST_Teacher_id and ST_teacher_course.ST_Course_id=ST_course.ST_Course_id and ST_teacher_course.ST_Class_id=ST_class.ST_Class_id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@id", SqlDbType.VarChar, 50));
        st_comm.Parameters["@id"].Value = Request.QueryString["ST_Course_id"];
        st_conn.Open();
        SqlDataReader st_dr = st_comm.ExecuteReader();
        st_rp_course.DataSource = st_dr;
        st_rp_course.DataBind();
        st_conn.Close();
    }
    private void st_btn_exit_Click(object sender, System.EventArgs e)
    {
        Response.Redirect("ST_course.aspx");
    }

}