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 ! } } }