DataEngine Class Members
The following tables list the members exposed by DataEngine.
Public Constructors
| Name | Description | |
|---|---|---|
 | DataEngine Constructor | Overloaded. |
Public Properties
| Name | Description | |
|---|---|---|
 | ChartObject | Sets the Chart object. |
| ChartType | Gets or sets the ChartType enumeration that sets the default DataFields for each type. |
| CommandTimeout | Gets or sets the wait time before terminating the attempt to execute a command and generating an error. |
| ConnectionString | Gets or sets the string used to open a SQL Server, Access, or Excel database. |
| CultureName | Gets or sets the culture name used when element names are populated with values such as dates. |
| Data | Gets or sets a DataTable, DataSet, DataView, XML file name, Xml string or an object that implement IEnumerable, ArrayList or HashTable used to generate a SeriesCollection. |
| DatabaseCultureName | Gets or sets the culture name used when StartDate and EndDate insert to the sql statement. This property only necessary to set if the web server and database server having different culture setting. |
| DataFields | Gets or sets a value that specifies the 'database column' to 'element value' relationship. |
| DataGrid | Gets or sets the control object of a DataGrid or GridView control that will be populated with the charted data. |
| DataGridCustomAttributes | Adds element's custom attributes to the DataGrid control specified by the DataGrid property. |
| DataGridFormatString | Gets or sets the format string which determines number formatting in the datagrid. |
| DataGridSeriesHeader | Gets or sets the header label of the DataGrid control specified by the DataGrid property. |
| DataGridTranspose | Gets or sets a value indicating whether the data with which the specified DataGrid control is populated will be transposed. |
| DataProviderType | Specifies a database type. Defaults to Sqlite database. |
| DateGrouping | Gets or sets the date grouping of data returned from your database. |
| DateGroupingCalculation | Gets or sets an enum which determines how values are grouped to create a single element value. |
| DateGroupingSort | Gets or sets a value indicating whether to maintain the sort order of the data as it is provided. |
| DrillDownIntoSeries | When using automated drill down in conjunction with date grouping and multiple series, this property determines if drill down will occur into a single series or multiple series. |
| EndDate | Gets or sets the ending date used with SqlStatement to query filtered data from a database. |
| ErrorMessage | Gets an error message which will be available if this DataEngine instance fails after a call to GetSeries(). |
| FormatString | Gets or sets the format string used when element names are populated with values such as dates. |
| Limit | Gets or sets the limit number of elements returned for each series when data is generated. Gets or sets the limit number of elements returned for each series when data is generated. This property determines the number of elements to include in the limited return. The limit string can be a number "3" or "2x3". In the second format, the first number determines the group position and the second number is the limit. By setting "2x3" with top limit mode, it only return the second "3" maximum elements. |
| LimitMode | Determine the type of limitation. Default is Top. |
| LimitPrimarySeries | In a multiple series chart, this property controls the primary series used for the Limit operation. Other series' elements will be matched with the primary series elements and that order will be maintained regardless of the values of the other series. For example, if you limit to the top 5 values and set the LimitPrimarySeries to the sales series other series such as dollar amount or quantity would not affect which elements were ultimately selected for the chart. |
| OtherElementLabel | Gets or sets the label used for the element or series created when using Limit or SplitByLimit and setting ShowOther to true. |
| ParameterCollection | Gets or sets a collection of Parameter objects used in conjunction with the StoredProcedure property. |
| PopulateDateGroupingSubValues | When using date grouping the main value in the element is derived from the actual values in the database or data provided to .netCHARTING. This property controls whether these subvalues used in the calculation to determine the element value are added to SubValues or not. By default, such values are not added to the element subvalues. |
| ShowOther | Gets or sets a value that indicates whether the additional series not shown due to the use of SplitByLimit, or elements not shown due to the use of Limit, are aggregated into a single series or element. |
| SplitByLimit | Gets or sets the number of series created using SplitBy. |
| SqlStatement | The SQL statement used to obtain the charting data. |
| StartDate | Gets or sets the starting date used with SqlStatement to query filtered data from a database. |
| StartDateOfYear | Gets or sets a DateTime object to determine the start month of the year when DateGrouping is used. |
| StartDayOfWeek | Gets or sets a System.DayOfWeek enumeration that determines the day which will be used as the starting day of the week for the dategrouping functionality. |
| StoredProcedure | This property accepts the name of a stored procedure to be used in place of the SqlStatement property in order to obtain data for the chart. |
| SubValueDateGrouping | Gets or sets the date grouping for the element subvalue. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddParameter | Adds a stored procedure when to use in conjunction with StoredProcedure. |
 | ConvertCSVtoDataTable | |
| ConvertExcelToDataTable | |
| GetFinancialSeries | See GetSeries(Object,String). |
| GetSeries | Overloaded. Gets a SeriesCollection based on a data object and mapped DataFields. |
See Also