How to connect multiple access databases in asp.net?

Question

Hi, Good Morning, I have a reqiurement, i,e i need to connect multiple access databases with a single common field, in asp.net, how to connect and the steps please tell to me.. Thanks

Satyaveer Chauhan · Answer

SqlConnection con1 = new SqlConnection ( System . Configuration . ConfigurationManager . ConnectionStrings [ "con1" ]. ConnectionString ); SqlConnection con2 = new SqlConnection ( System . Configuration . ConfigurationManager . ConnectionStrings [ "con2" ]. ConnectionString ); SqlCommand cmd = new SqlCommand ( "select * from table1" , con1 ); SqlDataReader dr ; con1 . Open (); dr = cmd . ExecuteReader ( CommandBehavior . SingleResult ); while ( dr . Read ()) { // .... } dr . Close () //your condition then fire insert commnd with connection con2 SqlCommand insertcmd = new SqlCommand ( "insert into table2" , con2 ); SqlDataAdapter dap = new SqlDataAdapter ( insertcmd );

Akkiraju Ivaturi · Answer

Configure two connection strings in web.config and always make sure that you close one connection before using another. Command object should be general for any connection. Which ever connection you would like to use, set the connection for the Command object to that particular connection.

How to connect multiple access databases in asp.net?

Answers (2)