我应该如何在vb.net中正确调用System.Configuration.ConfigurationManager.AppSettings？ [英] How should i call System.Configuration.ConfigurationManager.AppSettings properly in vb.net ?

问题描述

你好我正在使用visual studio 2008，vb.net和oracle作为我的数据库。



这是我在apps.config中保存的内容



< appSettings />

< add key =" SMSDW_connection" value =" server = abc; database = efg; User ID = **; Password = **;" />



这是我的代码调用apps.config文件：



Dim connectionString = System.Configuration.ConfigurationManager.AppSettings（" SMSDW_connection"）

Dim sqlConnection As OracleClient.OracleConnection =新的OracleClient.OracleConnection（connectionString）



但我仍然遇到错误：



ConnectionString属性尚未初始化。



i有添加引用：System.Configuration和Imports System.Configuration

hello i'm using visual studio 2008, vb.net and oracle as my db.

this is what i save in my apps.config

<appSettings/>
<add key="SMSDW_connection" value="server=abc;database=efg;User ID=**;Password=**;"/>

and this is my code for calling the apps.config file :

Dim connectionString = System.Configuration.ConfigurationManager.AppSettings("SMSDW_connection")
Dim sqlConnection As OracleClient.OracleConnection = New OracleClient.OracleConnection(connectionString)

but i still got an error which is :

The ConnectionString property has not been initialized.

i have add reference : System.Configuration and Imports System.Configuration

推荐答案

Dim connectionString = Properties.Settings.Default.SMSDW_connection

对不起，它使用My.Settings（太习惯了C＃）。例如：

Sorry, it uses My.Settings (too used to C#). For example:

Dim connectionString = My.Settings.SMSDW_connection

参见在VB.NET中访问应用程序设置 [ ^ ]

这篇关于我应该如何在vb.net中正确调用System.Configuration.ConfigurationManager.AppSettings？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！