Datagrid as a lookup table

pyungel

What I am trying to do is so simple I can't believe I am struggling with it but there doesn't seem to be a simple solution. It is a simple lookup table. I have a windows form with a datagrid on it that is bound to a dataset. There are three columns in the datagrid: UserID, FullName, PhoneNo. When the user selects a row from the datagrid, I need to programmatically determine what the UserID is of the row selected so I can fully populate the information somewhere else. I have the entire row being highlighted with:
DataGrid.HitTestInfo hitInfo = DataGrid.HitTest(e.X, e.Y); //highlight the entire row if(hitInfo.Type == DataGrid.HitTestType.Cell) { dgDataGrid.CurrentCell = new DataGridCell(hitInfo.Row, hitInfo.Column);
dgDataGrid.Select(hitInfo.Row); } I can determine the row by using dgDataGrid.CurrentRowIndex but for the life of me, I can't determine what the UserID is in that row.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

pyungel21y ago
Thanks for the reply. This would probably work if I had the hittest in the dbl-click event, but I don't. To get this to work, I'd have to restructure every dbl-click event that uses similar logic. That's about 7 places and seems to be much more work than seems logically necessary. I may drop the datagrid entirely and try another option but none of the other controls seem to offer simplistic mutliple column lookup information. Even Microsoft's own site takes the simple way out by using a single column combo box. Thanks again JJ.
write2jey21y ago
If you're able to det. the row then... of course you'd have a DataRow and a DataColumn in a DataTable in the DataSet. I mean if you've come to the point of selecting the row in a datagrid, that's something dude! so.... DataSet ds = new DataSet("name"); string UserIDString = ds.Tables["MyTable"].Rows[hitInfo.Row][0].ToString(); //note the column 0 which I assume your UserID is in column 0 //convert string to int int UserID = System.Convert.ToInt16(UserIDString, 10); Good Luck, JJ Canada