I have what I would assume is a common scenario: a Grid and a WebMenu. I want the menu to change values in the SQL database represented by the current row of the grid. to do this I need the PK value from the Grid (like EmployeeID) that will let me address the database with a WHERE clause. Problem: When I click a menu selection like "Change Field X From A To B," the grid is no longer "active," and Me.UltraWebGrid1.DisplayLayout.ActiveRow is NOTHING.
So what is the solution? How do I capture and save the current Row PK value while the grid is still active, and hopefully without a postback?
create a hidden field (textbox) and stick the ID in it whenever a cell is clicked. No postback required.