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.
I was able to do this using visual basic 6, but a bit confussed with vb.net.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()
In VB6 is was:
Can some one tell me how to do this in VB.NetCode:dataset.recordset.movenext
Many thanks in advance
Steve




Reply With Quote