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();
}
}
