I have read from many places that it is possible to fill a DataSet with multiple tables using a DataAdapter. It also does not say whether a single Update call can update all the tables in the DataSet. Can someone help me figure out how this can be done? It seems like there isn't any ( i tried finding online ) examples on how to do it except for one that changes the SelectCommand on the DataAdapter before the second fill. But I feel this method defeats the purpose of the DataAdapter.
From what I figure, perhaps a single DataAdapter can only handle a single database table and Update only works on that table. Hence a multi-table DataSet will require respective DataAdapters call their Update to fully update the DataSet. Is this the case? Finally, will foreign key relations and contraints hold in a DataSet (cascade delete, cascade update) automatically? Maybe a link to an example or tutorial might help.
Im not sure how to proceed on this one. I have a dataset with one table being populated by a complex join from several tables. Basically a fancy SELECT statement. Designer doesn't support generating a dataset from a query like this (right?) so I hand created the dataset and the SELECT statement.
Now dataadapter.Fill() works fine. Its time to get Update() working. Since I need to put values back into multiple tables I need to do several SQL UPDATEs.
I tried crafting a BEGIN END; block with all the needed SQL (im using Oracle). Nero V5.5 Download. But this doesn't return an affected row count so a concurrency exception gets thrown.
Join Stack Overflow to learn. How to fill Dataset with multiple tables? Ask Question. DataSet someDataSet = new DataSet(); SqlDataAdapter adapt = new. In the past I used SqlCommandBuilder and SqlDataAdapter.Update method to. If your dataset contains multiple tables. Table Joins into one Dataset Update.