protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
String selectQuery = "Select id, name from Semesters where course_id='" + RadioButtonList1.SelectedItem.Value + "'";
SqlCommand cmd = new SqlCommand(selectQuery);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
DDLSemester.DataSource = cmd.ExecuteReader();
DDLSemester.DataTextField = "name";
DDLSemester.DataValueField = "id";
DDLSemester.DataBind();
con.Close();
selectQuery = "Select id, name from Faculties where course_id='" + RadioButtonList1.SelectedItem.Value + "'";
cmd = new SqlCommand(selectQuery);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
DDLFName.DataSource = cmd.ExecuteReader();
DDLFName.DataTextField = "name";
DDLFName.DataValueField = "id";
DDLFName.DataBind();
con.Close();
}
public void LoadSemester()
{
DDLSemester.DataSource = P.BindSemesterAcYear_ALL(Convert.ToInt32(DDLAY.SelectedValue));
DDLSemester.DataTextField = "Semester_Desc";
DDLSemester.DataValueField = "Semester_RefID";
DDLSemester.DataBind();
}
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
String selectQuery = "Select DISTINCT Semesters.name, Semesters.id from Semesters,subject_faculty,Subjects,Faculties where subject_faculty.faculty_id=Faculties.id AND subject_faculty.sub_id=Subjects.id AND Semesters.id=Subjects.semester_id AND Faculties.email='" + Session["CurrentUser"] + "'";
//String selectQuery = "Select id, name from Semesters where course_id='" + RadioButtonList1 .SelectedItem.Value + "'";
SqlCommand cmd = new SqlCommand(selectQuery);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
DDLSemester.DataSource = cmd.ExecuteReader();
DDLSemester.DataTextField = "name";
DDLSemester.DataValueField = "id";
DDLSemester.DataBind();
con.Close();
selectQuery = "Select id, name from Students where course_id='" + RadioButtonList1.SelectedItem.Value + "'";
cmd = new SqlCommand(selectQuery);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
DDLFName.DataSource = cmd.ExecuteReader();
DDLFName.DataTextField = "name";
DDLFName.DataValueField = "id";
DDLFName.DataBind();
con.Close();
//selectQuery = "Select id, name from Subjects where course_id='" + RadioButtonList1.SelectedItem.Value + "' AND semester_id='"+DDLSemester.Items[0].Value+"'";
selectQuery = "Select DISTINCT Subjects.name, Subjects.id from Courses,subject_faculty,Subjects,Faculties,Semesters" +
" where subject_faculty.faculty_id=Faculties.id AND subject_faculty.sub_id=Subjects.id AND Courses.id=Subjects.course_id AND Subjects.semester_id=Semesters.id" +
" AND Faculties.email='" + Session["CurrentUser"] + "' AND Courses.id=" + RadioButtonList1.SelectedItem.Value + " And Semesters.id=" + DDLSemester.SelectedItem.Value;
cmd = new SqlCommand(selectQuery);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
DDLSubject.DataSource = cmd.ExecuteReader();
DDLSubject.DataTextField = "name";
DDLSubject.DataValueField = "id";
DDLSubject.DataBind();
con.Close();
}
protected void DDLCourse_SelectedIndexChanged(object sender, EventArgs e)
{
List <string> lsC = new List <string>();
lsC.Clear();
lsC.Add("--Select--");
switch (DDLCourse.Text)
{
case "BCA":
lsC.Add("BCA 1st Year");
lsC.Add("BCA 2nd Year");
lsC.Add("Bca 3rd Year");
break;
case "BBM":
lsC.Add("BBM 1st Year");
lsC.Add("BBM 2nd Year");
lsC.Add("BBM 3rd Year");
break;
case "B.A":
lsC.Add("BA 1st Year");
lsC.Add("BA 2nd Year");
lsC.Add("BA 3rd Year");
break;
case "B.Com":
lsC.Add("BCOM 1st YearS");
lsC.Add("BCOM 2nd Year");
lsC.Add("BCOM 3rd Year");
break;
}
DDLSemester.DataSource = lsC;
DDLSemester.DataBind();
}
