423,822 Members | 1,356 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,822 IT Pros & Developers. It's quick & easy.

Updating database table using a datagrid and 2 datasets

P: 1
Updating data using 2 data sets

I am having some problems in updating the database using two datasets as suggested by someone.

1. Data is displayed in a data grid from a dataset generated using the IDE that pulls data from two tables using an [inner join]. The idea is to display the [filed name] associated with the [foreign key] field. Because an [inner join] is used, the IDE couldn’t auto-generate the Insert command, update command, or Delete command.
2. As a result, it was suggested that another dataset be used to update the changes made through the textboxes entered in the data grid.

I read through quite many articles and sample scripts and just couldn’t find any scripts that can transfer the changes in the data grid to the first dataset and then from the first dataset to the second dataset in order to apply the [Second dataset]. [Data adapter]. [update()] function in order to update the underlying database table.


Assistance will be appreciated.
Mar 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.