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); }