Loading

Multiple connections

rozy

What is the best way to work with multiple db connections? I mean that I ahave an app with a TreeView on it and for each node(if he has some props)I want to use a diffrent db (MsAccess) connection, what i did is that when I press a node I verify the conditions and if they are OK I conn=new OleDbConnection(strConnect); is this the best way?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

gjmproposal21y ago
Is the data in the nodes getting updated often? Do you have a lot of data ? If you can get all the data up front from both connections and do the validation and displaying in memory your application should run faster. There are a lot of built in objects for doing that type of thing. For handeling multiple connections in the application what I think you are asking above should work.