Deleting a row in DataGrid from database (help!)

[bizjosh]

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

Codes:

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

 

[kulrom]

Hi,
Why you don't try this 14 days evaluation application that generate SQL Statements for you ... very easy for use

So, use it while this make you more comfordable to make SQL Statements by yourself ... later you could uninstall it from your PC
http://www.gold-software.com/EazySQL-review20410.htm

Cheers

 

[bizjosh]

no thanks, i rather figure it out and learn.

 

[kulrom]

That is also a way to learn (generate SQL Statement and take a look of ...) lol ... but, anyway it's up to you

Cheers

 

[Paszt]

You can also use MS Access and Visual Studio (the query builder) to generate the SQL statements. Visual studio also has a Data Form Wizard that will generate a form, dataset schema, and code for you based on a series of questions. You can then look at the code/SQL statements and learn.

 

[TPM]

This'll help you with the SQL commands : http://www.w3schools.com/sql/sql_delete.asp

Adding a button to a datagrid depends on which datagrid your using, webforms or windowsforms.