Deleting a row in DataGrid from database (help!)

[john83]

Deleting a row in DataGrid from database (help!)
-

I'm using a Oledatadapter to fill a dataset and displaying
my ms access records via a datagrid. Anybody is familiar on how to

1. Allow a user to select a Datagrid row and click on a button
"btnDelete" the row will be deleted from the database?
Each row has a unique column called 'ID'. any help?

2. How to write codes to delete all the records that has
integer value of "1" in its Column: fld_Type

Binding Codes:

dataview = dataset.Tables("Table").DefaultView
datagrid.datasource = dataview

[srinivas_s]

For the grid , have the event SelectedIndexChanged handled by a method where you will set the rows by 1

In the button click event
Just remove all the rows from the datatable of the dataset , then accept changes on the dataset and then dataadapter.update()

Should do the job