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!
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL