Updating and Deleting records with Access db

[depistol]

Hello,
I am new too this forum and have a little problem with my VB.NET - Access program. I search the database and get the record displayed. How can I update or Delete te record from the current dataset/database that is loaded in the application?


Thanks,
Dep

 

[PLH]

This is how you delete and update the database

[size=2]
yourDataset.Yourtable.FindByOrderID(orderID).Delete() ' This statment deletes the record in the dataset.
 
'Or this one deletes the first record in the dataset
 
yourDataset.Yourtable.rows(0)("yourColumn").Delete()
 
'And
yourDataAdapter.Update(yourDataset, "Yourtable") ' This statment updates the record in the actual database

[/size]

 

[depistol]

Ah great...thanks..Is there an equally easy way to update a record? By update I mean pull the record out and change some values and then add it to the database again. Or could I save the changes in temp variables, then delete the records and readd it with the new changes?

thanks,
Dep

 

[jmcilhinney]

Rather than doing things piece-meal like this, I suggest you get the 101 VB samples from MS and take a look at the data access samples.

http://www.microsoft.com/downloads/...f8-033d-420b-a3b1-3074505c03f3&displaylang=en

 

[jmcilhinney]

This site also has good beginner information on data access and lots of other things.

http://www.homeandlearn.co.uk/NET/vbNet.html