301 redirect from asp.net using database table

home / software / tips and tricks / 301 redirect from asp.net using database table

301 redirect from asp.net using database table

Category: ASP.Net
view more software Tips and Tricks

Updated: 02/20/2012 13:02 PM
Author: Shiju Mathews

Status: Resolved.

Duplicate urls are one of the most threatening issue for web masters regarding the search engine ranking. Also when moving the content to a different page, search engine will alarm for duplicate contents.

A single solution for all this issue is 301 redirect. But managing all this web pages is a tedious task. Recently I faced a similar issue and I decided to implement an easy solution using the database table. In my solution I am using the global.asax file to redirect the WebPages to the new location. Search engine will see 301 redirect status and crawl the new page.

Follow the following steps to implement the 301 redirection.

1: Create a database table to hold the old and the old and new web page address. Also since we need the enter web page address that is differ by upper case and lower case letters we need to create case sensitive column for [URLIn].

2. Insert all your new pages and old pages to the table

4.Create a stored procedure to check the redirect url. Also make sure that we are doing a case sensitive comparison

4. Update global.asax

void Application_BeginRequest(Object sender , EventArgs e)
{
string currentUrl = HttpContext.Current.Request.Url.ToString();
SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["strConnASP"]);
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@URLIn", SqlDbType.VarChar, 512);
sqlParameter[1] = new SqlParameter("@URLOut", SqlDbType.VarChar, 512);
sqlParameter[1].Direction = ParameterDirection.Output;
sqlParameter[0].Value = currentUrl;
sqlParameter[1].Value = DBNull.Value;
using (SqlCommand sqlCommand = new SqlCommand("[dbo].[NewURL]", myConnection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddRange(sqlParameter);
myConnection.Open();
sqlCommand.ExecuteNonQuery();
myConnection.Close();
}
if (sqlParameter[1].Value != DBNull.Value)
{
HttpContext.Current.Response.Status = "301 Moved Permanently";
HttpContext.Current.Response.AddHeader("Location", Convert.ToString(sqlParameter[1].Value)); }
}

5. Test the url.

Indian Resources by Category

Indian Grocery Stores

Indian Jewelry Stores

Indian Hindu Temple

alt="Add your business to our listing Free"

Software Resources

Tips and Tricks

Interview Questions for C#

Interview Questions for ASP.Net

Interview Questions for SQL Server