Create Static ASP.net Pages from entries in database?

cjtaylor · Feb 10, 2005

Hello.

Instead of having one page that is dynamically updated from the database, I was wondering if it is possible to create a static page from each entry in my database. How should I approach this?

Thanks
Chris Taylor

ca8msm · Feb 10, 2005

You could create a file using a streamwriter and save it as a static page - I can't see why you ever need to do this though!

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

link9 · Feb 10, 2005

This method is actually quite useful for Content Management websites.

It makes it easier to track your traffic when you have separate actual static files out there. It also is more friendly to search engines.

Personally, I have a .template file that I use as (guess what!) a template, which just defines the page in terms of user controls.

Code:

<%@ Page %>
<head>
...
</head>
<body>
  <form>
    <uc:header pageID= />
    <uc:menu pageID= />
    <uc:content pageID= />
    <uc:footer pageID= />
  </form>
</body>

Just as a for instance (yours will surely be much more complicated than that), then read it in using a streamreader, replace "pageID=" w/ "pageID=thePageID" (along with any other stuff, keywords, titles, etc... that you need), and then as ca8msm said, use a streamwriter to write it back out to the disk.

Most of the content (in my case) is still stored solely in the database, and pulled on demand, but you could use the same method to write out the whole page statically if you wished (It would be overkill for my purposes, but you may have your reasons).

good luck.

-paul

The answer to getting answered -- faq855-2992

ca8msm · Feb 11, 2005

It makes it easier to track your traffic when you have separate actual static files out there. It also is more friendly to search engines.

Good Point - hadn't really thought about it in terms of search engines/traffic.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

cappmgr · Feb 11, 2005

You could also explore storing XML and XSLT to create your pages.
Years back we stored static HTML in files and had CGI scripts in PERL reading the files and displaying the web pages.
Marty

cjtaylor · Feb 11, 2005

Thanks for all your input.

I am writing a link index program similar this one

http://www.klinksdemo.com/

and noticed that all their pages are actually static pages and search engines love static pages.

Thanks again
Chris

bassguy · Feb 11, 2005

You may want to look into SQL templates also....seems I remember something about SQL generating HTML pages filling them with data.

Bassguy

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Create Static ASP.net Pages from entries in database?

cjtaylor

Programmer

ca8msm

Programmer

link9

Programmer

ca8msm

Programmer

cappmgr

Programmer

cjtaylor

Programmer

bassguy

Programmer

Similar threads

Part and Inventory Search

Sponsor