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