Define DateLine chart for GridChart or standalone mode.

dbQP Abbr: dlch
Version: Gold

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

Syntax

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

Field Value

Mydb.dbDateLineChart = "InputDateFormat| AxisDateFormat| Name | Date0| Value0|.. Date39| Value39"
KeywordDescription
NameName of Line.
LegendTrue|false(Def) - Display Legends.
InputDateFormatDate format of input dates like MM-dd-yyyy; yyyy-MM-dd.
AxisDateFormatX Data Axis format like yyyy; MM-yyyy.
NameDataSet Name.
DateX-axis Date.
ValueY-axis value.

Remarks

Check HTML dump for defaults.

Overide the values with dbChartParams.

Examples

This example creates a csv file, save to scratch directory and then open it as csv datasource with 3 columns - F1, F2 and F3. F1 is the x-axis and F2, F3 are the two datasets. The dbLineChart will plot the two lines with default settings. A third line is created manually in dbChartParams with it's own settings.
CopyVB.NET
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim CSV As String = "F2,F3" & vbCrLf & "1/1/1919,176" & vbCrLf & _
    "2/1/1929,56" & vbCrLf & "3/1/1929,50" & vbCrLf & "10/2/1930,200" & _
    vbCrLf & "6/1/1935,76" & vbCrLf & "7/1/1940,26"
  Dim util As New Tornado.Util
  util.WriteFile("c:\inetpub\wwwroot\tornado\scratch\TestDateLine.Csv", CSV)
  Dim Dl As New Tornado.z
  With Dl
    .dbQP = "U=5| S=plain| PS=-1| Ni=none| M=Gc| Q=Select * From TestDateLine.Csv| Dt=TEXT| Pv=OLEDB"
    .dbDSN = "/tornado/scratch"
    .dbChartParams = "TitleString=3 Date Lines| dataset1image=./_greenball.gif" & _
      "|yAxisTitle=My Y-Axis Title| xAxisTitle=My X-Axis Title| yAxisOptions=rotateTitle=true & _
    .dbDateLineChart = "legend=t| inputDateFormat=MM/dd/yyyy| Name0=DB Line| Date0=#0#| " & _
      "Value0=#1#|Name1=My Line| Date1=1/1/1955,2/1/1981,3/1/1987| Value1=50,60,70"
    .dbTextHolder = "Title=DateLine Chart"
    .ASPdbNET()
  End With
End Sub
</script>

See Also