Update Multiple DB Tables
I am loading a DataTable in a DataSet with data from an Excel spreadsheet. This works well. Now, without questioning the design of what I am trying to do, is there an easy way of updating several database tables with this data without copying the data to a new datatable using LoadDataRow or any other technique. The problem I am having is the RowState property is set to "Unchanged". This property is ReadOnly and will not update using the DataAdapter.Update method if the RowState is set to "Unchanged". Is this possible? Or am I stuck loading new dataset tables for each database table I want to insert the records into?
In general, I am reading data from one datasource and trying to insert the data into a separate datasource without copying the data to a new datatable in the dataset.
All suggestions will be appreciated?