Define Column chart for GridChart or standalone mode.
Mydb.dbColumnChart="Label | DataSet0 | DataSet1...| DataSet39"
| Keyword | Description |
|---|---|
| Label | FieldNameOrNumber providing the Bar labels. |
| DataSet | FieldNameOrNumber providing the bar dataset (0-39) values. |
Overide the values with dbChartParams.
<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>
z Class | Tornado Namespace | dbPieChart | dbBarChart | dbLineChart | dbAreaChart | dbBubbleChart | Special Topic - Charting