|
protected override void ProcessKeyDown(KeyEventArgs args)
{
base.ProcessKeyDown(args);
if (args.Key == Key.Delete)
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Table1", connection);
try
{
cmd = new SqlCommand("DELETE FROM Table1 (ID,Name) WHERE (@ID)", connection);
cmd.Parameters.Add("@ID", SqlDbType.Int, 50, "ID");
SqlParameter parameter= cmd.Parameters.Add("@ID", SqlDbType.Int, 50, "ID");
da.DeleteCommand = cmd;
da.Fill(DS);
//To get the current position
int index = this.DataGrid.ResolveToRowIndex(this.DataGrid.CurrentItem);
int resolvedIndex = this.DataGrid.ResolveToRecordIndex(index);
System.Data.DataRow dr = DS.Tables[1].Rows[resolvedIndex];
//It gives the details about the current item and then remove the remove the record from
//the database based upon that record
dr["ID"] = ((System.Data.DataRowView)this.DataGrid.CurrentItem).Row.ItemArray[0];
DS.Tables[1].Rows.Remove(dr);
da.Update(DS);
}
catch
{
}
finally
{
//Here you can code your view updation process
}
}
} | 
