How to use multiple connection strings to databases in ASP.NET
by GetCodeSnippet.com • June 28, 2013 • Microsoft ASP.NET • 1 Comment
You can define connection string in your code just before you want to connect to a database. So whenever you want to connect to a database, you can define it connection string and establish your connection. But if you want to use same connection in different places then you have to define a connection string multiple times. The basic solution of this problem is to define your connection string in web.config file and use it anywhere in your code. You can define multiple connection strings for multiple connections to multiple databases. Let’s see how we can define multiple connection strings in web.config and how we can use it in our code file.
First write your multiple connection strings in connectionStrings tag under configuration tag
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
<connectionStrings> <add name="SampleDatabaseSQL" connectionString="Data Source=local;Initial Catalog=Sample;Integrated Security=True" providerName="System.Data.SqlClient"/> <add name="TestDatabaseSQL" connectionString="Data Source=local;Initial Catalog=Test;Integrated Security=True" providerName="System.Data.SqlClient"/> <add name="SampleExcel" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Test.xlsx;Extended Properties=Excel 12.0" providerName="System.Data.OleDb"/> <add name="SampleMSAccess" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Test.accdb;" providerName="System.Data.OleDb"/> </connectionStrings> |
Now get multiple connections for multiple databases in your code
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
string Sample = ConfigurationManager.ConnectionStrings["SampleDatabaseSQL"].ConnectionString; SqlConnection ObjConnSample = new SqlConnection(Sample); ObjConnSample.Open(); // Do you work with database ObjConnSample.Close(); string Test = ConfigurationManager.ConnectionStrings["TestDatabaseSQL"].ConnectionString; SqlConnection ObjConnTest = new SqlConnection(Test); ObjConnTest.Open(); // Do you work with database ObjConnTest.Close(); string Excel = ConfigurationManager.ConnectionStrings["TestExcelConnection"].ConnectionString; OleDbConnection ObjConnExcel = new OleDbConnection(Excel); ObjConnExcel.Open(); // Do you work with database ObjConnExcel.Close(); string MSAccess = ConfigurationManager.ConnectionStrings["TestMSAccessConnection"].ConnectionString; OleDbConnection ObjConnMSAccess = new OleDbConnection(MSAccess); ObjConnMSAccess.Open(); // Do you work with database ObjConnMSAccess.Close(); |
Thank you