bryan 0

bryan 0

  • NA
  • 9
  • 0

Datagrid's OnClick to display row's data to another Form

May 21 2005 4:55 AM
Hi, 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? da1 --- 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! Thanks.