dotnetCHARTING Send comments on this topic.
SqlStatement Property
See Also  Example
dotnetCHARTING Namespace > DataEngine Class : SqlStatement Property


The SQL statement used to obtain the charting data.

Syntax

Visual Basic (Declaration) 
Public Property SqlStatement As String
Visual Basic (Usage)Copy Code
Dim instance As DataEngine
Dim value As String
 
instance.SqlStatement = value
 
value = instance.SqlStatement
C# 
public string SqlStatement {get; set;}

Example

C#Copy Code
de.Series.SqlStatement = "SELECT OrderDate,Total FROM Orders";

//If you are doing a SplitBy you would need another field to correspond to your SplitBy value i.e.
de.Series.SqlStatement = "SELECT OrderDate,Total,Customer FROM Orders";
    
Visual BasicCopy Code
de.Series.SqlStatement = "SELECT OrderDate,Total FROM Orders"

'If you are doing a SplitBy you would need another field To correspond To your SplitBy value i.e.
de.Series.SqlStatement = "SELECT OrderDate,Total,Customer FROM Orders"

Example

Remarks

The first column returned is used for the X values, and the second for the Y values. The first also has special handling if dates are returned as the DateGrouping property can be used for intelligent date handling and grouping. The third column is optional and is used only for SplitBy. When a third column is set it is used automatically to create a unique series based on each unique value in this column.

NOTE: All date values in your SQL statements should be wrapped with the pound symbol: #10/25/2002#, regardless if Access or SQL server is used. Also the #StartDate# and #EndDate# tokens can be used in which case the dates set for these properties will be set in place of the tokens before the SqlStatement is executed.

See Getting Started > Tutorials > Queries for more info.

See Also

© 2018 All Rights Reserved.