How to get connection string from app.config in C#
By Tan Lee Published on Nov 13, 2024 546
To retrieve a connection string from the app.config file in C#, you can use the ConfigurationManager class.
Make sure that your project references the System.Configuration
assembly.
You can add System.Configuration
to your project by right-clicking the "References" node in Solution Explorer and selecting "Add Reference...". Then, choose System.Configuration
.
In your app.config
file, define a connection string inside the <connectionStrings>
element.
For example:
<configuration> <connectionStrings> <add name="cn" connectionString="Server=.;Database=myDb;User Id=sa;Password=123@qaz;" providerName="System.Data.SqlClient"/> </connectionStrings> </configuration>
Use ConfigurationManager.ConnectionStrings
to access the connection string.
// get connection string from app.config c# string connectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
Ensure that the connection string name in the ConfigurationManager.ConnectionStrings["cn"]
matches the name attribute in the app.config
.
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
Dec 19, 2024
Dash UI HTML5 Admin Dashboard Template
Nov 18, 2024
Focus Admin Dashboard Template
Nov 18, 2024
Material Lite Admin Template
Nov 14, 2024