//listbox selektion hat sich geändert private void character_SelectedIndexChanged(object sender, EventArgs e) { //checken ob selektion wirklich stattgefunden hat if (accountCharacters.SelectedIndex >= 0) { //checken ob ein character mit diesen selektierten index exestieren kann if (accountCharacters.SelectedIndex <= application.getCharacters().Count) { selectedCharacter = application.getCharacters()[accountCharacters.SelectedIndex]; selectCharacter(); updateSelectedCharacter(); } } }
//character daten aus datenbank laden public void queryCharacters() { OleDbCommand command; try { command = new OleDbCommand("Select * From Characters", connection); OleDbDataReader reader = command.ExecuteReader(); if (reader.HasRows) { mCharacters.Clear(); while (reader.Read()) { Character character = new Character(); character.Id = reader.GetInt32(0); character.Name = reader.GetString(1); character.GuildId = reader.GetString(2); mCharacters.Add(character); } save(); } else { Console.WriteLine("No rows found."); } reader.Close(); command.Dispose(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }