本文介绍了App.config连接字符串的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

嗨!

我正在使用带有ms访问权限的vb.net Win窗体2005.我想将连接字符串设置为全局.
为此,我将连接字符串放在app.config中,例如:

Hie!

I am using vb.net Win forms 2005 with ms access. I want to make my connectionstring global.
For that i am putting my connectionstring in app.config like:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />
  </configSections>
  <appSettings >
    <add key ="Test" value ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Transport.mdb" />
  </appSettings>


在我的表格中,我的阅读方式如下:


In my form i read it like:

dim str as string
dim stringcn as string
strincn=configuratiomanager.appsetting("Test")
dim cn as oledbconnection
cn=new oledbconnection(stringcn)
cn.open()
str = "isert into tablename(column1) values(fieldname)"


但是当我运行它时,它不会给出任何错误,但是没有任何内容存储在数据库中.

那是什么问题呢?错误在哪里?
请告诉我.


but when i run it does not give any error but nothing gets stored in the database.

So what is the problem? Where is the mistake?
Please tell me.

推荐答案

<br />
cn=new oledbconnection(stringcn);<br />
cn.open()<br />
if(cn.State==ConectionState.Open)<br />
{<br />
   MessageBox.Show("Connection Opened");<br />
}<br />
else<br />
{<br />
   MessageBox.Show("Connection Closed");<br />
}<br />
<br />



如果您看到连接已打开,则问题可能出在其他地方.然后使用try-catch块来确定是否出了问题.



If you see connection is opened, then the problem might be in some other place. Then use try-catch block to identify if anything goes wrong.



这篇关于App.config连接字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

06-03 17:48
查看更多