Hi All,

I am presently converting one of my VB6 programs, which uses an MS Access DB, to VB.Net and as it appears with quite a few others I am having a few conversion problems. Mainly involving the whole dataset, datadaptor scenario.

What I would like to do is ensure that the first row of data is being read so that no records are missed. This was quite simple with VB6 by using the following:

rst.MoveFirst (This may not be required with VB.Net???)

However the code I am using is below.

Code:
Dim conn As OleDbConnection
Dim datAdapt1 As New OleDbDataAdapter()
Dim datTab1 As New DataTable()

With conn
            .ConnectionString = "provider=microsoft.jet.oledb.4.0;data source = " & "DB Location"
            .Open()
End With

With datAdapt1
            .SelectCommand = New OleDbCommand("Select * FROM "A table", conn)
            .Fill(datTab1)

End With

"ensure first row of data code entered here"

For Each row In datTab1.Rows
      "Do stuff"
Next


The step I am requesting help with may not be required, however I would think there must be some method of assigning a starting row whether it be the first, last or somewhere between

Thanks for any assistance.

Cheers
OZMAN