在 C# winform 中使用 app.config 访问数据库连接字符串 [英] Accessing database connection string using app.config in C# winform

问题描述

我似乎无法在我的 c# winforms 应用程序中访问 app.config 数据库连接字符串.

I can't seem to be able to access the app.config database connection string in my c# winforms app.

app.config 代码

app.config code

   <connectionStrings>
      <add name="MyDBConnectionString" providerName="System.Data.SqlClient"
            connectionString="Data Source=localhost;Initial Catalog=MySQLServerDB; Integrated Security=true" />
   </connectionStrings>  

C# 代码:

SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["MyDBConnectionString"];    

当我尝试 C# 代码时，收到一条消息:
警告 1 'System.Configuration.ConfigurationSettings.AppSettings' 已过时:'此方法已过时，已被 System.Configuration!System.Configuration.ConfigurationManager.AppSettings'

When I try the C# code, I get a message:
Warning 1 'System.Configuration.ConfigurationSettings.AppSettings' is obsolete: ' This method is obsolete, it has been replaced by System.Configuration!System.Configuration.ConfigurationManager.AppSettings'

但是，当我尝试使用:

conn.ConnectionString = System.Configuration!System.Configuration.ConfigurationManager.AppSettings["MyDBConnectionString"];  

我得到一个错误:只有赋值、调用、递增、递减和新对象表达式可以用作语句

推荐答案

这就是你所需要的:

System.Configuration.ConfigurationManager.ConnectionStrings["MyDBConnectionString"].ConnectionString;

这篇关于在 C# winform 中使用 app.config 访问数据库连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！