Tornado API Library - V12.30.08

z.dbColumnChart Property

Define Column chart for GridChart or standalone mode.

Product Version

Gold
[VisualBasic]
PublicPropertydbColumnChartAsString
[C#]
publicstringdbColumnChart{set;}

Property Value

Mydb.dbColumnChart="Label | DataSet0 | DataSet1...| DataSet39"

KeywordDescription
LabelFieldNameOrNumber providing the Bar labels.
DataSetFieldNameOrNumber providing the bar dataset (0-39) values.

QuickProp Keyword Abbreviation

cch

Remarks

Check HTML dump for defaults.

Overide the values with dbChartParams.

Example

<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

z Class | Tornado Namespace | dbPieChart | dbBarChart | dbLineChart | dbAreaChart | dbBubbleChart | Special Topic - Charting