DataSet with Joined Tables: Update and Insert Queries! RRS feed

  • Question

  • Hi guys,

    Here is my problem, I have an Access Database and two tables and a grid on my form. I run a query and in it a subquery that gives me information from both tables "Table1 and 2". I put that on the grid, everything works fine. If I want to update a row, I run a query that updates Table 1 and 1 that inserts in Table 2 directly to the Database. For that matter, I'm a using a datatable instead of a Dataset because I'm not doing anything withit. Now let's say I want to do those changes to the dataset and let the dataset updates the Database to have a responsive Grid. Meaning, I want to be able to update Table1 and insert in Table2 using a DataSet and then post that back to the underlying Database. How do I go by doing that?



    Sunday, June 24, 2007 11:36 PM