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

本文介绍了如何在Windows应用程序中编写连接字符串的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

在Web应用程序中，我们用来编写web.config文件以访问数据库连接，就像我在Windows应用程序中所希望的一样.

In web applications we use to write web.config file to access database connectivity like same way i want in windows application

推荐答案

<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;

<?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>

<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;

这篇关于如何在Windows应用程序中编写连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！