change page titile dynamicaly with the help of sql?

Apurva Singh

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aditya Mishra11y ago
Accepted 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 Choudhary11y ago
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 Shahi11y ago
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 Bhoir11y ago

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