NCS Logo - Click for home page Northstar Developer Center
Platforms
All Platforms
.NET Framework (1.x - 4.x)
Active Server Pages
ASP.NET
C#
SQL Server
VB.NET
Visual Basic

Keywords
.NET Data Types
.NET E-mail
.NET Events
.NET Functions
.NET Object Programming
.NET System.Configuration
.NET System.Diagnostics
.NET System.IO
.NET System.Net
.NET System.Net.Sockets
Active Data Objects
ASP Architecture
ASP Black Belt
ASP Built-in Functions
ASP Built-in Objects
ASP Debugging
ASP Performance
ASP Security
ASP Syntax
ASP.NET Authentication
ASP.NET Controls
ASP.NET Data Access
ASP.NET Features
ASP.NET Master Pages
ASP.NET Page Events
ASP.NET Security
ASP.NET ViewState
Atom
Certifications
COM, DCOM, COM+
Data Access
E-Mail
Errors
Exporting Data
HTML Tips
IIS
Object-Oriented Programming
RSS
SQL
Uncategorized ASP Tips
VB API Programming
VB Forms
VB Syntax
XML

Book Support
Visual Basic 6 Bible
ASP Bible
ASP Weekend Crash Course
ASP.NET At Work
Creating Web Services

Using Style Sheets and SQL for Output

Written by Eric Smith, Northstar Computer Systems LLC

As some of the earlier tips have said, it's much quicker to manipulate strings within either SQL Server or compiled components. However, if you are generating HTML from one of these sources, you would have to embed colors, fonts, and such in the HTML you're generating. If you change the look of your page, you'll have to go back to your compiled code or your stored procedures and change all the code.

An alternative I personally use is to generate style sheet tags from the compiled components and stored procedures. This allows me to change the colors, fonts, and other attributes outside of the code. In addition, I can use the same code for multiple sites since the style sheet can be redefined for each web site I used it with.

Keywords: [ Uncategorized ASP Tips ]

Publication Date: 7/1/2000