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.

<configuration>
<appSettings>
<add key="ConnectionString"
value="server=localhost;database=testdb;uid=sa;pas sword=secret;" />
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>

In your code, access like this..

strConnection = ConfigurationSettings.AppSettings("ConnectionStrin g")
sqlConn = New SqlConnection(strConnection)
sqlCmd = New SqlCommand("SELECT * 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

ConfigurationSettings.AppSettings("ConnectionStrin g")
Imports System.Configuration.ConfigurationSettings

"John Paul. A" <Jo*******@discussions.microsoft.com> wrote in message
news:13**********************************@microsof t.com...

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

<configuration>
<appSettings>
<add key="ConnectionString"
value="server=localhost;database=testdb;uid=sa;pas sword=secret;" />
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>

In your code, access like this..

strConnection = ConfigurationSettings.AppSettings("ConnectionStrin g")
sqlConn = New SqlConnection(strConnection)
sqlCmd = New SqlCommand("SELECT * 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.SQLConnection1.ConnectionString =
System.Configuration.ConfigurationSettings.AppSett ings("CS")

HTH.
Regards
Jignesh.

"Perin" <ja****************@hotmail.com> wrote in message
news:9A**********************************@microsof t.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 ConfigurationSettings, so that
you arent relying on magic constants...

class MyConfiguration
{
public static string ConnectionString { get { return ConfigurationSettings.AppSettings["ConnectionString"];
} }
}

then: SqlConnection conn = new SqlConnection(MyConfiguration.ConnectionString);

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.
<configuration>
<appSettings>
<add key="ConnectionString"
value="server=localhost;database=testdb;uid=sa;pas sword=secret;"
/>
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
In your code, access like this..

strConnection = ConfigurationSettings.AppSettings("ConnectionStrin g")
sqlConn = New SqlConnection(strConnection)
sqlCmd = New SqlCommand("SELECT * 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 ConfigurationSettings, so that
you arent relying on magic constants...

class MyConfiguration
{
public static string ConnectionString { get { return ConfigurationSettings.AppSettings["ConnectionString"];
} }
}

then: SqlConnection conn = new SqlConnection(MyConfiguration.ConnectionString);

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.
<configuration>
<appSettings>
<add key="ConnectionString"
value="server=localhost;database=testdb;uid=sa;pas sword=secret;"
/>
</appSettings>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
In your code, access like this..

strConnection = ConfigurationSettings.AppSettings("ConnectionStrin g")
sqlConn = New SqlConnection(strConnection)
sqlCmd = New SqlCommand("SELECT * 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