Various Ways To Specify Connection String In ASP.NET Web And Windows Applications

In the preceding I have written a method to get the connection on the basis of the keyname passed.

Then I will show you how to use the preceding method of this class in code to access connections. In the following code you can see I have used the GetConnectionstring method of the ConnectionString class and passed the keyname to connect to the specific database using keyname.



If you got this error when reading a connection string from a web.config file then go to this link: Click here to fix the following error.



Using the preceding described way you can connect to the database using this method, there is no need to write a connection code in every page.

Now we will see the next way to specify a connection.

Now I will create a common class file with connection code.

I have created a DBConnectionClass.cs file and then written the following code in this class. You can use this class file in multiple Web applications where you need to use the same database connection.

In this class I declared an enum for the list of the database. We can specify all the database names to be used across application and access them using an enum.

Then I wrote a method, GetConnectionstring, with Database enum parameter.



Write the following code in your class:

Then I will describe how to access this class method in a web page.

You can call this method as in DBConnectionClass.Getconnectionstring(DBConnectionClass.Database.Northwind).

Specify Database connection string in Windows application

In the same way you saw in the web.config file you need to write this tag inside the app.config file.



In the same way I already described, for the web application you can read a connection from the app.config.

But one extra thing you need to do in Windows applications is that you need to add a reference of System.Configuration to your application.



Then you need to follow the steps I already described for web applications.

You can also add a common DBConnectionClass class in the Windows application for the connection in the same way that I described in the Web section of this article.