且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Windows应用程序中编写连接字符串

更新时间:2023-11-07 19:39:28

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




然后在c#




Then in c#

SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyDBConnectionString"].ConnectionString;

>


您需要在项目中具有app.config,其余部分与web.config中的相同.
You need to have app.config in the project, and rest of the part remains same as in web.config.
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="DBEntities" connectionString="metadata=res://*/TestModel.csdl|res://*/TestModel.ssdl|res://*/TestModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=127.0.0.1\Dev;Initial Catalog=TestDB;User ID=TestUser;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
</configuration>


在Windows应用程序中,我们有app.config文件,将以下代码添加到该xml文件中
<connectionstrings>
      <add name="MyConnectionString" providername="System.Data.SqlClient">
            connectionString="Data Source=localhost;Initial Catalog=MySQLServerDB; Integrated Security=true" />
  </add></connectionstrings>  


要从form.cs访问它,请编写与Web应用程序.aspx.cs页面相同的代码,如下所示


To access it from form.cs write the same code as web applications .aspx.cs page as following

SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

>