dotnetCHARTING Send comments on this topic.
DataEngine Class Members
See Also  Properties  Methods 
dotnetCHARTING Namespace : DataEngine Class


The following tables list the members exposed by DataEngine.

Public Constructors

 NameDescription
Public ConstructorDataEngine ConstructorOverloaded.  Initializes a new instance of the DataEngine class.  
Top

Public Properties

 NameDescription
Public PropertyChartObject Sets the Chart object.  
Public PropertyChartType Gets or sets the ChartType enumeration that sets the default DataFields for each type.  
Public PropertyCommandTimeout Gets or sets the wait time before terminating the attempt to execute a command and generating an error.  
Public PropertyConnectionString Gets or sets the string used to open a SQL Server, Access, or Excel database.  
Public PropertyCultureName Gets or sets the culture name used when element names are populated with values such as dates.  
Public PropertyData 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.  
Public PropertyDatabaseCultureName 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.  
Public PropertyDataFieldsGets or sets a value that specifies the 'database column' to 'element value' relationship.  
Public PropertyDataGrid Gets or sets the control object of a DataGrid or GridView control that will be populated with the charted data.  
Public PropertyDataGridCustomAttributes Adds element's custom attributes to the DataGrid control specified by the DataGrid property.  
Public PropertyDataGridFormatString Gets or sets the format string which determines number formatting in the datagrid.

 
Public PropertyDataGridSeriesHeader Gets or sets the header label of the DataGrid control specified by the DataGrid property.  
Public PropertyDataGridTranspose Gets or sets a value indicating whether the data with which the specified DataGrid control is populated will be transposed.  
Public PropertyDataProviderType Specifies a database type. Defaults to OleDb (Access database).  
Public PropertyDateGrouping Gets or sets the date grouping of data returned from your database.  
Public PropertyDateGroupingCalculation Gets or sets an enum which determines how values are grouped to create a single element value.  
Public PropertyDateGroupingSort Gets or sets a value indicating whether to maintain the sort order of the data as it is provided.  
Public PropertyDrillDownIntoSeries 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.  
Public PropertyEndDate Gets or sets the ending date used with SqlStatement to query filtered data from a database.  
Public PropertyErrorMessage Gets an error message which will be available if this DataEngine instance fails after a call to GetSeries().  
Public PropertyFormatString Gets or sets the format string used when element names are populated with values such as dates.  
Public PropertyLimit 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.  
Public PropertyLimitModeDetermine the type of limitation. Default is Top.  
Public PropertyLimitPrimarySeries 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.  
Public PropertyOtherElementLabel Gets or sets the label used for the element or series created when using Limit or SplitByLimit and setting ShowOther to true.  
Public PropertyParameterCollection Gets or sets a collection of Parameter objects used in conjunction with the StoredProcedure property.  
Public PropertyPopulateDateGroupingSubValues 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.  
Public PropertyShowOther 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.  
Public PropertySplitByLimitGets or sets the number of series created using SplitBy.  
Public PropertySqlStatement The SQL statement used to obtain the charting data.  
Public PropertyStartDate Gets or sets the starting date used with SqlStatement to query filtered data from a database.  
Public PropertyStartDateOfYear Gets or sets a DateTime object to determine the start month of the year when DateGrouping is used.  
Public PropertyStartDayOfWeek Gets or sets a DayOfWeek enumeration that determines the day which will be used as the starting day of the week for the dategrouping functionality.  
Public PropertyStoredProcedure 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.  
Public PropertySubValueDateGrouping Gets or sets the date grouping for the element subvalue.  
Top

Public Methods

 NameDescription
Public MethodAddParameter Adds a stored procedure when to use in conjunction with StoredProcedure.  
Public Methodstatic (Shared in Visual Basic)ConvertCSVtoDataTable  
Public MethodGetFinancialSeries See GetSeries.  
Public Methodstatic (Shared in Visual Basic)GetSeriesOverloaded.  Gets a SeriesCollection based on a data object and mapped DataFields.  
Top

See Also

© 2018 All Rights Reserved.