incrementing a database record

Hello

I have a basic database application using Access. I can load the data into the dataset, but l have having trouble incrementing the records.

Code:

---


'Creates a OleDBConnection object - Provides details of the database being connected to
    Dim objConnection As New OleDb.OleDbConnection("Provider = Microsoft.Jet.oledb.4.0; data source=C:\Visual Studio.Net\Visual Basic\Personal Record\Personel Records.mdb")
    'Creates a data adapter object - Sends and recieves information from and to the database
    Dim objPersonelDA As New OleDb.OleDbDataAdapter("Select * from Personel", objConnection)
    'Creates a commandbuilder object - Runs all the SQL statements
    Dim objPersonelCB As New OleDb.OleDbCommandBuilder(objPersonelDA)
    'Creates a dataset object - Holds the information returned by the data adaptor
    Dim objDataSet As New DataSet()

---

I was able to do this using visual basic 6, but a bit confussed with vb.net.

In VB6 is was:

Code:

---

dataset.recordset.movenext

---

Can some one tell me how to do this in VB.Net

Many thanks in advance

Steve

http://www.vbforums.com/showthread.p...hreadid=244549

Thanks for you reply

I have looked at the example program about incrementing the recordset, but isn't there an easier way of doing it.

Any suggestions

Thanks