AverageCoder.Net - Programming - Software - Techie Stuffs

SimpleGridBuilder (ASP class definition)

Posted by Daniel - 2,232 Views

Can we display data from a database on a web page with a minimal work? well, there will be no pure instant things to achieve that, but at least we can minimize the steps when we do the job.

I created Simple Grid Builder - a simple ASP class definition - to make it easier for me when I need to display data from the database in a grid layout. The purpose is to assemble a reusable component by providing some flexible settings on it, so the component can be deployed in more than one application.

SimpleGridBuilder contains one sub procedure only, it uses all of the available settings value to display the grid. Below is the list of the available properties.

Property	Description
DataSource	Connection string to the database
RecordSource	SQL statement to retrieve the data
BorderColor	Grid border color
CellSpacing	Spacing between each grid?s cell
CellPadding	Padding between each grid?s cell
ColWidth	Column width
HeaderBackColor	Header?s background color
HeaderFontFace	Header?s font face
HeaderFontSize	Header?s font size
HeaderFontColor	Header?s font color
DataBackColor	The background color for the data section
DataFontFace	The font face for the data section
DataFontSize	The font size for the data section
DataFontColor	The font color for the data section

There is a sample included in this article. Just download it then follow the instruction provided in the sample in order to run it on your machine.

The SimpleGridBuilder Class code along with the example of use can be downloaded here (9 KB)