private void Update(object sender, RoutedEventArgs e) { App.Contact contact = (App.Contact)dgContacts.SelectedItem; UpdateWindow w = new UpdateWindow(contact); w.Show(); }
private void Delete(object sender, RoutedEventArgs e) { App.Contact contact = (App.Contact)dgContacts.SelectedItem; dgContacts.Items.Remove(contact); var name = contact.Name; Console.WriteLine(name); MySqlCommand delete = new MySqlCommand("DELETE FROM projekt WHERE Name='" + name + "'", connection); delete.ExecuteNonQuery(); MySqlCommand get = new MySqlCommand("SELECT * FROM projekt", connection); getData(get); }
public void getData(MySqlCommand command) { dgContacts.Items.Clear(); using (var record = command.ExecuteReader()) { while (record.Read()) { App.Contact contact = new App.Contact(); contact.ID = int.Parse(record["id"].ToString()); contact.Name = record["name"].ToString(); contact.Age = int.Parse(record["age"].ToString()); dgContacts.Items.Add(contact); } } }
public UpdateWindow(App.Contact contact) { InitializeComponent(); currentContact = contact; }