public static Control showStudents()
{
// make a list for retrieving data from it
List <SomerenModel.Student> students = new List <SomerenModel.Student>();
// linking the list to the DB connection in order to get data from it
students = SomerenDB.DB_getStudents();
// Making a list and editing its format
ListView studentsListView = new ListView();
studentsListView.Height = 370;
studentsListView.Width = 370;
studentsListView.View = View.Details;
studentsListView.FullRowSelect = true;
// adding colums to the list
studentsListView.Columns.Add("ID", -2, HorizontalAlignment.Left);
studentsListView.Columns.Add("First Name", -2, HorizontalAlignment.Left);
studentsListView.Columns.Add("Last Name", -2, HorizontalAlignment.Left);
studentsListView.Columns.Add("Room Number", -2, HorizontalAlignment.Left);
// storing data into the list
foreach (SomerenModel.Student student in students)
{
ListViewItem entryListItem = studentsListView.Items.Add(student.getId().ToString());
entryListItem.SubItems.Add(student.getFirstName().ToString());
entryListItem.SubItems.Add(student.getLastName().ToString());
entryListItem.SubItems.Add(student.getRoomNumber().ToString());
}
// return a list view
return(studentsListView);
}
