当前文件路径：MyElectCourse/teacherQueryElect.aspx.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class teacherQueryElect : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!this.IsPostBack)
18        ...{            
19            BindDDL();
20        }
21    }
22
23    //为课程名称下拉列表框绑定数据
24    private void BindDDL()
25    ...{
26        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;   //取出连接字符串
27        string SqlStr = "SELECT distinct cource.courceID,cource.courceName from Elect,Cource where Elect.courceID=Cource.courceID and Elect.teaID='" + Session["userName"].ToString() + "'";
28        DataSet ds = new DataSet();
29
30        SqlConnection conn = new SqlConnection(connStr);    //创建连接对象
31        if (conn.State.ToString() == "Closed")              //如果连接关闭,打开
32            conn.Open();
33        SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
34        da.Fill(ds);                                        //从数据库中取数据放到DataSet数据集中
35        if (conn.State.ToString() == "Open")
36            conn.Close();
37
38        ddlCource.DataSource = ds.Tables[0].DefaultView;
39        ddlCource.DataTextField = "courceName";             //下拉列表框每项显示课程名称
40        ddlCource.DataValueField = "courceID";              //下拉列表框每项的值为课程编号
41        ddlCource.DataBind();
42    }
43}
44