incrementing a database record

[steve_rm]

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.

'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:

dataset.recordset.movenext

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

Many thanks in advance

Steve

[nswan]

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

[steve_rm]

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