How to get connection string from app.config in C#
By FoxLearn 11/15/2024 10:01:57 AM 144
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 'Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on'
- How to use BlockingCollection in C#
- Calculating the Distance Between Two Coordinates in C#
- Could Not Find an Implementation of the Query Pattern
- Fixing Invalid Parameter Type in Attribute Constructor
- Objects added to a BindingSource’s list must all be of the same type
- How to use dictionary with tuples in C#
- How to convert a dictionary to a list in C#
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
12/19/2024