protected void DropDownListBind() { SqlConnection con = DataOperate.CreateCon(); SqlCommand cmd1 = new SqlCommand(); cmd1.Connection = con; string teacher = Session["userName"].ToString(); cmd1.CommandText = "select * from CourseInfo where teacher ='" + teacher + "'"; SqlDataReader reader1 = null; if (con.State == ConnectionState.Closed) { con.Open(); } reader1 = cmd1.ExecuteReader(); CourseName.DataSource = reader1; CourseName.DataTextField = "courseName"; CourseName.DataValueField = "courseId"; CourseName.DataBind(); if (con.State == ConnectionState.Open) { con.Close(); } SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = con; cmd2.CommandText = "select * from VideoInfo where CourseId ='" + CourseName.SelectedValue + "'"; SqlDataReader reader2 = null; if (con.State == ConnectionState.Closed) { con.Open(); } reader2 = cmd2.ExecuteReader(); VideoName.DataSource = reader2; VideoName.DataTextField = "videoName"; VideoName.DataValueField = "videoId"; VideoName.DataBind(); if (con.State == ConnectionState.Open) { con.Close(); } }
protected void CourseName_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = DataOperate.CreateCon(); SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = con; cmd2.CommandText = "select * from VideoInfo where CourseId ='" + CourseName.SelectedValue + "'"; SqlDataReader reader2 = null; if (con.State == ConnectionState.Closed) { con.Open(); } reader2 = cmd2.ExecuteReader(); VideoName.DataSource = reader2; VideoName.DataTextField = "videoName"; VideoName.DataValueField = "videoId"; VideoName.DataBind(); if (con.State == ConnectionState.Open) { con.Close(); } }