protected void Classes()
{
try
{
c.Open();
SqlDataAdapter adp = new SqlDataAdapter("Select * from Classes where Class NOT IN(Select ZeroPeriod from Monday) order by Class asc", c);
DataSet ds = new DataSet();
adp.Fill(ds);
ClassTeacher.DataSource = ds;
ClassTeacher.DataTextField = "Class";
ClassTeacher.DataValueField = "Class";
ClassTeacher.DataBind();
ClassTeacher.Items.Insert(0, new ListItem("--Select Class--", " "));
ClassTeacher.Items.Insert(1, new ListItem("Free", "Free"));
c.Close();
}
catch (Exception ex)
{
lblError.Text = "Something went wrong";
}
}
