我想从app.config文件中读取连接字符串。 [英] I want to read connection string from app.config file.

问题描述

我想从App.Config文件中读取连接字符串。

作为您的解决方案，我编写了此代码



< configuration>

< connectionstrings>

< add name =CharityManagement>

connectionString =Data Source = .; Initial Catalog = CharityManagement ;集成安全性=真/>





但我不知道我在连接字符串中提供数据库路径的地方和我想在本地模式下使用sqlserver

任何人都可以帮帮我。

预付谢谢



我尝试过：





< configuration>

< connectionstrings>

< add name =conconnectionstring =Data Source = .; Initial Catalog = DB; Integrated Securiry = True>

解决方案

在你的app.config中你要指定你的连接字符串。

 <   connectionStrings  >  
 <   add     name   =  DefaultConnection    connectionString   = 将您的连接字符串放在此处    providerName   =   System.Data.SqlClient    /  >  
 <   / connectionStrings  &g t;  

在您的c＃代码中，您可以这样访问它

  var  connstring = ConfigurationManager.ConnectionStrings [  DefaultConnection]; 

然后来自在那里你以任何方式访问你的数据库使用connstring。

参考以下链接。



如何：从Web.config文件中读取连接字符串 [ ^ ]



读取（获取）连接字符串来自ASP.Net中的Web.Config文件使用C＃和VB.Net [ ^ ]



在Web.config中存储连接字符串 - ConnectionStrings.com [ ^

I want to read connection string from App.Config file.
As your solution I wrote this code

<configuration>
<connectionstrings>
<add name="CharityManagement">
connectionString="Data Source=.;Initial Catalog=CharityManagement;Integrated Security=True"/>


but I have no idea where shoud I give my database path in connection string and I want to use sqlserver in Local mode
can anybody help me out.
Thanks in Advance

What I have tried:


<configuration>
<connectionstrings>
<add name="con" connectionstring="Data Source=.;Initial Catalog=DB;Integrated Securiry=True">

解决方案

In your app.config you would specify your connection string.

<connectionStrings>
    <add name="DefaultConnection" connectionString="put your connection string here" providerName="System.Data.SqlClient" />
</connectionStrings>

In your c# code you can access it as such

var connstring = ConfigurationManager.ConnectionStrings["DefaultConnection"];

Then from there you use connstring in whatever way you are accessing your database.

Refer the below links .

How to: Read Connection Strings from the Web.config File[^]

Read (Get) Connection String from Web.Config file in ASP.Net using C# and VB.Net[^]

Store Connection String in Web.config - ConnectionStrings.com[^]

这篇关于我想从app.config文件中读取连接字符串。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！