How to dynamically add aspx pages to a website that read data from different tables in a MS sql database

Question

0.00/5 (No votes)

See more:

i am trying to develop a news website that have several categories like Politics, Technology, Announcement, Obituary, etc(Each category is a table in the sql server express database)... All these Categories are shown in a menu tab.When each tab clicked it will navigate to corresponding pages. Most of the pages have same structure (Skin or theme) . that is the working of the site. i am using visual studio 2010 and ms sql server 2008.

I don't want create pages for each categories. Is there is any possible way to create pages dynamically to call each tables in the sql server when clicking the menu.

By the way, have another need is there any way to create new category after hosting the site by just giving the name of the category, like category name == facebook, and the press create.

thanks in advance... :)

(One of my friend told me to use query string. something like ~/catagory/category?page=urpage)

Posted 4-Sep-13 21:12pm

veena nair

Updated 4-Sep-13 23:54pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nitij · Answer 1 · 2013-09-04T21:53:00

There are several ways in which you can achieve what you want:

# Have your page made up of different parts which will update asynchronously according to the selected choice of the users. You will need to implement a decent amount of javascript for this so use jQuery for cross browser reliability. Also your website is data driven so using a good javascript mvc framework would be a big win.
If you have time you can view one of these:
AngularJS
Knockout

# Use master and content pages, have a common content page and update its data based on the category selected.
See this to create content pages if you don't know already.
Link

# You can even create a separate aspx page to show the category data and use an iframe to display that page, but this is my least favourite because I have seen iframes causing many problems on mobile devices and you wouldn't like that.