Where is best place to put DB connection string?

[Charlie]

Hi:

My ASP.NET app opens and closes database connection in several pages.
Rather than hard coding string into every page, is there a place I can put
it where all pages will be able to access it. In days of fat client
programming, I put in INI file. Looking for similar solution.

Thanks,
Charlie

[Arvind P Rangan]

Make use of web.config

"Charlie@CB FC" <ch*****@comcas t.net> wrote in message
news:ep******** *****@TK2MSFTNG P11.phx.gbl...

Hi:

My ASP.NET app opens and closes database connection in several pages.
Rather than hard coding string into every page, is there a place I can put
it where all pages will be able to access it. In days of fat client
programming, I put in INI file. Looking for similar solution.

Thanks,
Charlie

[Martin Dechev]

Hi, Charlie,

Here is a sample:

http://samples.gotdotnet.com/quickst...%2fconfig1.src

Greetings
Martin
"Charlie@CB FC" <ch*****@comcas t.net> wrote in message
news:ep******** *****@TK2MSFTNG P11.phx.gbl...

Hi:

My ASP.NET app opens and closes database connection in several pages.
Rather than hard coding string into every page, is there a place I can put
it where all pages will be able to access it. In days of fat client
programming, I put in INI file. Looking for similar solution.

Thanks,
Charlie

[Cowboy \(Gregory A. Beamer\)]

Most people aim for web.config, but I would at least encrypt the string if
you do that. There are free books on ASP.NET security at
http://msdn.microsoft.com/architecture. Look at the "Patterns and Practices"
section.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"Charlie@CB FC" <ch*****@comcas t.net> wrote in message
news:ep******** *****@TK2MSFTNG P11.phx.gbl...

Hi:

My ASP.NET app opens and closes database connection in several pages.
Rather than hard coding string into every page, is there a place I can put
it where all pages will be able to access it. In days of fat client
programming, I put in INI file. Looking for similar solution.

Thanks,
Charlie

[Max]

Most people use the web.config, but it certain cases I've found it more
secure to just store it as a global variable within your app where it is
compiled.

-Max

"Charlie@CB FC" <ch*****@comcas t.net> wrote in message
news:ep******** *****@TK2MSFTNG P11.phx.gbl...

Hi:

My ASP.NET app opens and closes database connection in several pages.
Rather than hard coding string into every page, is there a place I can put
it where all pages will be able to access it. In days of fat client
programming, I put in INI file. Looking for similar solution.

Thanks,
Charlie

[Kevin Spencer]

If you "store it as a global variable" it must be defined (read
"hard-coded") somewhere. I believe "where" was the question.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Max" <ma*****@portvi sta.com> wrote in message
news:lh******** **************@ twister.tampaba y.rr.com...

Most people use the web.config, but it certain cases I've found it more
secure to just store it as a global variable within your app where it is
compiled.

-Max

"Charlie@CB FC" <ch*****@comcas t.net> wrote in message
news:ep******** *****@TK2MSFTNG P11.phx.gbl...

Hi:

My ASP.NET app opens and closes database connection in several pages.
Rather than hard coding string into every page, is there a place I can put it where all pages will be able to access it. In days of fat client
programming, I put in INI file. Looking for similar solution.

Thanks,
Charlie

[Max]

public class myvars
public shared strConnection = "blah blah blah happy now?"
end class

imports YourAppName.myv ars

strConnection is now a variable you can use anywhere

Be careful what changes this variable as it is shared, and turn off page
errors so it doesn't bomb out and show your connection string to everyone.

-Max
"Kevin Spencer" <ke***@takempis .com> wrote in message
news:OP******** *****@tk2msftng p13.phx.gbl...

If you "store it as a global variable" it must be defined (read
"hard-coded") somewhere. I believe "where" was the question.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Max" <ma*****@portvi sta.com> wrote in message
news:lh******** **************@ twister.tampaba y.rr.com...

Most people use the web.config, but it certain cases I've found it more
secure to just store it as a global variable within your app where it is
compiled.

-Max

"Charlie@CB FC" <ch*****@comcas t.net> wrote in message
news:ep******** *****@TK2MSFTNG P11.phx.gbl...

Hi:

My ASP.NET app opens and closes database connection in several pages.
Rather than hard coding string into every page, is there a place I can put it where all pages will be able to access it. In days of fat client
programming, I put in INI file. Looking for similar solution.

Thanks,
Charlie

[Max]

public shared strConnection as string = "your conn"

you get the idea

"Max" <ma*****@portvi sta.com> wrote in message
news:%D******** **************@ twister.tampaba y.rr.com...

public class myvars
public shared strConnection = "blah blah blah happy now?"
end class

[Martin Dechev]

Hi, Max,

As Kevin stated, with this technique the string is hard-coded, which in
other words means it is *not* configurable.

Greetings
Martin
"Max" <ma*****@portvi sta.com> wrote in message
news:%E******** **************@ twister.tampaba y.rr.com...

public shared strConnection as string = "your conn"

you get the idea

"Max" <ma*****@portvi sta.com> wrote in message
news:%D******** **************@ twister.tampaba y.rr.com...

public class myvars
public shared strConnection = "blah blah blah happy now?"
end class