A DataSet is completely separate from the data adapter(s) that fill it. You can use as many data adapters as neccessary to fill/update a dataset.
The real trick will be creating the DataSet's schema. I suggest creating two data adapters, then generate a dataset for each adapter, then manually combine the two schemas.
>I'm writing an application which uses ADO.NET in disconnected mode.
>
>It connects to one Visual Foxpro 8.0 database file, and one Visual Foxpro 8.0 free-standing table located in another folder.
>
>The OleDbDataAdapter only allows the SELECT statement to use one connected database at a time.
>
>Is there a way I can build a dataset which allows me to merge multiple SELECT statements into a single dataset, or from multiple oldDbDataAdapters?
>
>For Example:
>SELECT * FROM dbcompany WHERE name = "IBM" INTO file1;
>SELECT * FROM dbsubscriptions WHERE name = "IBM" INTO file2;
>SELECT * FROM file1, file2
>
>I'm new in the DOT NET programming.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only