Printable View
I think I am going crazy..... is it not in anyway possible to get the index of a specific row in a table?
I use soemthing like dr = Dataset11.Employees.FindByEmployeeID(4) to return a datarow from the Employees table of the Northwind database. I get a nice datarow object in my dr variable but......
how on earth do I get the index of the row in that table, ie what position does that row have in the Employees table?!?
While the DataRow object does have a property called rowid, and it can be examined in the debugger at runtime and seems to contain a 1-2-3-4 type count of rows, the property is not exposed to you at build time. There is probably a way to get at that value but I suspect you'd have to customize/modify the DataRow object to do it (I don't have the faintest). You're not the first person to ask about this either.
ok, well I'm using a loop now, but that just seemed a little to much. I thought of building an modified DataRow class, but with a typed Dataset and so much computer generated code it kinda scared med off. :)