private void GetData() { try { DBConfig conf = new DBConfig(); MySqlConnection connection = new MySqlConnection(conf.ConnectionString); DataSet data = new DataSet { Locale = System.Globalization.CultureInfo.InvariantCulture }; MySqlDataAdapter daLiegenschaft = new MySqlDataAdapter( "select l.Id as Id, l.Name, v.Nachname as Verwalter, " + "count(DISTINCT h.Id) as Anzahl, " + "count(DISTINCT w.Id) as Anzahl, " + "count(DISTINCT m.Id) as Mieter " + "from liegenschaft l " + "left join verwalter v on l.Verwalter_id = v.Id " + "left join haus h on l.id = h.Liegenschaft_id " + "left join wohnung w on w.Haus_id = h.Id " + "left join mieter m on m.Wohnungs_id = m.Id " + "group by l.Id", connection); daLiegenschaft.Fill(data, "liegenschaft"); MySqlDataAdapter daHaus = new MySqlDataAdapter("select Id, Strasse, Hausnummer, PLZ, Ort, Beschreibung, Liegenschaft_id from haus", connection); daHaus.Fill(data, "haus"); DataRelation relation = new DataRelation("LiegenschaftenHaeuser", data.Tables["liegenschaft"].Columns["Id"], data.Tables["haus"].Columns["Liegenschaft_id"]); data.Relations.Add(relation); bsLiegenschaft.DataSource = data; bsLiegenschaft.DataMember = "liegenschaft"; bsHaus.DataSource = bsLiegenschaft; bsHaus.DataMember = "LiegenschaftenHaeuser"; } catch (MySqlException) { MessageBox.Show("errrrrrrrrrrrrror lol"); } }
public MySQLDatabase(DBConfig config) { _config = config; Connect(); }