View my complete profile

Monday, September 19, 2011

Two way to declare Connection string in Web config

Replace "(" with "<" and ")" with ">"

1) First way to define under Connectionstrings tag

(add connectionstring="Server=servername;Database=databaseName;uid=useridofdatabase;pwd=passwordofdatabase;Connection Timeout=5000"
name="CnName" providername="System.Data.SqlClient")(/connectionstrings)


2) second way in Under appsettings tag

(appsettings)
(add key="Servername" value="Server Name")
(add key="DatabaseName" value="databasevalue")
(add key="UserName" value="UserNameofdatabase")
(add key="Password" value="passwordofdatabase")
(/appsettings)

0 comments:

Site Meter