change page titile dynamicaly with the help of sql?

Question

Hiii i am working on e-commorce website. i wan't to change page title dynamically with the help of data base according to the product in asp.net. please give me some answer

Aditya Mishra · Answer

Hi apurva for change page title dynamicaly go to below link.. http://aspsnippets.com/Blue/Articles/Dynamically-add-meta-tags-in-ASPNet.aspx

Pankaj Kumar Choudhary · Answer

Hello @Apurava you can change page title at Page_Load() event . use this code protected void Page_Load(object sender, EventArgs e) { string str; str = "Put Your Query"; SqlCommand com = new SqlCommand(str, Con_Name); object obj = com.ExecuteScalar(); Page.Title = obj.ToString(); } if there is only one page title in database then this query is correct if database contain more than one page title then use SqlDataAdapter() instead of SqlCommand

Upendra Pratap Shahi · Answer

Hello @Apurva, Use below code protected void Page_Load(object sender, EventArgs e) { Page.Title = title(); } private string title() { SqlConnection con = new SqlConnection(cs); string cmdstr = "select * from title_test where id = 1"; SqlCommand cmd = new SqlCommand(cmdstr, con); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); con.Open(); da.Fill(dt); con.Close(); if (dt.Rows.Count > 0) { string title = dt.Rows[0]["title"].ToString(); } return title; } read this.. http://aspsnippets.com/Blue/Articles/Dynamically-add-meta-tags-in-ASPNet.aspx may be helpful for you. If helpful kindly mark as This is correct answer.

Manoj Bhoir · Answer

Hi Apurva, You can retrieve your page title from database and set it to page Title Property. See this code : protected void Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(Page.Title)) { Page.Title = GetPageTitle(); } } private string GetPageTitle() { // Code to retrieve Page title from database. }