Buminit

Ok here is the question. I have been spending several days trying to find an answer. To set some background first. I am using VS 2005, and using the data wizard to set up my data source. Now, I have created a program that uses a database file to store data for one user. My question is this. Is it possible to load a different database and repopulate the tables in the existing dataset during runtime? Both database are of the same architecture.

On another note. Would it be better for me to just write all the code to connect to the database and populate the dataset with all the data from the get go, or is using the data source wizard a good way to go?

__________________
Typing it one line at a time.

Jimbo

For the first question, you can connect to another DB using a different connection string. Once connected, if the queries are the same you can use the same queries.

For the second question, it depends on your programs needs and how much you care about performance. There's benefits to going both ways.

__________________
<insert disclaimer here>
<insert shameless plug for Visual Studio here>