Link to home
Start Free TrialLog in
Avatar of BangorCC
BangorCC

asked on

get row number of dataset.table(tableName).rows.find(findKey)

dataset.table(tableName).rows.find(findKey) returns a datarow this is all well and good if you want the actual information in that row however i need the numerical value of that row. is it possible to use find or something similar to return the row number of the found value
ASKER CERTIFIED SOLUTION
Avatar of gregasm
gregasm
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of gregasm
gregasm
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BangorCC
BangorCC

ASKER

Yea thats what i thought... it really doesnt make that much sense not to at least have a separate function for finding a record position.
Avatar of RichW
RichW
Flag of United States of America image
I don't really think there is a way to get the current row from a dataset, but you can do this from a control that is bound to the dataset, say, like the Datagrid object, by performing a hitTtest.


Dim myGrid As DataGrid = CType(sender, DataGrid)
Dim myHitInfo As DataGrid.HitTestInfo = myGrid.HitTest(e.X, e.Y)
Dim Row As DataRow
Dim intRow as Integer

intRow = myHitInfo.Row '<==  Current selected row