DataTable and TableAdapter RRS feed

  • Question

  • I have two databases, A SQLServer DB on server machine and a Local Access DB. Let's say that both have a Customers table with "same" schema.

    I like to create a DataSet that contains a CustomersDataTable that can be filled from either one of the source. How?

    Following is what I am doing:
       Create one TableAdapter (and its own SQLCustomersDataTable for SQL DB,
       and another one (and its own AccessCustoemrsDataTable)  for AccessDB.

       then using the adapter to get the data and loop through to fill the common CustomerDataTable.

    Another thing I can do is a Customers : List<Customer> with diffent GetData() method to hide the detail of how the data is retrieved. But is essentially the same as a common CustomersDataTable.

    What I want is two TableAapters fill one type of DataTable.


    Thursday, October 2, 2008 5:02 PM