Queries running more time because of more connection string

Hi,

I am using multiple connection strings (Conn1,Conn2,Conn3,Conn4 and Conn5) to get the results from data base,.

Except conn1, remaining strings are pointing same database but different queries. because of keeping multiple string its taking more time to fetch the results.

Could someone please help to reduce the code to bring all the string into one.??

Please Login or Register  to view this content.

Could someone please help me on this????