Monday, July 23, 2007

Web.Config: Read ConnectionStrings from Web.Config

Read Connection String from Web.Config:

System.Configuration.Configuration rootWebConfig =
System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(“/WebsiteRoot”);
System.Configuration.ConnectionStringSettings connString;

if(0< rootWebConfig.ConnectionStrings.ConnectionStrings.Count)
{
connString = rootWebConfig.ConnectionStrings.ConnectionStrings[“NorthwindConnectionString”];

if(null != connString)
Console.WriteLine(“Northwind conn string = \” {0}\”, connString.ConnectionString);
else
Console.WriteLine(“Conn string not found..”);

}

No comments:

Post a Comment