how to use two database connections in one asp.net project

Dear Friend,

What you can do here is that you can define two different variables for making connection. Set the value of database variable and make connection from it.

The moment you want to switch the connection then you can set the database variable to other database and make other connection while disconnecting the previous connection.

It totally depends on your choice to have multiple database connections open but for that you have to make two different classes from database connectivity else only one class will do.

I hope you understand what i am trying to say.