I have a Datagrid that get filled from a SQLite table
Connect();
mAdapter = new SQLiteDataAdapter("SELECT * FROM clients", mConn);
mTable = new DataTable();
mAdapter.Fill(mTable);
dataGrid.ItemsSource = mTable.DefaultView;
mConn.Close();
I can make it delete an selecteditem but how can I make it delete selecteditems based on their id
private void dataGrid_PreviewKeyDown(object sender, System.Windows.Input.KeyEventArgs e)
{
if (e.Key == System.Windows.Input.Key.Delete)
{
if (dataGrid.SelectedItem == null)
return;
DataRowView rowView = (DataRowView)dataGrid.SelectedItem;
Connect();
using (SQLiteCommand mCmd = new SQLiteCommand("DELETE FROM clients WHERE ID=" + rowView["ID"], mConn))
{
mCmd.ExecuteNonQuery();
}
mAdapter.Update(mTable);
mConn.Close();
}
}
Aucun commentaire:
Enregistrer un commentaire