public void KlassenLijstTonen()
{
string _conn = string.Format("server=84.196.202.210;user id=Dylan;database=arduino;password={0}", "Devaien");
MySqlConnection conn = new MySqlConnection(_conn);
conn.Open();
string _cmd = string.Format("SELECT idKlassen, KlasNaam from klassen");
MySqlCommand cmd = new MySqlCommand(_cmd, conn);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Klassen objKlas = new Klassen(dr[1].ToString(), Convert.ToInt32(dr[0]));
LitBox.Items.Add(objKlas);
}
conn.Close();
}
private void LitBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Klassen objKlas = (Klassen)LitBox.SelectedItem;
string _conn = string.Format("server=84.196.202.210;user id=Dylan;database=arduino;password={0}", "Devaien");
MySqlConnection conn = new MySqlConnection(_conn);
conn.Open();
string _cmd = string.Format("SELECT idLeerlingen, LeerlingVNaam, LeerlingANaam FROM leerling WHERE klassen_idKlassen = {0} AND WHERE LeerlingKaatID = null", objKlas.intidKlassen);
MySqlCommand cmd = new MySqlCommand(_cmd, conn);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Leerling objLeerling = new Leerling(dr[1].ToString(), (dr[0].ToString()));
LitBox.Items.Add(objLeerling);
}
conn.Close();
}