查看教师所带课程.aspx.cs

好东东!好东东!好东东!好东东!好东东!好东东!好东东!好东东!好东东!好东东!好东东!好东东!好东东!

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class 查看教师所带课程 : System.Web.UI.Page
{
    string strname;
    protected void Page_Load(object sender, EventArgs e)
    {
        strname = Convert.ToString(this.Session["name"]);
        string strcnn = "server=.;database=学生成绩智能管理系统;user id=sa;password=sa;";
        string strcmd = "SELECT DISTINCT 课程表.课程号,课程名,学分  FROM 课程表,成绩表  WHERE 课程表.课程号 = 成绩表.课程号 AND 任课教师编号 ='" + strname + " '";
        SqlConnection cnn = new SqlConnection(strcnn);
        cnn.Open();
        SqlCommand cmd = new SqlCommand(strcmd, cnn);
        SqlDataReader rdr = cmd.ExecuteReader();
        GridView1.DataSource = rdr;
        GridView1.DataBind();
        cnn.Close();
    }
}