I have a table with the following fields:

PKid int Primary Key
SName varchar(10) Short Name
Desc varchar(40) Description


I bound this table to a grid but I set visible to false for the "PKid" column.

How do I retrieve the value for "PKid" from the record selected? I am able to get the row index of the selected row and use the index to retrieve the value from the datatable. However, when I change the order of the grid by clicking on the column header, the record order of the datatable does not change so I end up with the wrong record.