save and retrieve theme in database

Question

how do i save personalized theme that user choose to database and retrieve it back when user login to their page.. please help..

Hazel Mahmud · Answer

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; }

Sibeesh Venu · Answer

Load that href part dynamically according to the value you take from database .

Sibeesh Venu · Answer

You can do something like this $('head').append(' ');

Hazel Mahmud · Answer

is there any site that i can make as reference..TQ

Sibeesh Venu · Answer

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