protected void course_changed(object sender, EventArgs e)
{
try {
SectionDropDown.Items.Clear();
SectionDropDown.Items.Add(new ListItem("--Select Section--", ""));
SectionDropDown.AppendDataBoundItems = true;
SqlSection.SelectCommand = "select section_id from section as s " +
"where s.course_id = '" + CourseDropdown.SelectedValue + "'";
SectionDropDown.DataTextField = "section_id";
SectionDropDown.DataValueField = "section_id";
SectionDropDown.DataBind();
//if (SectionDropDown.Items.Count >= 1)
//{
// SectionDropDown.Enabled = true;
//}
//else
//{
// SectionDropDown.Enabled = false;
//}
}
catch (Exception ex)
{
throw new ApplicationException("Sorry for the inconvenience", ex);
}
}
public void LoadSectionDropDownList()
{
string companyName, departmentName;
try
{
string connectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * from AuditProgram where ([PID]=@PID)", con);
con.Open();
cmd.Parameters.AddWithValue("@PID", Session["ProgramID"]);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
companyName = dr["CompanyName"].ToString();
departmentName = dr["DepartmentName"].ToString();
}
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * from Section where ([CompanyName]=@CompanyName) AND ([DepartmentName]=@DepartmentName)", con);
con.Open();
cmd.Parameters.AddWithValue("@CompanyName", companyName);
cmd.Parameters.AddWithValue("@DepartmentName", departmentName);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds); // fill dataset
SectionDropDown.DataTextField = ds.Tables[0].Columns["SectionName"].ToString(); // text field name of table dispalyed in dropdown
SectionDropDown.DataValueField = ds.Tables[0].Columns["SectionName"].ToString(); // to retrive specific textfield name
SectionDropDown.DataSource = ds.Tables[0]; //assigning datasource to the dropdownlist
SectionDropDown.DataBind(); //binding dropdownlist
}
}
catch (Exception ex)
{
Response.Write(ex.Message + " Section Drop Down");
}
}
public void UpdateSection()
{
SectionDropDown.DataBind();
}
public void UpdateSection()
{
SqlDataSource2.DataBind();
SectionDropDown.DataBind();
}
