Question about AppSettings?

[Rudy]

Hello All!
I'm just trying to set my SQL connection String in the app setting of my
Web Config. I got it to work on one page, but my code is a little diffrent
for another page that has a little more code and stuff goin on.

This is my current connection string..
Protected Const SQL_CONNECTION_ STRING As String = _
"Data Source=192.168. 100.120,xxxx;Ne twork Library=dbmssoc n;Initial
Catalog=mycatal og;User ID=****;Passwor d=*****;"

This is the line of code that I would like to use
Dim myconnection As New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnString" ))

But when I use it, "SQL_Connection _String" is tagged as wrong in a line of
code further down, like...
Dim Sqlconnection1 As New SqlConnection(S QL_CONNECTION_S TRING)
I get "Not declared" error.
I also tried it this way,
''' Protected Const SQL_CONNECTION_ STRING As String = "MyConnecti on"

I'm think I'm just not putting it in the right way.

Any advice would be great!!

TIA!!!

Rudy

[Juan T. Llibre]

Ty this in web.config:

<configuratio n>
<appSettings>
<add key="connstring " value="server=D ata Source=192.168. 100.120,xxxx;Ne twork Library=dbmssoc n;Initial Catalog=mycatal og;User ID=****;Passwor d=*****;"/>
</appSettings>
</configuration>

Then, in your aspx file, call it like this :
Dim myConnection as New SqlConnection(C onfigurationSet tings.AppSettin gs("connstring" ))

Juan T. Llibre
ASP.NET MVP
===========
"Rudy" <Ru**@discussio ns.microsoft.co m> wrote in message news:BD******** *************** ***********@mic rosoft.com...

Hello All!
I'm just trying to set my SQL connection String in the app setting of my
Web Config. I got it to work on one page, but my code is a little diffrent
for another page that has a little more code and stuff goin on.

This is my current connection string..
Protected Const SQL_CONNECTION_ STRING As String = _
"Data Source=192.168. 100.120,xxxx;Ne twork Library=dbmssoc n;Initial
Catalog=mycatal og;User ID=****;Passwor d=*****;"

This is the line of code that I would like to use
Dim myconnection As New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnString" ))

But when I use it, "SQL_Connection _String" is tagged as wrong in a line of
code further down, like...
Dim Sqlconnection1 As New SqlConnection(S QL_CONNECTION_S TRING)
I get "Not declared" error.
I also tried it this way,
''' Protected Const SQL_CONNECTION_ STRING As String = "MyConnecti on"

I'm think I'm just not putting it in the right way.

Any advice would be great!!

TIA!!!

Rudy

[Rudy]

Hello Juan,
Thanks for the quick response.
I have my code correct in my web config. In my one page, where this does
work, I'm calling up my key from the app settings as
Dim myconnection As New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnString" ))
This works great! It this other line of code that I have that I mentined
earlier,
Protected SQL_CONNECTION_ STRING As String = _
'"Data Source=192.168. 100.120,xxxx;Ne twork Library=dbmssoc n;Initial
Catalog=mycatal og;User ID=xxxx;Passwor d=xxxx;"
that I can't seem to call it the same way. Is it because I'm calling it as a
string?

Rudy
"Juan T. Llibre" wrote:

Ty this in web.config:

<configuratio n>
<appSettings>
<add key="connstring " value="server=D ata Source=192.168. 100.120,xxxx;Ne twork Library=dbmssoc n;Initial Catalog=mycatal og;User ID=****;Passwor d=*****;"/>
</appSettings>
</configuration>

Then, in your aspx file, call it like this :
Dim myConnection as New SqlConnection(C onfigurationSet tings.AppSettin gs("connstring" ))

Juan T. Llibre
ASP.NET MVP
===========
"Rudy" <Ru**@discussio ns.microsoft.co m> wrote in message news:BD******** *************** ***********@mic rosoft.com...

Hello All!
I'm just trying to set my SQL connection String in the app setting of my
Web Config. I got it to work on one page, but my code is a little diffrent
for another page that has a little more code and stuff goin on.

This is my current connection string..
Protected Const SQL_CONNECTION_ STRING As String = _
"Data Source=192.168. 100.120,xxxx;Ne twork Library=dbmssoc n;Initial
Catalog=mycatal og;User ID=****;Passwor d=*****;"

This is the line of code that I would like to use
Dim myconnection As New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnString" ))

But when I use it, "SQL_Connection _String" is tagged as wrong in a line of
code further down, like...
Dim Sqlconnection1 As New SqlConnection(S QL_CONNECTION_S TRING)
I get "Not declared" error.
I also tried it this way,
''' Protected Const SQL_CONNECTION_ STRING As String = "MyConnecti on"

I'm think I'm just not putting it in the right way.

Any advice would be great!!

TIA!!!

Rudy

[Rudy]

Hello All!!

I figured it out. I just didn't put my code in the right combination. All I
had to do to call my connection string from the apps in thw web config was
Protected SQL_CONNECTION_ STRING As String =
ConfigurationSe ttings.AppSetti ngs("ConnString ")
Thanks for your help Juan!!

Rudy

"Rudy" wrote:

Hello All!
I'm just trying to set my SQL connection String in the app setting of my
Web Config. I got it to work on one page, but my code is a little diffrent
for another page that has a little more code and stuff goin on.

This is my current connection string..
Protected Const SQL_CONNECTION_ STRING As String = _
"Data Source=192.168. 100.120,xxxx;Ne twork Library=dbmssoc n;Initial
Catalog=mycatal og;User ID=****;Passwor d=*****;"

This is the line of code that I would like to use
Dim myconnection As New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnString" ))

But when I use it, "SQL_Connection _String" is tagged as wrong in a line of
code further down, like...
Dim Sqlconnection1 As New SqlConnection(S QL_CONNECTION_S TRING)
I get "Not declared" error.
I also tried it this way,
''' Protected Const SQL_CONNECTION_ STRING As String = "MyConnecti on"

I'm think I'm just not putting it in the right way.

Any advice would be great!!

TIA!!!

Rudy