See Also

DataEngine Class  | dotnetCHARTING Namespace

See Also dotnetCHARTING Send comments on this topic.

DataEngine Class Members

DataEngine overview

Public Constructors

Public Constructor DataEngine Constructor Overloaded.  

Public Properties

Public Property ChartObject Sets the Chart object.
Public Property ChartType Gets or sets the ChartType enumeration that sets the default DataFields for each type.
Public Property CommandTimeout Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
Public Property ConnectionString Gets or sets the string used to open a SQL Server, Access, or Excel database.
Public Property CultureName Gets or sets the culture name used when element names are populated with values such as dates.
Public Property Data Gets or sets a DataTable, DataSet, DataView, OleDbDataReader, SqlDataReader, IDataReader, XML file name, or an object that implement IEnumerable, ArrayList or HashTable used to generate a SeriesCollection.
Public Property 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.
Public Property DataFields Gets or sets a value that specifies the 'database column' to 'element value' relationship.
Public Property DateGrouping Gets or sets the date grouping of data returned from your database.
Public Property DateGroupingCalculation Gets or sets an enum which determines how values are grouped to create a single element value.
Public Property DateGroupingSort Gets or sets a value indicating whether to maintain the sort order of the data as it is provided.
Public Property 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.
Public Property EndDate Gets or sets the ending date used with SqlStatement to query filtered data from a database.
Public Property ErrorMessage Gets an error message which will be available if this DataEngine instance fails after a call to GetSeries().
Public Property FormatString Gets or sets the format string used when element names are populated with values such as dates.
Public Property 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.
Public Property LimitMode Determine the type of limitation. Default is Top.
Public Property 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.
Public Property OtherElementLabel Gets or sets the label used for the element or series created when using Limit or SplitByLimit and setting ShowOther to true.
Public Property ParameterCollection Gets or sets a collection of Parameter objects used in conjunction with the StoredProcedure property.
Public 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.
Public Property 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.
Public Property SplitByLimit Gets or sets the number of series created using SplitBy.
Public Property SqlStatement The SQL statement used to obtain the charting data.
Public Property StartDate Gets or sets the starting date used with SqlStatement to query filtered data from a database.
Public Property StartDateOfYear Gets or sets a DateTime object to determine the start month of the year when DateGrouping is used.
Public Property StartDayOfWeek 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 Property 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.

Public Methods

Public Method AddParameter Adds a stored procedure when to use in conjunction with StoredProcedure.
Public Method GetFinancialSeries See GetSeries.
Public Method GetSeries Overloaded.  

See Also

DataEngine Class  | dotnetCHARTING Namespace

 

 


2002 - 2005 Webavail Productions Inc. & Corporate Web Solutions Ltd.. All Rights Reserved.