Delete Row from datagridview using button en each row

Question

I have a show delete button of each row for delete from database permanently, how can delete data from DB ?

The following code shows delete button of each row. I have user Oracle Database Where I have write query for delete ?

DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
dataGridView1.Columns.Add(Deletelink);

I have write the code for delete but I have fail

private void dataGridView1_CellContentClick(object sender DataGridViewCellEventArgs e)
{
  if (e.ColumnIndex == 5)
  {
    empid = Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells["empid"].Value);
    OleDbDataAdapter adp = new OleDbDataAdapter("delete  from apps where appsid= '"+empid+"'", con);
    DataTable dt = new DataTable();
    adp.Fill(dt);
    dataGridView1.DataSource = dt;
    dataGridView1.Refresh();

We don't know enough about your setup. If you are going to delete a row in the database, you are going to need an ID or Key. — LarsTech, Dec 29 '17 at 17:14
i have edit the question i am try to solution using grid index — khan, Dec 29 '17 at 17:20
_dataGridView2_ or _dataGridView1_ ? Why you are setting the datatable as datasource of the dataGridView2? — Steve, Dec 29 '17 at 17:25

score 0 · Accepted Answer · answered Dec 29 '17 at 17:36

A delete command issued as constructor for a OleDbDataAdapter is not correct. However the adapter will execute the command nevertheless. But surely you cannot expect a delete command to be used to fill a datatable.
You still need a SELECT.

Usually this is done removing the row from the grid (this marks the underlying row as deleted then, when you want to save the changes to the database, you should use the orginal DataAdapter and the original DataTable used to initially fill the grid to issue the Update method

This is well explained here Using OleDbDataAdapter to Update a DataTable

Or you could do the update yourself using a separate command and reloading the datatable

// Delete the record on the db
empid = Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells["empid"].Value);
OleDbCommand cmd = new OleDbCommand("delete from apps where appsid= @id", con);
cmd.Parameters.Add("@id", OleDbType.VarWChar).Value = empid;
cmd.ExecuteNonQuery();

// reload the grid with the updated info from the db
OleDbDataAdapter da = new OleDbDataAdapter("Select * from apps", con);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Refresh();

This of course has the drawback to hit two times the database and reloading everything each time you delete a row.

i have use empid as string variable which is row delete using @id? — khan, Dec 30 '17 at 06:37
That's the parameter 'name' whose value is the empid's value — Steve, Dec 30 '17 at 07:58

Delete Row from datagridview using button en each row

1 Answers1