public void binddegree2()
{
try
{
DataSet ds = new DataSet();
cbl_degree2.Items.Clear();
string stream = "";
stream = ddl_strm.Items.Count > 0 ? ddl_strm.SelectedValue : "";
txt_degree2.Text = "--Select--";
string useCOdeSet = "select LinkValue from New_InsSettings where LinkName='MultipleCollegeUserRights' and user_code ='" + userCode + "' and college_code in ('" + collegeCode + "' )";
string colleges = Convert.ToString(reUse.GetFunction(useCOdeSet)).Trim();
if (colleges == "" || colleges == "0")
{
colleges = collegeCode;
}
string query = "select distinct degree.course_id,course.course_name from degree,course where course.course_id=degree.course_id and course.college_code = degree.college_code and degree.college_code in (" + collegeCode + ") ";
if (ddl_strm.Enabled)//if (txt_strm.Enabled)
{
query += " and course.type in ('" + stream + "')";
}
ds = reUse.select_method_wo_parameter(query, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbl_degree2.DataSource = ds;
cbl_degree2.DataTextField = "course_name";
cbl_degree2.DataValueField = "course_id";
cbl_degree2.DataBind();
if (cbl_degree2.Items.Count > 0)
{
for (int i = 0; i < cbl_degree2.Items.Count; i++)
{
cbl_degree2.Items[i].Selected = true;
}
txt_degree2.Text = "Degree(" + cbl_degree2.Items.Count + ")";
cb_degree2.Checked = true;
}
else
{
txt_degree2.Text = "--Select--";
}
}
else
{
txt_degree2.Text = "--Select--";
}
}
catch (Exception ex) { }
}