Store web.config value in SQL table

[jack]

I have an application wide configuration setting (pages theme) that
is
dynamic. Normally when you think of picking themes you think of the
user selecting a theme (a per-user setting). In this case, though, I
want the site owner to be able to select a theme that will be applied
to the entire site (not per user). I do not want to programmaticall y
write out/edit the web.config file because of permissions issues. I
simply want the user to be able to set a value in a SQL table that
will then be grabbed (possibly in the Application_OnS tart function in
global.asax) that will apply the theme to the entire site. This
isn't
something that would change often, but it has to an editable value
that is not static (like most things in web.config).

I was thinking there might be a way to programmitcally change the
<pages theme=""setting in web.config in Application_OnS tart. Or is
there a way to bypass web.config entirely. I really don't want to
have to add code to every single Page_PreInit event)...
Thanks much.
Jack

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Hi Jack,

There are many different approaches to this (base class or master page), but
the easiest is to handle one application event in global.asax

void Application_Sta rt(object sender, EventArgs e)
{
// retrieve the value from database;
Application[ThemeKey] = "red";
}

private const string ThemeKey = "DefaultThe me";

protected void Application_Pre RequestHandlerE xecute(
object sender, EventArgs e)
{
// this is the first event in which
// request handler is instantiated and accessible
Page page = HttpContext.Cur rent.CurrentHan dler as Page;
if (page != null)
{
page.Theme = Application[ThemeKey];
}
}

hope this helps
--
Milosz
"jack" wrote:

I have an application wide configuration setting (pages theme) that
is
dynamic. Normally when you think of picking themes you think of the
user selecting a theme (a per-user setting). In this case, though, I
want the site owner to be able to select a theme that will be applied
to the entire site (not per user). I do not want to programmaticall y
write out/edit the web.config file because of permissions issues. I
simply want the user to be able to set a value in a SQL table that
will then be grabbed (possibly in the Application_OnS tart function in
global.asax) that will apply the theme to the entire site. This
isn't
something that would change often, but it has to an editable value
that is not static (like most things in web.config).

I was thinking there might be a way to programmitcally change the
<pages theme=""setting in web.config in Application_OnS tart. Or is
there a way to bypass web.config entirely. I really don't want to
have to add code to every single Page_PreInit event)...
Thanks much.
Jack