Using IDBConnection with TableAdapter? RRS feed

  • Question

  • Can we specify an IDBConnection object as the connection property of TableAdapter? As far as I know, since while creating a table adapter we need to specify a connection e.g., SqlConnection or OLEConnection, so we can only give that specific connection object to the adapter. But in my case i dont know the exact connection type till the user chooses one, meaning either Sql or Access? Is there anyway i can do this with table adapters?


    I have tried this with DataAdapters, and there i can specify IDBConnection to all the commands, but i am having problems finding a way to do this with table adapters.



    Thursday, August 30, 2007 12:43 PM