Hi,

This seems like it should be simple, but I cannot figure it out!

I have the "Standard Code" to create a DataSet, as shown below....

Dim objConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\Temp\DataBaseAccess\db1.mdb")

Dim objDataAdapter As New OleDb.OleDbDataAdapter("Select * From NamesTable", objConnection)

Dim objCommandBuilder As New OleDb.OleDbCommandBuilder(objDataAdapter)

Dim objDataSet As New DataSet()

Then I Fill the DataSet....

objDataSet.Clear()
objDataAdapter.FillSchema(objDataSet, SchemaType.Source, "NamesTable")
objDataAdapter.Fill(objDataSet, "NamesTable")


To find a particular row in the DataSet I do this....

Dim objRow As DataRow
objRow = objDataSet.Tables("NamesTable").Rows.Find(Val("123-45-6789"))

NOW HERE'S MY QUESTION!!! Now that I've found that particular row in the DataSet, How do I find it's "Row Number", (or Row Index... I'm not sure of the terminology"). For example once I found the row that has the key value listed above, how would I reference the very next row????

Seems simple, but I can't figure it out


Thanks for any help!

Steve