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