public void ComboBoxSelectionFilter(RadioButton allCourse, RadioButton jCourse, RadioButton sCourse, string comboBoxText, DataGridView firstDGV)
{
SQLConnectionQueries sqlConnectionQueries = new SQLConnectionQueries();
if (allCourse.Checked == true)
{
string level = "J' or Level = 'S";
sqlConnectionQueries.RadioButtonFilter(comboBoxText, level, firstDGV);
}
else if (jCourse.Checked == true)
{
string level = "J";
sqlConnectionQueries.RadioButtonFilter(comboBoxText, level, firstDGV);
}
else if (sCourse.Checked == true)
{
string level = "S";
sqlConnectionQueries.RadioButtonFilter(comboBoxText, level, firstDGV);
}
}
public void RadioButtonFilter(string comboBoxText, string level, DataGridView firstDGV)
{
SQLConnectionQueries sqlConnectionQueries = new SQLConnectionQueries();
string major, query;
major = "= '" + comboBoxText + "'";
query = ("Select Code, Name, Major, Level, Cost from js_CourseInfo where (Level = '" + level + "') and Major " + major + "");
if (comboBoxText == "All")
{
major = "is not null";
query = ("Select Code, Name, Major, Level, Cost from js_CourseInfo where (Level = '" + level + "') and Major " + major + "");
sqlConnectionQueries.DisplayTable(firstDGV, query);
}
else
{
sqlConnectionQueries.DisplayTable(firstDGV, query);
}
}
