In this blog we are going to see, How to get connection string from web.config using asp.net c#.

Step 1: Used Namespace

using System.Web.Configuration;

Step 2: Connection String in Web.config

<configuration>

<add name="KeyName"

connectionString="Data Source=ServerName;Initial Catalog=dbsample;Integrated Security=True" />

</configuration>

Step 3: Usage

GetConnectionStringFromWebConfigByName(“KeyName");

Step 4: Method to fetch Connection String from Web.config

public static string GetConnectionStringFromWebConfigByName(string name)

{

return WebConfigurationManager.ConnectionStrings[name].ConnectionString;

}


Thanks for reading this article. Have a nice day.