seo Question posted in
Some basic information to get you started with this can be found here.

Dynamically generating friendly URL and render the content from SQL db in unique page for all posts clicked in Asp.Net C# – SEO

As I am constructing a blog section in my website I would like to know how to render each of the blog post in unique page template or say view. I do not want to create aspx manually and then naming them with headings SEO.

Step 1 : I have created a table where it can totally store all the details, including image, content, heading and I am able to retrieve these values to bind it further in the repeater. Working fine

Step 2: However, Now next thing is,there is blog details page which will be displayed when clicked on any of the blogs, but will it bear the different URL as to match with the heading ?

Assume currently URL is www.xyz.com/blog/blogdeatils.aspx and if it is rendering a article which talks about wikipedia then I want my URL to be www.xyz.com/blog/how-wikipedia-works (no aspx extension)

Is this possible ? Thank you all

Tags:

2

Answers


  1. 0

    This has been called as “routing”. Add Global.asax to your project and next is just an example of your file:

    <%@ Application Language="C#" %>
<%@ Import Namespace="System.Web.Routing" %>


<script runat="server">

void Application_Start(object sender, EventArgs e) 
{
    // Code that runs on application startup
    RegisterRoutes(RouteTable.Routes);

}

void RegisterRoutes(RouteCollection routes)
{
    routes.MapPageRoute("Article", "blog/{name}", "~/BlogDetails.aspx");
}

void Application_End(object sender, EventArgs e) 
{
    //  Code that runs on application shutdown

}

void Application_Error(object sender, EventArgs e) 
{ 
    // Code that runs when an unhandled error occurs

}

void Session_Start(object sender, EventArgs e) 
{
    // Code that runs when a new session is started

}

void Session_End(object sender, EventArgs e) 
{
    // Code that runs when a session ends. 
    // Note: The Session_End event is raised only when the sessionstate mode
    // is set to InProc in the Web.config file. If session mode is set to StateServer 
    // or SQLServer, the event is not raised.

}

    And in your BlogDetails.aspx you may use next code to fetch the title of the article:

    string article_name = Page.RouteData.Values["name"] == null ? "No article" : Page.RouteData.Values["name"].ToString();

    And then use this for retrieving information from a database.

    Login or Signup to reply.
  2. 0

    Your Global.ascx file’s content:

    <%@ Application Language="C#" %>
<%@ Import Namespace="System.Web.Routing" %>


<script runat="server">

void Application_Start(object sender, EventArgs e) 
{
    // Code that runs on application startup
    RegisterRoutes(RouteTable.Routes);
}

void RegisterRoutes(RouteCollection routes)
{
    routes.MapPageRoute("Article", "blog/{name}", "~/BlogDetails.aspx");
    routes.MapPageRoute("Main Page", "Home", "~/Default.aspx");
}

void Application_End(object sender, EventArgs e) 
{
    //  Code that runs on application shutdown
}

void Application_Error(object sender, EventArgs e) 
{ 
    // Code that runs when an unhandled error occurs
}

void Session_Start(object sender, EventArgs e) 
{
    // Code that runs when a new session is started
}

void Session_End(object sender, EventArgs e) 
{
    // Code that runs when a session ends. 
    // Note: The Session_End event is raised only when the sessionstate mode
    // is set to InProc in the Web.config file. If session mode is set to StateServer 
    // or SQLServer, the event is not raised.
}

    Consume that you have some table Articles, which contains such columns as ID, Name, Image, Info. And you have Image control for an image and Label control for a detail information in your BindDetails.aspx. So your BindDetails.aspx.cs will be (excepting namespaces):

    protected void Page_Load(object sender, EventArgs e){
    if (Page.RouteData.Values["name"] == null)
        Response.Redirect("~/Home");
    else{
        string name = Page.RouteData.Values["name"].ToString();
        if (!IsPostBack)
            RetrieveArticleByItsName(name);
    }
}

protected void RetrieveArticleByItsName(string article){
    SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["YourConnectionName"].ConnectionString;
    SqlCommand cmd = new SqlCommand("select TOP 1 * from Articles where lower(name) = lower(@name)", con);
    cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = article;

    try{
        con.Open();
        SqlDataReader sdr = cmd.ExecuteReader();
        sdr.Read();
        imgImage.ImageUrl = "your_folder/" + sdr["image"].ToString();
        lblDetails.Text = sdr["info"].ToString();
    }
    catch(Exception ex){
        //work with exceptions
        Response.Write("<script language='javascript'>alert('" + ex.Message.ToString() + "');</script"); // Get alert with exception
    }
    finally{
        con.Close();
    }
}

    And let’s think, that you have two articles with names “How-to-clean-home” and “How-to-clean-a-car“. Now you may give everybody links like xyz.com/blog/How-to-clean-home and xyz.com/blog/How-to-clean-a-car and it will work.

    Hope it helps.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search