How to store connection string in congif file

[Perin]

Hi,
I am using SQL Server as a Database in my ASP.NET application. Can anyone
tell me, how to store my connection string in web.config file and access it
from my application.
It is very urgent please..

--
Perin

[John Paul. A]

Hi Perin,
In web.config file, add the section below.

<configuratio n>
<appSettings>
<add key="Connection String"
value="server=l ocalhost;databa se=testdb;uid=s a;password=secr et;" />
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>

In your code, access like this..

strConnection = ConfigurationSe ttings.AppSetti ngs("Connection String")
sqlConn = New SqlConnection(s trConnection)
sqlCmd = New SqlCommand("SEL ECT * FROM Customers", sqlConn)
sqlConn.Open()

Very simple..

Rgds,
John Paul. A

"Perin" wrote:

Hi,
I am using SQL Server as a Database in my ASP.NET application. Can anyone
tell me, how to store my connection string in web.config file and access it
from my application.
It is very urgent please..

--
Perin

[weichung [MCSD, MCDBA]]

This method is highlighted in the Microsoft Inovation Day

SQL Connection String in web.config using DPAPI:

http://msdn.microsoft.com/library/de...SecNetHT08.asp

http://builder.com.com/5100-6373_14-...ml#Listing%20A

"Perin" wrote:

Hi,
I am using SQL Server as a Database in my ASP.NET application. Can anyone
tell me, how to store my connection string in web.config file and access it
from my application.
It is very urgent please..

--
Perin

[Leo]

Just remember to add the following import statement at the top of any
module/Codebehind/class that will be using

ConfigurationSe ttings.AppSetti ngs("Connection String")
Imports System.Configur ation.Configura tionSettings

"John Paul. A" <Jo*******@disc ussions.microso ft.com> wrote in message
news:13******** *************** ***********@mic rosoft.com...

Hi Perin,
In web.config file, add the section below.

<configuratio n>
<appSettings>
<add key="Connection String"
value="server=l ocalhost;databa se=testdb;uid=s a;password=secr et;" />
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>

In your code, access like this..

strConnection = ConfigurationSe ttings.AppSetti ngs("Connection String")
sqlConn = New SqlConnection(s trConnection)
sqlCmd = New SqlCommand("SEL ECT * FROM Customers", sqlConn)
sqlConn.Open()

Very simple..

Rgds,
John Paul. A

"Perin" wrote:

Hi,
I am using SQL Server as a Database in my ASP.NET application. Can anyone
tell me, how to store my connection string in web.config file and access
it
from my application.
It is very urgent please..

--
Perin

[Jignesh Desai]

In web.Config you have an <appSettings> section.
Insert following lines
<add key="CS"
value=" Write connection string here." />

From codebehind pages access CS by
Me.SQLConnectio n1.ConnectionSt ring =
System.Configur ation.Configura tionSettings.Ap pSettings("CS")

HTH.
Regards
Jignesh.

"Perin" <ja************ ****@hotmail.co m> wrote in message
news:9A******** *************** ***********@mic rosoft.com...

Hi,
I am using SQL Server as a Database in my ASP.NET application. Can anyone
tell me, how to store my connection string in web.config file and access it from my application.
It is very urgent please..

--
Perin

[Matt Berther]

Hello John,

Even better would be a class that wraps the ConfigurationSe ttings, so that
you arent relying on magic constants...

class MyConfiguration
{
public static string ConnectionStrin g { get { return ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];
} }
}

then: SqlConnection conn = new SqlConnection(M yConfiguration. ConnectionStrin g);

This way, errors are caught at compile time, rather than runtime. Also, if
you happen to change the name of the setting in the app.config, you can change
it in one spot, rather than having to do a global search/replace.

--
Matt Berther
http://www.mattberther.com

Hi Perin,
In web.config file, add the section below.
<configuratio n>
<appSettings>
<add key="Connection String"
value="server=l ocalhost;databa se=testdb;uid=s a;password=secr et;"
/>
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
In your code, access like this..

strConnection = ConfigurationSe ttings.AppSetti ngs("Connection String")
sqlConn = New SqlConnection(s trConnection)
sqlCmd = New SqlCommand("SEL ECT * FROM Customers", sqlConn)
sqlConn.Open()
Very simple..

Rgds,
John Paul. A
"Perin" wrote:

Hi,
I am using SQL Server as a Database in my ASP.NET application. Can
anyone
tell me, how to store my connection string in web.config file and
access it
from my application.
It is very urgent please..
-- Perin

[John Paul. A]

Dear MAtt Berther,
What you are saying is right.
Thanks for your guidance.

Rgds,
John Paul. A

"Matt Berther" wrote:

Hello John,

Even better would be a class that wraps the ConfigurationSe ttings, so that
you arent relying on magic constants...

class MyConfiguration
{
public static string ConnectionStrin g { get { return ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];
} }
}

then: SqlConnection conn = new SqlConnection(M yConfiguration. ConnectionStrin g);

This way, errors are caught at compile time, rather than runtime. Also, if
you happen to change the name of the setting in the app.config, you can change
it in one spot, rather than having to do a global search/replace.

--
Matt Berther
http://www.mattberther.com

Hi Perin,
In web.config file, add the section below.
<configuratio n>
<appSettings>
<add key="Connection String"
value="server=l ocalhost;databa se=testdb;uid=s a;password=secr et;"
/>
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
In your code, access like this..

strConnection = ConfigurationSe ttings.AppSetti ngs("Connection String")
sqlConn = New SqlConnection(s trConnection)
sqlCmd = New SqlCommand("SEL ECT * FROM Customers", sqlConn)
sqlConn.Open()
Very simple..

Rgds,
John Paul. A
"Perin" wrote:

Hi,
I am using SQL Server as a Database in my ASP.NET application. Can
anyone
tell me, how to store my connection string in web.config file and
access it
from my application.
It is very urgent please..
-- Perin