private void Subjects_Old_Data()
{
for (int iterator = 0; iterator < 8; iterator++)
{
SubjectsDropdown.RemoveItem("");
}
}
private void RetrieveHandledSubjects()
{
string RetrieveQuery = "SELECT * FROM [Tbl.HandledSubjects] WHERE [TEACHER ID] = '" + TeacherID + "'";
sqlcommand = new SqlCommand(RetrieveQuery, sqlconnection);
SqlDataReader sqldatareader = sqlcommand.ExecuteReader();
while (sqldatareader.Read())
{
int index = 2;
for (int iterator = 0; iterator < 8; iterator++)
{
SubjectsDropdown.AddItem(sqldatareader.GetString(index).ToUpper());
index++;
}
}
sqldatareader.Close();
Subjects_Old_Data();
SubjectsDropdown.selectedIndex = 0;
if (SubjectsDropdown.selectedValue.ToString() != "NOT APPLICABLE")
{
try
{
SubjectsDropdown.selectedIndex = 0;
SubjectsGridView.Rows[0].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 1;
SubjectsGridView.Rows[1].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 2;
SubjectsGridView.Rows[2].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 3;
SubjectsGridView.Rows[3].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 4;
SubjectsGridView.Rows[4].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 5;
SubjectsGridView.Rows[5].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 6;
SubjectsGridView.Rows[6].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 7;
SubjectsGridView.Rows[7].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
}
catch (Exception)
{
//DON'T DO ANYTHING BITCH !
}
}
else
{
try
{
SubjectsDropdown.selectedIndex = 0;
SubjectsGridView.Rows[0].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 1;
SubjectsGridView.Rows[1].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 2;
SubjectsGridView.Rows[2].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 3;
SubjectsGridView.Rows[3].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 4;
SubjectsGridView.Rows[4].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 5;
SubjectsGridView.Rows[5].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 6;
SubjectsGridView.Rows[6].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
SubjectsDropdown.selectedIndex = 7;
SubjectsGridView.Rows[7].Cells[1].Value = SubjectsDropdown.selectedValue.ToString();
}
catch (Exception)
{
//DON'T DO ANYTHING BITCH !
}
}
}
