data grid control

Advanced Data Grid Control

[ Data Grid Home ] [ Documentation ] [ Examples & Demos ] [ Buy Now ]

Advanced Data Grid Control

Full Parameter Reference

advanced data grid control

Whichever method ( file, html code, server process etc.) you choose to supply the data grid with the configuration options, the various parameters all follow the same format of [Parameter Name] , [Parameter Value]. Below you will find each option detailed with examples for supplying by file and html code.

Please Note : Parameters Names are case sensitive. ( i.e.. axis is not the same as Axis ).

    1. Grid Switches
    2. General Characteristics
    3. Data Format
    4. Row Number Properties
    5. Border Properties
    6. Title Properties
    7. Cell Properties
    8. Column Definitions
    9. Multi Language Character Set

GridSwitches ( Boolean flags )

Parameter Description Example
titlearea Specifies whether a Title area is to be drawn

Range of Values : true or false
File Example :
titlearea: true


Html Code Example :
<PARAM name="titlearea" value="true">
rownumbers Specifies whether rows should be numbered

Range of Values : true or false
File Example :
rownumbers: true

Html Code Example :
<PARAM name="
rownumbers" value="true">
cellgrid Specifies whether cells should be outlined

Range of Values : true or false
File Example :
cellgrid: true

Html Code Example :
<PARAM name="
cellgrid" value="true">
transcells If a background image is used then you may wish to make the cells transparent.

Range of Values : true or false
File Example :
transcells: true

Html Code Example :
<PARAM name="
transcells" value="true">
displaytotals Specifies whether numeric & currency columns should have a total displayed

Range of Values : true or false
File Example :
displaytotals : true

Html Code Example :
<PARAM name="
displaytotals" value="true">
columnheadings Specifies whether column headings should be drawn

Range of Values : true or false
File Example :
columnheadings: outline

Html Code Example :
<PARAM name="
columnheadings" value="true">

 

General Characteristics

Parameter Description Example
bgcolor Specifies the Background Color

Range of Values : Color Definition
click here for defining colors.
File Example :
bgcolor: white


Html Code Example :
<PARAM name="bgcolor" value="#FFFFFF">
bgimage Specifies a background image for the cell area

Range of Values : URL to image file
File Example :
bgimage: cellbg.gif

Html Code Example :
<PARAM name="
bgimage" value="cellbg.gif">
scrollbarbgcolor Specifies the background color for the scroll bars

Range of Values : Color Definition
click here for defining colors.
File Example :
scrollbarbgcolor: blue

Html Code Example :
<PARAM name="
scrollbarbgcolor" value="#0000FF">
dateformat Specifies the Date Format for interpreting any dates within the data

Range of Values : Date Format
click here for Date Definitions
File Example :
dateformat: dd MMMM yyyy

Html Code Example :
<PARAM name="dateformat
" value="MM/dd/yyyy">
thousandseparator Specifies the character to be used as a thousand separator when displaying numerical values

Range of Values : String
or "none" to specifiy no character
or "space" to specify a space character
File Example :
thousandseparator: ,

Html Code Example :
<PARAM name="thousandseparator
" value="none">

 

Data Format

Parameter Description Example
datafiletype Specifies the format of the data, ie. Fixed Width or Character separated.

Range of Values : 0 - Character Separated or 1 - Fixed Width
File Example :
datafiletype: 0


Html Code Example :
<PARAM name="datafiletype" value="0">
dataseperator If character separated then specifies the character separator

Range of Values : Any Alpha Numeric Character
File Example :
dataseperator: #

Html Code Example :
<PARAM name="
dataseperator" value=",">
fixedwidths If fixed width then specifies the width(in characters) of each column.

Range of Values : Integers separated by a | character.
File Example :
fixedwidths: 20|10|25|15

Html Code Example :
<PARAM name="
fixedwidths" value="15|30|30">

 

Row Properties

Parameter Description Example
rownumbgcolor Background color of row numbers

Range of Values : Color Definition
click here for defining colors.
File Example :
rownumbgcolor: light grey


Html Code Example :
<PARAM name="rownumbgcolor" value="#BBBBBB">
rownumtxtcolor Text color of row numbers

Range of Values : Color Definition
click here for defining colors.
File Example :
rownumtxtcolor: black

Html Code Example :
<PARAM name="
rownumtxtcolor" value="#000000">

 

Border Properties

Parameter Description Example
borderwidth Specifies the width of the border

Range of Values : Integer Value. If no border is required set this value to 0.
File Example :
borderwidth: 1


Html Code Example :
<PARAM name="borderwidth" value="3">
bordercolor Specifies the base color of the border.

Range of Values : Color Definition
click here for defining colors.
File Example :
bordercolor: #999999

Html Code Example :
<PARAM name="
bordercolor" value="grey">
borderstyle Specifies whether the border should be Plain, Raised or Sunken.

Range of Values : 0 - Plain, 1 - Raised, 2 - Sunken
File Example :
borderstyle: 1

Html Code Example :
<PARAM name="
borderstyle" value="0">

 

Title Properties

Parameter Description Example
titletext Specifies the Title Text

Range of Values : Text
File Example :
titletext: Data Grid Title


Html Code Example :
<PARAM name="titletext" value="Data Grid Title">
titlefont Specifies the Title Font

Range of Values : Font Definition
click here for defining fonts
File Example :
titlefont: Arial,B,16

Html Code Example :
<PARAM name="
titlefont" value="Arial,BI,14">
titlecolor Specifies the text color

Range of Values : Color Definition
click here for defining colors.
File Example :
titlecolor: blue

Html Code Example :
<PARAM name="
titlecolor" value="#0000FF">
titlealign

Specifies the text alignment


Range of Values : Left, Right or Center

File Example :
textalign: right

Html Code Example :
<PARAM name="textalign
" value="center">
titlebgcolor Specifies the title area background color

Range of Values : Color Definition
click here for defining colors.
File Example :
titlebgcolor: white

Html Code Example :
<PARAM name="
titlebgcolor" value="#FFFFFF">
titleimage

Specifies the URL of an Image file


Range of Values : Image file URL

File Example :
titleimage: title.gif

Html Code Example :
<PARAM name="
titleimage" value="title.gif">


Cell Properties

Parameter Description Example
cellgridline Specifies the grid line style

Range of Values : 1- Solid, 2- dotted, 3- dashed(short), 3- dashed(long)
File Example :
cellgridline: 1


Html Code Example :
<PARAM name="cellgridline" value="2">
cellgridcolor Specifies the grid line color

Range of Values : Color Definition
click here for defining colors.
File Example :
cellgridcolor: 175,175,175

Html Code Example :
<PARAM name="cellgridcolor
" value="light grey">
cellfont Specifies the cell text font

Range of Values : Font Definition
click here for defining fonts.
File Example :
cellfont: Arial,N,12

Html Code Example :
<PARAM name="
cellfont" value="Arial,N,10">
celltextcolor

Specifies the cell text color


Range of Values : Color Definition
click here for defining colors.

File Example :
celltextcolor: black

Html Code Example :
<PARAM name="celltextcolor
" value="#000000">
cellbgcolor Specifies the cell area background color

Range of Values : Color Definition
click here for defining colors.
File Example :
cellbgcolor: white

Html Code Example :
<PARAM name="
cellbgcolor" value="#FFFFFF">
cell_mo_textcolor

Specifies the text color upon Mouseover for cells which have a URL Link attached


Range of Values : Color Definition
click here for defining colors.

File Example :
cell_mo_textcolor: white

Html Code Example :
<PARAM name="
cell_mo_textcolor" value="white">
cell_mo_bgcolor

Specifies the cell background color upon Mouseover for cells which have a URL Link attached


Range of Values : Color Definition
click here for defining colors.

File Example :
cell_mo_bgcolor: black

Html Code Example :
<PARAM name="
cell_mo_bgcolor" value="black">


Column Definitions

For each column in the data grid, 12 characteristics can be defined,

Column Heading Text
Data Type
Background Color
Text Color
Width (in pixels)
Alignment
Default URL
Default Target Frame
Currency Symbol
Number of decimal places to display
Image
Tool Tip text

These are supplied via the "columnN" parameter (where N is an integer ranging from 1 to the total number of columns). Each item above is separated by a | character.

For the Data Type Item the following are supported,

  • 0 - Text ( default )
  • 1 - Numeric
  • 2 - Date
  • 3 - Currency

Alignment - can be one of "left", "right" or "center"

Currency Symbol - If the Data Type is set to currency then all cells in this column will have this character placed in front. (eg. "$").

Number of decimal places to display - For Numeric or Currency types the data is held in the format and precision is which it is supplied, but using this element you can specify only to display a certain number of decimal places. e.g. for currency types you may wish to only display to 2 decimal places.

For example if we have 4 columns of data,

File Example :
column1: Product|0|white|black|150|left| | | |0| |Product Titles
column2: Standard|3|164,164,186|40,40,70|75|right| | |$ |2| |Standard License Price
column3: Professional|3|164,164,186|40,40,70|100|right| | |$ |2| |Professional License Price
column4: Launch Date|2|164,164,186|40,40,70|125|center| | | |0| |Latest Release Launch Date

Html Code Example :
<param name="column1" value="Product|0|164,164,186|40,40,70|150|left| | | |0| |Product Titles">
<param name="column2" value="Standard|3|164,164,186|40,40,70|75|right| | |$ |2| |Standard License Price">
<param name="column3" value="Professional|3|164,164,186|40,40,70|100|right| | |$ |2| |Professional License Price">
<param name="column4" value="Launch Date|2|164,164,186|40,40,70|125|center| | | |0| |Latest Release Launch Date">


 

Multi Language Character Sets

If your data incorporates characters which are not included in the Western Alphabet (eg. Japanese or Eastern European characters) then the data grid provides the ability for displaying such character sets.

To change the character set you will need to add the following parameter between the <applet> and </applet> tags,

<param name="charset" value="SJIS">

Please Note: The "charset" parameter will only work where Data is read from a plain text file or server side process (ie. not HTML Parameters).

 

For further information on specifying character sets please click here.


« back to Getting Started
[ Data Grid Home ] [ Documentation ] [ Examples & Demos ] [ Buy Now ]

Getting Started

Documentation

Examples