Datagrid OnClick event to display row's data to another form2
I'm using a data adapter 'da1' to fill a dataset 'ds1' which is used
to display data in a datagrid 'dg'. How do I code datagrid OnClick event
on whichever row the user click on the datagrid, to cause a new
form2 to popup with textboxes to display the selected row's data
and allow the user to edit the data and click 'update' so it will
be updated to the database. The user can alt-tab to switch to main
form and select another row, the new's row data will be displayed on
form2's textboxes and editable too.
Any idea how i can do that?
Table1: ID, Name, Age, Job
Table2: ID, Status, Salary
I did not include the other tables into 'da1' , however this other
tables data will be needed to display on form2's textboxes, is it
neccessary for me to include it into 'da1' or should i create another
data adapter 'da2' for form2's displaying/updating?
Please advise, help appreciated!