private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
roomsConn roomsConn = new roomsConn();
String selectedFaculty = rfaculty.Text.ToString();
rName.DataSource = roomsConn.getRoomsByFaculty(selectedFaculty);
}
private void faculty_SelectedIndexChanged(object sender, EventArgs e)
{
roomsConn roomsConn = new roomsConn();
String selectedFaculty = faculty.Text.ToString();
assignRoom.DataSource = roomsConn.getRoomsByFaculty(selectedFaculty);
}