Snakey Grid and Form

Many time it is desirable to display a simple column graph rather than utilizing a full blown graph package. In that case, just specify what type of column graph and the method to obtain the scale of the data, the numeric column will be replaced by a bar graph. Specify a 'rainbow' option will even make is more colorful.

Colgraph with Rainbow Bars

<!--T_Snake.aspx-->

<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
   Dim NA2 As New Tornado.Z()
   With NA2
      .dbQP = "U=11| D=AAMA2000.Mdb| Mode=ty=dh! ind=0| S=moto| gdf=0| Q=H_Dimension| fc=3| Gc=4| Ps=100| Ni=next,Prev,r+,r-,c+,c-| Th=tit=Snake Grid and Form"
      .ASPdbNET()
   End With
End Sub
</script>

In this example, we specified The field to process, size of bar, color, style and the method we have chosen to provide the minimum and maximum is via an SQL. Not a whole lot of work for a very colorful presentation.

This DB query retrieves 133 fields and 3244 records. Pretty long and wide to be displayed. The Row and Col +/- page control will extend the Master key grid and also 'snake' the Grid and Form details so it'll fit nicely on the screen. Normally you'll know what the field numbers are and set the dbFormCols accordingly at startup. This example starts at 3 and let you increase the 'snake' fold just to fell the effect. Grid Column is set to 4.