Well, yes, you have to initially select the data into the data grid
which has the id. The thing is, you can not auto-configure the grid at that
point, you would have to add the columns yourself, omitting the id. Then,
when you double click, you can check the data source for the current record
in the grid, and get the id so that you can populate your query.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
<ro*****@gmail.comwrote in message
news:11**********************@t39g2000prd.googlegr oups.com...
Hello,
I am interested on how to edit/view an item or record selected from a
DataGridView. The SQL queries for some data including the ID which is
not visible on the GridView.
I want to be able to click on the on a record from the DataGridView
then click the View Item and a form come up with information related
to that item. The View form with execute a query which will have the
(Select ..... Where ID="selectedItem.From.DataGridView")
Is there any way to get that done...?
Thanks