save and retrieve theme in database

help me with my code.. i've retrieve the theme id from database which i assign it to lblthemeID.Text. how do i assign the theme id to page. theme in page_preinit.. below are my codes.. please anyone help me..

 

protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection stud = studPortConn.GetStudPortCon())
{
stud.Open();

da.SelectCommand = new SqlCommand("SELECT theme_id FROM User_Theme where user_id = '1773'", stud);

SqlDataReader dr = da.SelectCommand.ExecuteReader();

if (dr.Read())
{
lblthemeID.Text += dr["theme_id"].ToString();
}

stud.Close();
}
}

protected void Page_PreInit(object sender, EventArgs e)
{
//Page.Theme = "Theme1";


if (Session["Theme1"] != null)
{
string Theme1 = Session["Theme1"].ToString();
Page.Theme = Theme1;
}


if (Session["Theme2"] != null)
{
string Theme2 = Session["Theme2"].ToString();
Page.Theme = Theme2;
}

if (Session["Theme3"] != null)
{
string Theme3 = Session["Theme3"].ToString();
Page.Theme = Theme3;
}

if (Session["Theme4"] != null)
{
string Theme4 = Session["Theme4"].ToString();
Page.Theme = Theme4;
}

if (Session["Theme5"] != null)
{
string Theme5 = Session["Theme5"].ToString();
Page.Theme = Theme5;
}


if (Session["Theme6"] != null)
{
string Theme6 = Session["Theme6"].ToString();
Page.Theme = Theme6;
}

if (Session["Theme7"] != null)
{
string Theme7 = Session["Theme7"].ToString();
Page.Theme = Theme7;
}

if (Session["Theme8"] != null)
{
string Theme8 = Session["Theme8"].ToString();
Page.Theme = Theme8;
}

if (Session["Theme9"] != null)
{
string Theme9 = Session["Theme9"].ToString();
Page.Theme = Theme9;
}


if (Session["Theme10"] != null)
{
string Theme10 = Session["Theme10"].ToString();
Page.Theme = Theme10;
}

if (Session["Theme11"] != null)
{
string Theme11 = Session["Theme11"].ToString();
Page.Theme = Theme11;
}

if (Session["Theme12"] != null)
{
string Theme12 = Session["Theme12"].ToString();
Page.Theme = Theme12;
}

Hi,

Saving the entire css styles in DB is not a good Idea, Instead you can save the css name to the DB, and according to that name you can load the css dynamically when the user logged in.

 

Please accept if it helps you.

Kindest Regards

Sibeesh Venu

www.sibeeshpassion.com