private void Bind_grdCourses()
{
////populate courses not added to profile
//myCon.ConOpen();
//queryString = "Select ComCod, CourseNo, CourseTitle from tblcourses where ComCod not in ( select ComCod from tblcourseteachermap where TeacherID = '" + Current_User_ID + "')";
//queryCommand = myCon.MakeSqlCommand(queryString);
//sqlDA = new SqlDataAdapter(queryCommand);
//System.Data.DataSet myDS = new System.Data.DataSet();
//sqlDA.Fill(myDS);
////myReader = myCon.ExecuteReader(queryString);
////grdCourses.DataSource = myReader;
//grdCourses.DataSource = myDS;
//grdCourses.DataBind();
//btnAddCourses.Visible = (grdCourses.Rows.Count != 0);
//myDS.Dispose();
//myCon.ConClose();
String queryString;
queryString = "Select ComCod, CourseNo, CourseTitle from tblcourses ";
DBCon myCon = new DBCon();
myCon.ConOpen();
if (ddlDepartments.SelectedItem.Text != "All Departments" || ddlSem.SelectedItem.Text != "All Semesters" || txtSearchString.Text != "")
{
queryString += "where ";
if (ddlDepartments.SelectedItem.Text != "All Departments")
{
queryString = queryString + " ComCod in (Select ComCod from tblDepartment where Department = '" + ddlDepartments.SelectedItem.Text + "'";
if (ddlSem.SelectedItem.Text != "All Semesters")
{
queryString += " and Semester = '" + ddlSem.SelectedItem.Text + "'";
}
queryString += ") ";
}
else
{
if (ddlSem.SelectedItem.Text != "All Semesters")
{
queryString = queryString + " ComCod in (Select ComCod from tblDepartment where Semester = '" + ddlSem.SelectedItem.Text + "') ";
}
}
if (txtSearchString.Text != "")
{
if (ddlDepartments.SelectedItem.Text != "All Departments" || ddlSem.SelectedItem.Text != "All Semesters")
{
queryString += " and ";
}
queryString += ddlSearchItem.SelectedItem.Value + " like '%" + txtSearchString.Text + "%'";
}
}
queryCommand = myCon.MakeSqlCommand(queryString);
sqlDA = new SqlDataAdapter(queryCommand);
System.Data.DataSet myDS = new System.Data.DataSet();
sqlDA.Fill(myDS);
grdCourses.DataSource = myDS;
grdCourses.DataBind();
btnAddCourses.Visible = (grdCourses.Rows.Count != 0);
myCon.ConClose();
}
