HI FRENZ,

IS THERE ANY WAY THAT I CAN PUT MY CONNECTION STRING FOR DATABASE IN WEB
CONFIG FILE AND ACCESS IT FROM OVER THERE ALL THE TIME ???

IF NOT HOW CAN I DECLARE IT ONCE FOR MY APPLICATION, I MEAN AT JES ONE PLACE
N USE IT FRM OVER THERE.

THANX IN ADVANCE

ROHIT

Hi Rohit,

Al you have to do is to add the following to your web.config:

  <appSettings>
    <add key=3D"conString" value=3D"--- your connection string ----" />;
  </appSettings>

In your code :

 System.Configuration.AppSettingsReader conReader =3D new 
AppSettingsReader();
 SqlConnection dbCon =3D new 
SqlConnection((string)conReader.GetValue("conString", typeof(string)));

Lars


-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: 20. november 2002 09:19
To: ASP.NET
Subject: [aspx] CONNECTION STRING .....WEB CONFIG FILE ?????


HI FRENZ,

IS THERE ANY WAY THAT I CAN PUT MY CONNECTION STRING FOR DATABASE IN WEB 
CONFIG FILE AND ACCESS IT FROM OVER THERE ALL THE TIME ???

IF NOT HOW CAN I DECLARE IT ONCE FOR MY APPLICATION, I MEAN AT JES ONE 
PLACE N USE IT FRM OVER THERE.

THANX IN ADVANCE

ROHIT