Use the connection string in App.Config
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?
VB Code:
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
VB Code:
<connectionStrings>
<add
name="BarCodeReader.My.MySettings.db4ConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db4.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
Re: Use the connection string in App.Config
are you using vb2005? i'm assuming so since i see BarCodeReader.My.MySettings
do the following...
VB Code:
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
Re: Use the connection string in App.Config
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
Re: Use the connection string in App.Config
Well that is pretty simple. Thanks.
Re: Use the connection string in App.Config