VB.net which methods to use?

[emsik1001]

Hi

I want to create a small vb.net application which will issue simple SQL scripts mainly INSERT and UPDATE based on text boxes or selections. Majority of them effect only 1 record at a time.

I know how to use ADO (recordsets) but I have no idea how to use ado.net and update tables directly. (I have tried dataset, table adapters etc but I couldn't update the database I was able to update only the disconnected dataset)

My question is:

1) What method should I use?

-- If I use ADO (recordset) references does it have any negative impact now or in the future?

-- why should I be using ado.net? is it better then the previous version of ado? based on my simple application?




Many thanks in advance
Emil

[nukefusion]

To commit changes to the original database you'd need to call the Update method of the DataAdapter object passing in your DataSet.
There's an excellent article that should be of help to you here