如何从App链接tme connectionstring。配置 [英] How to code link tme connectionstring from App. config

问题描述

In the past I  hand coded the connectionString but I read somewhere that it is a bad 

练习。现在我尝试从App.config中调用它，但我没有太多运气。

practice. Now I am trying call it from App.config but I am not having much luck.

如果能得到一些帮助，我将不胜感激

Will appreciate if I can get some help

<？ < span style ="color：＃a31515; font-size：small"> xml version = " 1.0 " 编码 = " utf-8 " ？>

<?xmlversion="1.0"encoding="utf-8"?>

< configuration >

< configSections >

< / configSections >

< connectionStrings >

< add name = " SecSchool.My.MySettings.SecDbConnectionString "

<addname="SecSchool.My.MySettings.SecDbConnectionString"

connectionString = " Provider = Microsoft.ACE.OLEDB.12.0; Data
Source = & quot; C：\ VBB.Net
Secondary \Secdb.accdb & quot; "

connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&quot;C:\VB.Net Secondary\Secdb.accdb&quot;"

providerName = " System.Data.OleDb " />

providerName="System.Data.OleDb"/>

< / connectionStrings >

< startup >

< supportedRuntime version = " v4.0 " sku = " 。NETFramework，Version = v4.5 " />

<supportedRuntimeversion="v4.0"sku=".NETFramework,Version=v4.5"/>

< / startup >

< / configuration >

推荐答案

为System.Configuration添加对项目的引用。为下面的代码添加System.Configuration的Import语句。

Add a reference to the project for System.Configuration. Add a Import statement for System.Configuration for the code below.

ConfigurationManager.ConnectionStrings(1).ConnectionString

您甚至可以发布连接字符串，例如

You can even diset the connection string e.g.

Dim builder As New OleDb.OleDbConnectionStringBuilder With {.ConnectionString = ConfigurationManager.ConnectionStrings(1).ConnectionString}
Console.WriteLine(builder.DataSource)
Console.WriteLine(builder.ConnectionString)

使用它

Using cn As New OleDbConnection With {.ConnectionString = ConfigurationManager.ConnectionStrings(1).ConnectionString}
    cn.Open()
End Using

这篇关于如何从App链接tme connectionstring。配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！