C# Programming
05-01-2009, 12:40 PM
I've created a c# application based on SQL Express database.
I have one view in the database based on several tables (Inner join).
When I start my appllication, I fill one DataSet with all the tables (using XSD adapters), and I fill the DataView with the view (directly from the the database).
The client user can update fields on any DataTable from the DataSet (without updating the database itself).
After the user updates the fields, I want to update the DataView with the new values, but the view is connected directly to the DataBase, and not to the DataTables.
Can I based my DataView on several DataTables, so when the DataTables are updated, the DataView is updated accordingly?
Thanks,
Maoz
I have one view in the database based on several tables (Inner join).
When I start my appllication, I fill one DataSet with all the tables (using XSD adapters), and I fill the DataView with the view (directly from the the database).
The client user can update fields on any DataTable from the DataSet (without updating the database itself).
After the user updates the fields, I want to update the DataView with the new values, but the view is connected directly to the DataBase, and not to the DataTables.
Can I based my DataView on several DataTables, so when the DataTables are updated, the DataView is updated accordingly?
Thanks,
Maoz