Sep 15, 2017 02:39 AM|Deepak Panchal|LINK
you can try to store connection string with in array.
if your all database have same numbers of table and fields then you can just try to loop through the array.
fetch the connection string one by one and pass that connection string to fetch the data from particular database.
then further you can process the data as per your requirement and outside the loop you can assign all fetched data to the report.
so if you use this approach , you can store the connection string in Web.config.