How to get connection string

[SF]

Hi

How to get connection string from web.config?

SF

[Mark Rae [MVP]]

"SF" <xy*@yahoo.comwrote in message
news:ue**************@TK2MSFTNGP02.phx.gbl...

How to get connection string from web.config?

strConnectionString =
System.Configuration.ConfigurationManager.Connecti onStrings["SQLConnectionString"].ConnectionString;
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Cowboy \(Gregory A. Beamer\)]

//C#
string connectionString =
ConfigurationManager.ConnectionStrings["connStringName"].ToString();

'VB
Dim connectionString as String = _
ConfigurationManager.ConnectionStrings("connString Name").ToString()

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

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
"SF" <xy*@yahoo.comwrote in message
news:ue**************@TK2MSFTNGP02.phx.gbl...

Hi

How to get connection string from web.config?

SF

[Cyril Gupta]

Connection string ....

Now you know how, so let me tell you something interesting.

If someone gets hold of your connectionstring, they can potentially
access your db (cause your connectionstring has the db user name, and
pwd). Remember never to use a literal connection string, it's best to
put it in web config.

If possible use Windows authentication, and you will be safer, cause
you would not have user id and pwd in the connectionstring, and nobody
would be able to gain access to the db using those.

Cheers!
Cyril Gupta

[Mark Rae [MVP]]

"Cyril Gupta" <cy********@gmail.comwrote in message
news:4a**********************************@d19g2000 prm.googlegroups.com...

it's best to put it in web config.

That's what the OP asked for..
--
Mark Rae
ASP.NET MVP
http://www.markrae.net