Multiple MS SQL databases

Hi,
you can use multiple databases (but individually in your case). to do this you can set your connection string two times in your web.config. suppose if you have

add name="DB1" connectionstring="Data Source=HP-PC;Database=erp;User id=sa;Password=****" providername="System.Data.SqlClient"

for your first database and you like to use a new database with existing one then you can again set a new connection string with new name as below

add name="DB2" connectionstring="Data Source=your server;Database=databaseMy;User id=sa;Password=*****" providername="System.Data.SqlClient"

now the main point is that how to use first one and second one, so when you define your connection object you have to use different names [connection string] as DB1 or DB2
now that connection object works on that database
try it if further issue then you can ask.