Use the connection string in App.Config

[FastEddie]

I have a connection string named in my app.config file but I don't know how to reference it with code. For instance what do I put in the connection string for this code block?

Dim cnn As New OleDbConnection
        Dim cmd As New OleDbCommand
        Dim dr As OleDbDataReader
        cnn.ConnectionString = ""
        cmd = cnn.CreateCommand

My connection settings look like this

<connectionStrings>
        <add 
          name="BarCodeReader.My.MySettings.db4ConnectionString" 
          connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db4.mdb"
          providerName="System.Data.OleDb" />
    </connectionStrings>

[vbdotnetboy]

are you using vb2005? i'm assuming so since i see BarCodeReader.My.MySettings

do the following...

Dim cnn As New OleDbConnection
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
Dim YourSettings As My.MySettings
 
cnn.ConnectionString = YourSettings.db4ConnectionString
cmd = cnn.CreateCommand

[vbdotnetboy]

sorry wait i'm not thinking for the way i'm doing something in my app

all you need to do is...

My.Settings.db4ConnectionString

[FastEddie]

Well that is pretty simple. Thanks.

[vbdotnetboy]

anytime