How to delete row from datagridview in VB.NET and from access database?

Question

0.00/5 (No votes)

See more:

I want to delete row from datagridview in vb.net and from access database without appending data to textbox means on select row from datagrid and click delete opertaion.

What I have tried:

If DataGridView1.SelectedRows.Count > 0 Then

'Label lblID= (Label) dataGridView1.SelectedRows[0].FindControl("lblPrimaryKey");
'SqlCommand cmd = new SqlCommand ("Delete from table where id='"+ Convert.ToInt32(lblID.Text)+"'",ConnectionObject);
'cmd.ExecutenonQuery();
' End If

Posted 3-Mar-18 22:15pm

Member 13707612

Updated 5-Mar-18 2:42am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mvdk72 · Answer 1 · 2018-03-05T02:42:00

If my assumption is correct, that data is deleted from the database but still is visible in your DataGridView, then I would suggest that you either:
1) rerun the query that filled your view (Datasource) initially
2) remove the deleted item from the datasource used for the DataGridView

Hope this helps

How to delete row from datagridview in VB.NET and from access database?

1 solution

Solution 1

Add your solution here

Preview 0

How to delete row from datagridview in VB.NET and from access database?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us