How will I get the record position in dataset

[tonioJ]

I am having trouble in getting the position of a record being search in dataset. How will I do that? Is there a way to get the position of the record return by the following code below:

Dim myDataCol(1) As DataColumn
Dim myDataRow As DataRow
myDataCol(0) = dtaSet.Tables(0).Columns("AcctCode")
dtaSet.Tables(0).PrimaryKey = myDataCol
myDataRow = dtaSet.Tables(0).Rows.Find(gblSearchKeyText)


I get the exact result but I want to get the position of the record. Which is similar to AbsolutePosition in ADO Recordset.

Thank you in advance for the reply.

 

[fawkes]

Create a DataView() object and use the FindRows method, this will return a DataRowView object. The DataRowView object has Row as one of its members.

 

[tonioJ]

I already figure out. How to search but how about assigning result to datarowview??