How to get connection string from app.config in C#
By FoxLearn 11/15/2024 10:01:57 AM 216
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
.
- How to fix 'Failure sending mail' in C#
- How to Parse a Comma-Separated String from App.config in C#
- How to convert a dictionary to a list in C#
- How to retrieve the Executable Path in C#
- How to validate an IP address in C#
- How to retrieve the Downloads Directory Path in C#
- C# Tutorial
- Dictionary with multiple values per key in C#
Categories
Popular Posts
Freedash bootstrap lite
11/13/2024
Dashboardkit Bootstrap
11/13/2024
Stisla Admin Dashboard Template
11/18/2024