Visual Basic (Declaration) | |
---|---|
Public Property SqlStatement As String |
Visual Basic (Usage) | Copy Code |
---|---|
|
C# | |
---|---|
public string SqlStatement {get; set;} |
C# | Copy Code |
---|---|
series.Series.SqlStatement = "SELECT OrderDate,Total FROM Orders"; |
Visual Basic | Copy Code |
---|---|
series.Series.SqlStatement = "SELECT OrderDate,Total FROM Orders" |
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.
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.