如何创建asp.net C＃中的连接字符串 [英] How to create a connection string in asp.net c#

问题描述

我的工作asp.net C＃项目，连接我使用：

 的SqlConnection CON =新的SqlConnection（@数据源= \\ SQLEX $ P $干燥综合征; AttachDbFilename = D：\\ 19-02 \\ ABCC \\ App_Data文件\\ abcc.mdf;集成安全性=真;用户实例=真）;
 

但我希望得到这个连接字符串来获得配置和是这样的，所以任何一个可以帮助如何建立这种连接。

 的SqlConnection CON =新的SqlConnection（ConfigurationManager.ConnectionStrings [itmall]的ConnectionString）;
 

解决方案

演示：

 ＆LT;＆是connectionStrings GT;
＆LT;添加名称=myConnectionString的connectionString =服务器=本地主机;数据库= MYDB; UID = MYUSER;密码=为mypass; /＆GT;
＆LT; /＆是connectionStrings GT;
 

根据你的问题：

 ＆LT;＆是connectionStrings GT;
    ＆LT;添加名称=itmall的connectionString =数据源= \\ SQLEX $ P $干燥综合征; AttachDbFilename = D：\\ 19-02 \\ ABCC \\ App_Data文件\\ abcc.mdf;集成安全=真;用户实例=真/ ＆GT;
    ＆LT; /＆是connectionStrings GT;
 

请参考链接：

http://www.connectionstrings.com/store-connection-string -in-webconfig /

从web.config文件Retrive连接字符串：

写文件下面code，你想;

 字符串CONNSTRING = ConfigurationManager.ConnectionStrings [itmall]的ConnectionString。SqlConnection的CON =新的SqlConnection（CONNSTRING）;
 

或者你可以去你的方式像

 的SqlConnection CON =新的SqlConnection（ConfigurationManager.ConnectionStrings [itmall]的ConnectionString）;
 

注意：

您在连接字符串中使用您的web.config文件和名称给的名称必须是相同的（如itmall，在这个解决方案。）

I am working on asp.net c# project, for connection I used:

SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-02\ABCC\App_Data\abcc.mdf;Integrated Security=True;User Instance=True");

but I want to get this connection string to get configure and be like this, so can any one help how to create this kind of connection.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["itmall"].ConnectionString);

解决方案

Demo :

<connectionStrings>
<add name="myConnectionString" connectionString="server=localhost;database=myDb;uid=myUser;password=myPass;" />
</connectionStrings>

Based on your question:

<connectionStrings>
    <add name="itmall" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-02\ABCC\App_Data\abcc.mdf;Integrated Security=True;User Instance=True" />
    </connectionStrings>

Refer links:

http://www.connectionstrings.com/store-connection-string-in-webconfig/

Retrive connection string from web.config file:

write the below code in your file where you want;

string connstring=ConfigurationManager.ConnectionStrings["itmall"].ConnectionString;

SqlConnection con = new SqlConnection(connstring);

or you can go in your way like

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["itmall"].ConnectionString);

Note:

The "name" which you gave in web.config file and name which you used in connection string must be same(like "itmall" in this solution.)

这篇关于如何创建asp.net C＃中的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！