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