Define Column chart for GridChart or standalone mode. Default is IndColumnApp (Rainbow Color). For full color control, specify Type=Column in .dbChartParams.

dbQP Abbr: cch
Version: Gold

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string dbColumnChart { get; set; }
Visual Basic (Declaration)
Public Property dbColumnChart As String

Field Value

Mydb.dbColumnChart="Label | DataSet0 | DataSet1...| DataSet39"
KeywordDescription
LabelFieldNameOrNumber providing the Bar labels.
DataSetFieldNameOrNumber providing the bar dataset (0-39) values.

Remarks

Check HTML dump for defaults.

Overide the values with dbChartParams.

Defaul tis indColumnApp with indexed rainbow dataset colors.

specify Type=Column in .dbChartParams for user control.

dataset?Color to set color for each dataset set as well as the legend.

Examples

CopyVB.NET
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim Col As New Tornado.z
  With Col
    .dbQP = "U=25| D=nwind| S=13| PS=10| M=Gc"
    .dbSQL = "SELECT OrderID, sum(UnitPrice) as UnitPrice, sum(Quantity) as " & _
      "Qty from [Order details] Group by OrderId"
    .dbChartParams = "xAxisLabelAngle=45|yAxisTitle=My Y-Axis Title| xAxisTitle=" & _
      "My X-Axis Title| yAxisOptions=rotateTitle=true"
    .dbColumnChart = "Legend=t| Label=#0#| DataSet0=#1#| DataSet1=#2#| DataSet2=" & _
      "27,59,51,95,92,67,100,37,56,111"
    .dbTextHolder = "Title=Column Chart"
    .ASPdbNET()
  End With
End Sub
</script>

See Also