private void deptcomboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
DepartmentModel rec = (DepartmentModel)deptcomboBox1.SelectedItem;
ArrayList alist = DatabaseModel.getTeachers(rec.DeptID);
IEnumerator en = alist.GetEnumerator();
while (en.MoveNext())
{
listBox1.Items.Add(en.Current);
}
}
public static ArrayList getDept(int facultyid)
{
ArrayList alist = new ArrayList();
string query = "select * from department where faculty_id=" + facultyid;
OleDbCommand com = new OleDbCommand(query, con);
con.Open();
OleDbDataReader read = com.ExecuteReader();
while (read.Read())
{
DepartmentModel rec = new DepartmentModel();
rec.DeptID = read.GetInt32(0);
rec.FacultyID = read.GetInt32(1);
rec.DeptName = read.GetString(2);
alist.Add(rec);
}
con.Close();
return(alist);
}