public List <SomerenModel.Student> DB_getstudents() { SqlConnection connection = openConnectieDB(); List <SomerenModel.Student> studenten_lijst = new List <SomerenModel.Student>(); //connection.Open(); StringBuilder sb = new StringBuilder(); // schrijf hier een query om te zorgen dat er een lijst met studenten wordt getoond sb.Append("SELECT student_id,student_voornaam,student_achternaam FROM studenten"); String sql = sb.ToString(); SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int id = (int)reader["student_id"]; string naam = (string)reader["student_voornaam"]; string achternaam = (string)reader["student_achternaam"]; SomerenModel.Student student = new SomerenModel.Student(); student.setId(id); student.setNaam(naam); student.setAchterNaam(achternaam); studenten_lijst.Add(student); } sluitConnectieDB(connection); return(studenten_lijst); }
public static List <SomerenModel.Student> DB_getStudents() { // make a sql connection SqlConnection connection = openConnectionDB(); // make a list to store data from DB into it List <SomerenModel.Student> students_list = new List <SomerenModel.Student>(); // string builder to write query StringBuilder sb = new StringBuilder(); // the sql query sb.Append("SELECT student_id, FirstName,LastName ,room_number_id FROM Students"); // convert the sql query to string String sql = sb.ToString(); SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(); // retrieving data from DB while (reader.Read()) { // store data to the list SomerenModel.Student student = new SomerenModel.Student(); student.setId((int)reader["student_id"]); student.setFirstName((string)reader["FirstName"]); student.setLastName((string)reader["LastName"]); student.setRoomNumber((int)reader["room_number_id"]); students_list.Add(student); } // close the reader and sql connection reader.Close(); connection.Close(); return(students_list); }
public static List <SomerenModel.Student> DB_gettudents() { SqlConnection connection = openConnectieDB(); List <SomerenModel.Student> studenten_lijst = new List <SomerenModel.Student>(); StringBuilder sb = new StringBuilder(); // schrijf hier een query om te zorgen dat er een lijst met studenten wordt getoond sb.Append("SELECT [StudentId], [Naam] FROM [dbo].[A5_Student]"); /* VOORBEELDQUERY */ //sb.Append("SELECT TOP 20 pc.Name as CategoryName, p.name as ProductName "); //sb.Append("FROM [SalesLT].[ProductCategory] pc "); //sb.Append("JOIN [SalesLT].[Product] p "); //sb.Append("ON pc.productcategoryid = p.productcategoryid;"); /* */ String sql = sb.ToString(); SqlCommand command = new SqlCommand(sql, connection); command.Prepare(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int StudentId = reader.GetInt32(0); string Naam = reader.GetString(1); SomerenModel.Student student = new SomerenModel.Student(); student.setId(StudentId); student.setNaam(Naam); studenten_lijst.Add(student); } return(studenten_lijst); }