I have my categories in database, and want something url rewriting/routing to make my url nicer and more SEO friendly. I have divided my categories into the following:
Cars > Select car > Car model >
how do I create url rewriting / routing in my categories? I use framework 4.0
I'm currently using URL Rewriting, but I recently stumbled upon this link on Rerouting, and it looks like it's quite simple yet powerful, and easier to implement than URL Rewriting, a "downside" probably is that configurations are not sitting on a web.config file but rather on the code itself, but I was wondering about the differences, and advantages of using one over the other. Having read some resources about routing, I can see the differences, and now I reformulate my question:
Is it worth it to move from URL Rewriting to Routing?
Are there any IIS-specific configurations that should be made?
Is it recommended to use it on a ASP.NET WebForms Application, or is it oriented to other kind of projects?
I am implementing URL rewriting and this is not a MVC app, I am using .Net 3.5 Framework here is my simple setup: 1. My Link Page I have a link on my index.aspx page
(notice SEO friendly URL, purpose of Routing) --> <asp:HyperLink ID="HyperLink1" NavigateUrl="~/Category/Engine" runat="server">Engine</asp:HyperLink>
2. Global.asax:
protected void Application_Start(object sender, EventArgs e)
{
RegisterRoutes();
}
private static void RegisterRoutes()
{
System.Web.Routing.RouteTable.Routes.Add("category", new System.Web.Routing.Route("Category/{name}", new CategoryRouteHandler("~/catalog.aspx")));.........
Is URL Routing is replacement for URL rewriting.? Or each of them have their own pros on cons?
View 7 RepliesI have a website for which I would like to have clean friendly URL. I am passing query string values in it. I am confused whether to use URL rewriting or URL routing. I have tried doing URL rewriting using URLrewriter.net but couldn't get through. Can any one help me out in deciding what to use and how to go about doing it.
View 5 RepliesI need to implement Routing or Url-Rewriting in my application. So, is there any utility like logging utility Elmah. I dont want to write much code, I need to configure and start playing.
View 2 RepliesI've been reading many articles and can't seem to get my ASP.NET 4 web forms project to do Routing/URL rewriting.
I have added the following reference to the ASP.NET project:
System.Web.Routing
It then added the following line to the web.config file:
<compilation debug="false" targetFramework="4.0"><assemblies><add assembly="System.Web.Routing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</assemblies></compilation>
In the global.asax file I want to add the routes, but it is not recognising RouteTable and RouteCollection keywords.
How do I get these to be recognised so that I can create the rules in the global.asax file?
In my website users can create thier own websites by making folder of thier choice like: [URL] Where the folders Pankaj and Adam are storing in database. I just want that when user after creting thier website just clicked or type the address of thier website as [URL] then if the folder with name Pankaj exists in database then the page will open otherwise it gives the http 404 page not found error. And while the address [URL] is opens then i donot want to physically create it on server. My requirement is that i want to open it by the concept of url rewriting/ Routing. Which one concept will be good for this. And can anyone provide some code with example that how can i achieve this easily.
View 2 RepliesI want to add unlimited categories and sub categories facility, But I couldn't solve it for last two days.
1. DB
CategID,CategName,parentid
Data:
CategID CategName Parent ID
1 Electronics 0 (where 0 means it is main category)
2 TV 1 (Self Join whith the categ id Electronics)
3 Panasonic 2
4 LG 2
5 Toys 0
6 Girls Toys 5
7 Boys Toys 5
8 Criket Related 7
9 Dolls 6
Here I want to display this data in Combo Box like
Electronic
>>TV
>>Panasonic
>>LG
Toys
>>GirlsToys
>>Dolls
>>Boys Toys
>>Criket Realted
I am trying to implement URL rewriting technique in my Web application.I have found some articles on net 2 rewrite URL. But i m not able to understand. tell me any API or DLL which will take care of all url rewriting techniques in my Web applications.
I have heard something abt UrlRewriter.ddl . But i have not used it yet. provide me the easiest way to do that. If any sample application is there then it will be better ti understand
how i would set up the routes table from a databse i.e can you do something like this i no i should load from a text file created from the save button of my cms page section but dont no how to do that.
rc.MapPageRoute (
"page",
"page/{Type}",
"~/cms.aspx");
// is their some way to load this into the global asx from a text file if so how?
"page/{Type}",
//URL with parameter
"~/cms.aspx");
//Web Form to handle
Is it possible to load routes from the database with ASP.NET ?
For each r as SomeRouteObject in RouteDataTable
routes.MapRoute( _
r.Name, _
r.RouteUri, _
r.RouteValues, _ //??
r.Constraints _ //??
)
Next
How should I store the routevalues / constraints? I understand that there are several 'default' routevalues like .Controller and .Action, however I also need entirely custom ones like .Id or .Page...
I have a bunch of html pages stored in a mssql database. Each row has:
ID
PageTitle
Page Html Content
ParentId
ParentId is there so i can create a hierarchical tree of pages.
Currently i am using this line of code in order to access the pages...
routes.MapPageRoute("front", "{PageTitle}", "~/front.aspx");
Which then causes a redirect to front.aspx so i can then use:
Page.RouteData.Values["PageTitle"].ToString()
In order to grab what i need so i can display the appropriate page in the browser.
However, can anyone suggest how i would amend 'routes.MapPageRoute' so it supports an infinate hierarchical tree like i have in my database. Essentially i want to be able to type a url like: http://localhost/PageOne/SubPageOfPageOne etc
I tried everything I could find, but still does not work on IIS routing.
View 2 RepliesI am using:
ASP.NET 3.5 SP1 with Web Forms Routing thru Global.asax (System.Web.Routing and RegisterRoutes)IIS 7
Everything is working fine in my local machine, but it gives the following error in my hosting environment:
Could not load file or assembly 'System.Web.Routing, Version=3.5.0.0, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
I did everything inside my web.config file mentioned in the following link:
[URL]
But I am still getting the above error.
What else am I supposed to do fix the error?
I have a Web application where i have added a reference to a RESTful WCF. I got the WCF url Routing to work in my webapplication by adding Inherits="RestService.Global" to the Web applications Global.asax.
<%@ Application Codebehind="Global.asax.cs" Inherits="RestService.Global" Language="C#" %>
But then i tried to create url Routing for the Web application and it does not work with the Inherits="RestService.Global" in the Global.asax. If i take it away it works fine. Is there a correct way to do this.
I'm trying to create my own CMS and I've gotten a little bit stuck at the stage of URL routing.
I want clean URLs without extensions and I'd like to be able to create and modify them in a web based interface without any messing around with IIS or actual files.
I've seen how to create a static route, but for that I need to go into my Global.asax file and manually add it.I would like to have all of these routes stored in a database so that I can easily modify them later.
Does anyone know how this can be achieved?
Just for extra information, I will be attempting to create a feature so that if a path exists, but is later changed, a 301 redirect is created to the new URL, is this also possible? (My first problem is the main issue, but thought I might ask this as well just in case it makes a difference)
How to handle asp.net mvc routing along with asp.net webform routing. I have merged my mvc app into my existing web application. In my web application i have implement routing as below:
routes.Add("View Product Details", new Route("Product/{City}/{Manufacturer}/{Name}/{ProductID}/{*ProductType}"));
Similarly i have implemented routing in mvc as below
routes.MapRoute("Product Details",
"Product/{City}/{Manufacturer}/{Name}/{ProductID}/{ProductType}",
new
{
controller = "Home",
action = "ProductDetails",
City= UrlParameter.Optional,
Manufacturer= UrlParameter.Optional,
Name= UrlParameter.Optional,
ProductID= UrlParameter.Optional,
ProductType= UrlParameter.Optional
});
How to handle both pages, as one is custom web form while other is asp.net mvc view?
I am having problems in getting product data when using different levels of categories. My knowledge of SQL is also very limited.
Here is what i have so far
TABLES
Categories
CategoryID (PK) int
CategoryName nvchar(max) allow null
ParentID int allow null
Data for this table
1,Soaps,null
2,Original Range,1
3,Premium Range,1
4,Speciality Range,1
5,Seasonal Collection,4
6,Selection,4
Products
ProductID (PK) int
ProductName nvarchar(max)
ProductDescription nvarchar(max) allow null
ProductPrice money
CategoryID int
Data for this table
1,Prod1,some text,0.25,6
2,Prod2,some text,0.25,6
I have some linq to sql in the page load event that populates a list view,
[Code]....
Now when the category passed in from the query string is 6 then the products with a category of are shown correctly but category 6 is a child category of 4 and 4 is a child of 1 so when i pass in 4 as the category i should still be retrieving the data for products 1 and 2.
I have a class
public class CountryListViewModel
{
public IEnumerable
Countries { get; set; }
}
public class CountryViewModel
{
public string CountryName { get; set; }
public string State { get; set; }
public IEnumerable<CityViewModel> Cities {
get; set; }
}
public class CityViewModel
{
public string CityName { get; set; }
public string CityLink { get; set; }
}
using linq to entity grouping by country and it works as designed. but I also have to group by state.
var query = from c in _db.MyTable
where c.IsActive && c.Country == country
group c by c.Country
into loc
select new CountryViewModel()
{
CountryName = loc.Key,
Cities = loc.Select(s => new CityViewModel() { CityName = s.City, CityLink = s.City }).Distinct()
};
I'm using Entity Framework.
I have 3 tables:
- Products (Primary key productId)
- Categories (Primary key categoryId)
- Product_to_categories (Table with two fields, CategoryId and ProductId)
One product can be assigned to multiple categories.
How should I download the products from specific category?
Now I retrieve them in that way:
int PageNum = 1;
int PageSize = 10;
int categoryId = 5;
var categoryModel = db.Categories.FirstOrDefault(c => c.CategoryId == categoryId);
var results = (from p in categoryModel.Products select p).Skip((PageNum - 1) * PageSize).Take(PageSize).ToList();
But when there is a lot of products in category my server crushed. I want only 10 products per page.
I have few monhts working with aspx, and now I'm developing a shopping cart website. For the employee to upload the products on the DB, every product needs to be linked to a category and sub category, and sub-sub category, and so on. Sometimes the sub-sub categories are up to 5. For example Electronics-TV-LCD-Samsung-40 inches.
First, What I would like to identify is if the SQL table has the apporpiate structure. I have 3 columns Id, Description, Parent_Id. Categories with Parent Id=0 is used for the top ones. Is this the best way to do it?
Then I want to use the ListBox control to select main Categories, and once it is selected, filled a second listbox with its childs and so on. Do I need to query SQL DB everytime the change event happens? I heard about linq but have not used yet.
The problem is that we have 5 different categories and we have to calculate the percentage of products sold in each category. Then we have to show that in sort of a chart. The interface of chart is shown here
http://img64.imageshack.us/img64/5397/52805880.gif although this chart has 14 boxes but I will be using 20 boxes in the final chart, the reason for that is that I want each box to represent 5% of sales. Now the question is suppose that the percentage for sales in each category is 34.4%, 12.6%, 23.2%, 22.6% and 7.2%. How do I convert these values to nearest 5 and then fill each box with that color. For example 34.4% means that almost 35% or 7 boxes will be colored with that color. The problem is that the sum of all of these must always be 20. I understand that this will not be very precise representation but this is the demand from the user.
This may be a fairly complex question but I'll try to make it as simple as possible.
I have 2 treeviews, the 1 has a single hierarchial structure like this:
Parent
-->LevelOne
---->LevelTwo
-------->LevelThree
------------->LevelFour
But the second treeview must populate defining sub-categories from the database onto the tree like this:
Parent
-->Sub-LevelOne
---->LevelOne
------->LevelTwo
------------LevelThree
-->Sub-LevelTwo
---->LevelOne
------->LevelTwo
------------LevelThree
My problem is after I've defined the second sub-level structures, I get duplicated sub-levels of data within the sub-level nodes as opposed to having the data distributed between the 2 sub-nodes with the appropriate corresponding data assigned to each level.
In my database, the 2 top sub-levels are identified by integer values of 1 and 2. So the first 2 sub-level nodes are created using a case statement which creates 2 separate sub-level nodes on the tree as I need. But I am having a problem for how I can get the next levels of data to distribute between the 2 separate sub-levels accordingly???
Its almost like I need a 2 more treeviews within a treeview to accomplish what I'm after but I don't know if this is even possible.
I am trying to create a search filter much like the one used on eBay that dynamically comes up with appropriate search categories based on the search results left. For example: [URL]
As you can see the search filters on the left are based upon the details displayed on the product results.
I need to try and implement something similar for an ASP.NET site, whereby I need to filter articles based on fields such as sales, companies, employee numbers etc. My database is quite normalised so I am able to separate all the data into their own tables.
