The DataCommandQuery type exposes the following members.
Back to Top
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | DataCommandQuery | Initializes a new instance of the DataCommandQuery class |
| DataCommandQuery(DataLinkTypes) | Initializes a new instance of the DataCommandQuery class |
| DataCommandQuery(DataSourceTypes, String) | Initializes a new instance of the DataCommandQuery class |
Methods
| Name | Description | |
|---|---|---|
| AddBatch | (Inherited from EngineDataClassBase.) |
| AddNew | (Inherited from EngineDataClassBase.) |
| AddNewRow | (Inherited from EngineDataClassBase.) |
| AddNewRow(DataRow) | (Inherited from EngineDataClassBase.) |
| AddNewTableColumn | (Inherited from EngineDataClassBase.) |
| AddNow | (Inherited from EngineDataClassBase.) |
| ApplyDataFilter |
Applies a Select Fitler Expression to the Result Data.
|
| ApplyDataFilters | |
| ApplySelectFilter |
Applies a Select Fitler Expression to the Result Data.
|
| BuildDRSReport |
Builds the DRS HTML Report Content.
|
| CancelChanges | (Inherited from EngineDataClassBase.) |
| CancelExecute |
Cancel's Execution.
(Overrides EngineDataClassBaseCancelExecute .) |
| Check |
Checks the Data Command Query against the Data Source without returning any Result Data.
|
| Clear |
Clears the Result Data and Execution Status
|
| ClearConnectionString | (Inherited from DataConnection.) |
| ClearData | (Inherited from EngineDataClassBase.) |
| ClearExecute |
Clears the Execution Status.
|
| ClearFilters |
Clears the Data Command Query Data Filters.
|
| ClearResult |
Clears the Result Data.
|
| ClearResultStrings |
Clears the Result Data Strings.
|
| ClearSelect | (Inherited from EngineDataClassBase.) |
| Clone | (Inherited from EngineClassBase.) |
| CloseData | (Inherited from EngineDataClassBase.) |
| CloseFile | (Inherited from EngineDataClassBase.) |
| CloseXSD | (Inherited from EngineDataClassBase.) |
| Connect | (Inherited from EngineDataClassBase.) |
| CopyObject | (Inherited from EngineClassBase.) |
| CopyProperties | (Inherited from EngineDataClassBase.) |
| CopyProperties(EngineDataClassBase) | (Inherited from EngineDataClassBase.) |
| CopyProperties(Boolean) | (Inherited from EngineClassBase.) |
| CopyProperties(EngineClassBase, Boolean) | (Inherited from EngineClassBase.) |
| CopyProperties``2(UMP, UMP) | (Inherited from EngineClassBase.) |
 | CreateDataColumns | (Inherited from EngineDataClassBase.) |
| CreateSchema | (Inherited from EngineDataClassBase.) |
| DataChanged | (Inherited from EngineDataClassBase.) |
| DeepClone | (Inherited from EngineClassBase.) |
| DeepCopy | (Inherited from EngineClassBase.) |
| DELETE | (Inherited from EngineDataClassBase.) |
| DELETE(Int32) | (Inherited from EngineDataClassBase.) |
| DELETE(Guid) | (Inherited from EngineDataClassBase.) |
| DELETE(String, Int32 ) | (Inherited from EngineDataClassBase.) |
| DeleteAll | (Inherited from EngineDataClassBase.) |
| DeleteByDataFolder(Guid) |
Function Deletes all Data Command Queries from the matching Data Folder GUID.
|
| DeleteByDataFolder(String) |
Function Deletes all Data Command Queries from the matching Data Folder GUID.
|
| Deserialize(Uri) | (Inherited from EngineDataClassBase.) |
| Deserialize(String) | (Inherited from EngineClassBase.) |
| Deserialize(XmlDocument) | (Inherited from EngineClassBase.) |
| Deserialize(TextReader) | (Inherited from EngineClassBase.) |
| DeserializeFile(String) | (Inherited from EngineClassBase.) |
| DeserializeFile(String, Encoding) | (Inherited from EngineClassBase.) |
| DeSerializeMe | (Inherited from EngineClassBase.) |
| Disconnect | (Inherited from EngineDataClassBase.) |
| Dispose | (Inherited from EngineClassBase.) |
| Dispose(Boolean) |
Releases the Item resources.
(Overrides DataQuery Dispose(Boolean).) |
| EnableAutoID | (Inherited from EngineDataClassBase.) |
| Enumerate | (Inherited from EngineDataClassBase.) |
|  Equals | (Inherited from Object.) |
| Execute |
Executes the Data Command Query against the Data Source.
|
| ExecuteCommand | (Inherited from EngineDataClassBase.) |
| ExecuteCommand(String) | (Inherited from EngineDataClassBase.) |
| Exists | (Inherited from EngineDataClassBase.) |
| Exists(Int32) | (Inherited from EngineDataClassBase.) |
| Exists(Guid) | (Inherited from EngineDataClassBase.) |
| Exists(Object) | (Inherited from EngineDataClassBase.) |
| Exists(String, String) | (Inherited from EngineDataClassBase.) |
| Finalize | Allows an (Inherited from Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.Object.) |
| FirstPage | (Inherited from EngineDataClassBase.) |
| FirstRow | (Inherited from EngineDataClassBase.) |
| GetColumnNames(Char, Boolean, DataTable) | (Inherited from EngineDataClassBase.) |
| GetColumnNames(Char, Char, DataTable) | (Inherited from EngineDataClassBase.) |
| GetCommandText | (Inherited from DataQuery.) |
| GetDataCommand |
Gets the Data Command Text from the Data Command Source.
|
| GetDataCSV(Boolean, Boolean) | (Inherited from EngineDataClassBase.) |
| GetDataCSV(Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| GetDataDistincts |
Gets the Data Distincts for the Data Source.
|
| GetDataDistinctsXML | (Inherited from DataQuery.) |
| GetDataFilters |
Gets the Data Filters for the Data Source.
|
| GetDataFiltersXML |
Gets the Data Filters XML from the Data Filters Source.
(Overrides DataQuery GetDataFiltersXML .) |
| GetDataMappingXML | (Inherited from DataQuery.) |
| GetDataName |
Function gets the Database Name of the Data Source for the Data Command Query.
(Overrides DataConnectionGetDataName .) |
| GetDataNamespace |
Function gets a Data Namespace for the Data Command Query if relevant!!
|
| GetDataPath | (Inherited from EngineDataClassBase.) |
| GetDataRaw |
Function Gets Raw Data for the Data Command Query Data Source.
|
| GetDataRowCount | (Inherited from EngineDataClassBase.) |
| GetDataScheduleXML | (Inherited from DataQuery.) |
| GetDataScriptXML | (Inherited from DataQuery.) |
| GetDataTableSize | (Inherited from EngineDataClassBase.) |
| GetDataTableXML | (Inherited from EngineDataClassBase.) |
| GetDataTableXSD | (Inherited from EngineDataClassBase.) |
| GetDataText(Boolean, Char, Boolean) | (Inherited from EngineDataClassBase.) |
| GetDataText(Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| GetDataXML | (Inherited from EngineDataClassBase.) |
| GetDataXMLDocument | (Inherited from EngineDataClassBase.) |
| GetDataXSD | (Inherited from EngineDataClassBase.) |
| GetDefaultSelectCommand | (Inherited from EngineDataClassBase.) |
| GetDefaultSelectCommand(String) | (Inherited from EngineDataClassBase.) |
| GetDefaultSelectCommand(DataRowSortOrder) | (Inherited from EngineDataClassBase.) |
| GetDefaultSelectCommand(String, DataRowSortOrder) | (Inherited from EngineDataClassBase.) |
| GetDistinctSelectCommand | (Inherited from EngineDataClassBase.) |
| GetDistinctSelectCommand(DataRowSortOrder) | (Inherited from EngineDataClassBase.) |
| GetExecutionData |
Function returns the Execution Details as XML.
|
| GetGUIDColumnName | (Inherited from EngineDataClassBase.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetHTMLReport | |
| GetHTMLReportURI | |
| GetIDColumn | (Inherited from EngineDataClassBase.) |
| GetIDColumnName | (Inherited from EngineDataClassBase.) |
| GetPathName | (Inherited from EngineDataClassBase.) |
| GetPropertyNames | (Inherited from EngineClassBase.) |
| GetPython |
Gets the Python Script Text from the Python Source.
|
| GetPythonText | (Inherited from DataQuery.) |
| GetResultXSD | |
| GetRow(Int32) | (Inherited from EngineDataClassBase.) |
| GetRow(Guid) | (Inherited from EngineDataClassBase.) |
| GetRow(Object) | (Inherited from EngineDataClassBase.) |
| GetRow(String, String) | (Inherited from EngineDataClassBase.) |
| GetRowCount | (Inherited from EngineDataClassBase.) |
| GetRowCSV | (Inherited from EngineDataClassBase.) |
| GetRowData | (Inherited from EngineDataClassBase.) |
| GetRowData(DataRow) | (Inherited from EngineDataClassBase.) |
| GetRowDataItem(DataColumn, Type, DataRow, Object) | (Inherited from EngineDataClassBase.) |
| GetRowDataItem(DataColumn, VariantType, DataRow, Object) | (Inherited from EngineDataClassBase.) |
| GetRowDataItem(Int32, Type, DataRow, Object) | (Inherited from EngineDataClassBase.) |
| GetRowDataItem(Int32, VariantType, DataRow, Object) | (Inherited from EngineDataClassBase.) |
| GetRowDataItem(String, Type, DataRow, Object) | (Inherited from EngineDataClassBase.) |
| GetRowDataItem(String, VariantType, DataRow, Object) | (Inherited from EngineDataClassBase.) |
| GetRowDataItems |
Gets the Data Items for the Class from the Data Table.
(Inherited from DataQuery.) |
| GetRowGUID | (Inherited from EngineDataClassBase.) |
| GetRowGUID(DataRow) | (Inherited from EngineDataClassBase.) |
| GetRowID | (Inherited from EngineDataClassBase.) |
| GetRowIDItem | (Inherited from EngineDataClassBase.) |
| GetRowIDItem(DataRow) | (Inherited from EngineDataClassBase.) |
| GetRowText(Char, DataRow) | (Inherited from EngineDataClassBase.) |
| GetRowText(Char, Char, DataRow) | (Inherited from EngineDataClassBase.) |
| GetRowXML | (Inherited from EngineDataClassBase.) |
| GetRowXML(DataRow) | (Inherited from EngineDataClassBase.) |
| GetRSSFeed | |
| GetRSSReportURI | |
| GetSchemaPathName | (Inherited from EngineDataClassBase.) |
| GetSelectCommand | (Inherited from EngineDataClassBase.) |
| GetServerName |
Function gets the Server Name of the Data Source for the Data Command Query.
|
| GetTableIdentity | (Inherited from EngineDataClassBase.) |
| GetTableName | (Inherited from EngineDataClassBase.) |
| GetTablePrefix | (Inherited from EngineDataClassBase.) |
| GetType | Gets the (Inherited from Type of the current instance.Object.) |
| GetXMLDataSize | (Inherited from EngineDataClassBase.) |
| GetXQuery |
Gets the Data XQuery Text from the Data XQuery Source.
|
| GetXQueryText | (Inherited from DataQuery.) |
| GetXSLT |
Gets the XSLT Text from the XSLT Source.
|
| GetXSLTText | (Inherited from DataQuery.) |
| HasAutoID | (Inherited from EngineDataClassBase.) |
| HasOutputData | |
| HasProperty | (Inherited from EngineClassBase.) |
| ImportCSV(Uri, Boolean) | (Inherited from EngineDataClassBase.) |
| ImportCSV(String, Boolean) | (Inherited from EngineDataClassBase.) |
| ImportCSV(Uri, Boolean, Char, Char, Boolean) | (Inherited from EngineDataClassBase.) |
| ImportCSV(String, Boolean, Char, Char, Boolean) | (Inherited from EngineDataClassBase.) |
| ImportData(DataSet) | (Inherited from EngineDataClassBase.) |
| ImportData(DataTable) | (Inherited from EngineDataClassBase.) |
| ImportData(DataRow) | (Inherited from EngineDataClassBase.) |
| ImportXML(Uri, Boolean, Boolean) | (Inherited from EngineDataClassBase.) |
| ImportXML(String, String, Boolean) | (Inherited from EngineDataClassBase.) |
| Initialize |
Initialize the resources.
|
| InitializeData | (Inherited from EngineDataClassBase.) |
| InitializeData(Int32) | (Inherited from EngineDataClassBase.) |
| InitializeData(String) | (Inherited from EngineDataClassBase.) |
| InsertDB | (Inherited from EngineDataClassBase.) |
| IsDifferent | (Inherited from EngineClassBase.) |
| IsGUIDNull | (Inherited from EngineDataClassBase.) |
| IsIDNull | (Inherited from EngineDataClassBase.) |
| IsNew | (Inherited from EngineDataClassBase.) |
| IsPKNull | (Inherited from EngineDataClassBase.) |
| IsValidRow | (Inherited from EngineDataClassBase.) |
| LastPage | (Inherited from EngineDataClassBase.) |
| LastRow | (Inherited from EngineDataClassBase.) |
| Load | (Inherited from EngineDataClassBase.) |
| Load(Guid) | (Inherited from EngineDataClassBase.) |
| Load(Int32) | (Inherited from EngineDataClassBase.) |
| Load(Object) | (Inherited from EngineDataClassBase.) |
| LoadCSV(String, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| LoadCSV(Uri, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| LoadCSVFile | (Inherited from EngineDataClassBase.) |
| LoadDataConnection | |
| LoadDataOutputs | (Inherited from DataQuery.) |
| LoadDataOutputs(String) | (Inherited from DataQuery.) |
| LoadTable | (Inherited from EngineDataClassBase.) |
| LoadXML(XmlDocument) | (Inherited from EngineDataClassBase.) |
| LoadXML(String) | (Inherited from EngineDataClassBase.) |
| LoadXML(String, String) | (Inherited from EngineDataClassBase.) |
| LoadXML(String, XmlReadMode) | (Inherited from EngineDataClassBase.) |
| LoadXML(Uri, Boolean) | (Inherited from EngineDataClassBase.) |
| LoadXMLFile(String, Boolean) | (Inherited from EngineDataClassBase.) |
| LoadXMLFile(String, XmlReadMode) | (Inherited from EngineDataClassBase.) |
| LoadXSD | (Inherited from EngineDataClassBase.) |
| LoadXSD(String) | (Inherited from EngineDataClassBase.) |
| LoadXSDFile | (Inherited from EngineDataClassBase.) |
| MemberwiseClone | Creates a shallow copy of the current (Inherited from Object.Object.) |
| Merge | (Inherited from EngineDataClassBase.) |
| Merge(DataSet) | (Inherited from EngineDataClassBase.) |
| Merge(DataTable) | (Inherited from EngineDataClassBase.) |
| Merge(DataSet, MissingSchemaAction) | (Inherited from EngineDataClassBase.) |
| MergeCSV(Uri) | (Inherited from EngineDataClassBase.) |
| MergeCSV(String) | (Inherited from EngineDataClassBase.) |
| MergeCSV(Uri, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| MergeCSV(String, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| MergeXML(Uri, Boolean) | (Inherited from EngineDataClassBase.) |
| MergeXML(String, String) | (Inherited from EngineDataClassBase.) |
| MigrateData |
Migrates the Result Data to another Data Source.
|
| MoveFirst | (Inherited from EngineDataClassBase.) |
| MoveLast | (Inherited from EngineDataClassBase.) |
| MoveNext | (Inherited from EngineDataClassBase.) |
| MovePrevious | (Inherited from EngineDataClassBase.) |
| NextPage | (Inherited from EngineDataClassBase.) |
| OnAdded | (Inherited from EngineDataClassBase.) |
| OnChanged | (Inherited from EngineClassBase.) |
| OnClearing | (Inherited from EngineClassBase.) |
| OnDeleted | (Inherited from EngineDataClassBase.) |
| OnDirty | (Inherited from EngineClassBase.) |
| OnEnumerated | (Inherited from EngineDataClassBase.) |
| OnExecute | |
| OnLoaded | (Inherited from EngineDataClassBase.) |
| OnPropertyChanged | (Inherited from EngineClassBase.) |
| OnRowDataGet | (Inherited from EngineDataClassBase.) |
| OnRowDataSet | (Inherited from EngineDataClassBase.) |
| OnSaved | (Inherited from EngineDataClassBase.) |
| OnSynchronized | (Inherited from EngineDataClassBase.) |
| OpenCSV | (Inherited from EngineDataClassBase.) |
| OpenCSV(Char, Char) | (Inherited from EngineDataClassBase.) |
| OpenCSV(String, Char, Char) | (Inherited from EngineDataClassBase.) |
| OpenCSV(Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| OpenCSV(Uri, Char, Char) | (Inherited from EngineDataClassBase.) |
| OpenCSV(String, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| OpenCSV(Uri, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| OpenCSVFile | (Inherited from EngineDataClassBase.) |
| OpenData(DataSet) | (Inherited from EngineDataClassBase.) |
| OpenData(String, DataSet) | (Inherited from EngineDataClassBase.) |
| OpenSchema | (Inherited from EngineDataClassBase.) |
| OpenXML | (Inherited from EngineDataClassBase.) |
| OpenXML(XmlDocument) | (Inherited from EngineDataClassBase.) |
| OpenXML(String) | (Inherited from EngineDataClassBase.) |
| OpenXML(String, String) | (Inherited from EngineDataClassBase.) |
| OpenXML(Uri, Boolean) | (Inherited from EngineDataClassBase.) |
| OpenXMLFile | (Inherited from EngineDataClassBase.) |
| OpenXSD(String) | (Inherited from EngineDataClassBase.) |
| OpenXSD(TextReader) | (Inherited from EngineDataClassBase.) |
| OpenXSD(XmlReader) | (Inherited from EngineDataClassBase.) |
| OpenXSD(Stream) | (Inherited from EngineDataClassBase.) |
| OpenXSDFile | (Inherited from EngineDataClassBase.) |
| PreviousPage | (Inherited from EngineDataClassBase.) |
| PropertiesToCSV | (Inherited from EngineClassBase.) |
| PropertiesToString | (Inherited from EngineClassBase.) |
| PropertiesToXML | (Inherited from EngineClassBase.) |
| PushCSV(String) | (Inherited from EngineDataClassBase.) |
| PushCSV(String, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| PushXML | (Inherited from EngineDataClassBase.) |
| PutDataCommand |
Puts the Data Command Query Text or File.
|
| ReadData(DbDataReader) | (Inherited from EngineDataClassBase.) |
| ReadData(Int32, Boolean) | (Inherited from EngineDataClassBase.) |
| ResetAutoID | (Inherited from EngineDataClassBase.) |
| ResetData | (Inherited from EngineDataClassBase.) |
| ResetPage | (Inherited from EngineDataClassBase.) |
| ReSync | (Inherited from EngineDataClassBase.) |
| RowIndexOf | (Inherited from EngineDataClassBase.) |
| RowIndexOf(DataRow) | (Inherited from EngineDataClassBase.) |
| Save | (Inherited from EngineDataClassBase.) |
| SaveBase | (Inherited from EngineDataClassBase.) |
| SaveChanges | (Inherited from EngineDataClassBase.) |
| SaveCSV(Boolean) | (Inherited from EngineDataClassBase.) |
| SaveCSV(String, Boolean) | (Inherited from EngineDataClassBase.) |
| SaveCSV(String, Boolean, Char) | (Inherited from EngineDataClassBase.) |
| SaveCSV(String, Boolean, Char, Char) | (Inherited from EngineDataClassBase.) |
| SaveData | (Inherited from EngineDataClassBase.) |
| SaveDataOutputs | (Inherited from DataQuery.) |
| SaveNow | (Inherited from EngineDataClassBase.) |
| SaveRow | (Inherited from EngineDataClassBase.) |
| SaveText | (Inherited from EngineDataClassBase.) |
| SaveXML | (Inherited from EngineDataClassBase.) |
| SaveXSD | (Inherited from EngineDataClassBase.) |
| SelectAll | (Inherited from EngineDataClassBase.) |
| SelectByDataFolder(Guid) |
Loads all Data Command Query Items from the Data Folder GUID.
|
| SelectByDataFolder(String) |
Loads all Data Command Query Items from the Data Folder GUID.
|
| SelectByDataSourceConnection |
Loads all Data Command Query Items from the specified Data Source Connection GUID.
|
| SelectTable | (Inherited from EngineDataClassBase.) |
| SelectTop | (Inherited from EngineDataClassBase.) |
| SelectTopFrom(Int32) | (Inherited from EngineDataClassBase.) |
| SelectTopFrom(DataTable, Int32) | (Inherited from EngineDataClassBase.) |
| Serialize | (Inherited from EngineClassBase.) |
| Serialize(XmlWriterSettings) | (Inherited from EngineClassBase.) |
| Serialize(Encoding) | (Inherited from EngineClassBase.) |
| Serialize(String) | (Inherited from EngineClassBase.) |
| Serialize(String, Encoding) | (Inherited from EngineClassBase.) |
| SerializeDataSet | (Inherited from EngineDataClassBase.) |
| SerializeMe | (Inherited from EngineClassBase.) |
| SetBusy |
Sets the Data Command Query into the Busy State!
|
| SetCommandText | (Inherited from DataQuery.) |
| SetDataDistinctsXML | (Inherited from DataQuery.) |
| SetDataFiltersXML | (Inherited from DataQuery.) |
| SetDataMappingXML | (Inherited from DataQuery.) |
| SetDataScheduleXML | (Inherited from DataQuery.) |
| SetDataScriptXML | (Inherited from DataQuery.) |
| SetDataTable | (Inherited from EngineDataClassBase.) |
| SetError | (Inherited from EngineClassBase.) |
| SetException | (Inherited from EngineClassBase.) |
| SetIsAdded | (Inherited from EngineDataClassBase.) |
| SetIsChanged | (Inherited from EngineClassBase.) |
| SetIsClean | (Inherited from EngineClassBase.) |
| SetIsDeleted | (Inherited from EngineDataClassBase.) |
| SetIsDirty | (Inherited from EngineClassBase.) |
| SetIsLoaded | (Inherited from EngineDataClassBase.) |
| SetIsNew | (Inherited from EngineDataClassBase.) |
| SetIsSaved | (Inherited from EngineDataClassBase.) |
| SetIsSynchronized | (Inherited from EngineDataClassBase.) |
| SetPythonText | (Inherited from DataQuery.) |
| SetRowData | (Inherited from EngineDataClassBase.) |
| SetRowDataItem(Int32, Object, DataRow ) | (Inherited from EngineDataClassBase.) |
| SetRowDataItem(String, Object, DataRow ) | (Inherited from EngineDataClassBase.) |
| SetRowDataItem(DataColumn, Object, DataRow ) | (Inherited from EngineDataClassBase.) |
| SetRowDataItems |
Sets the Data Items in the Data Table from the Class.
(Inherited from DataQuery.) |
| SetRowGUID | (Inherited from EngineDataClassBase.) |
| SetRowID | (Inherited from EngineDataClassBase.) |
| SetXQueryText | (Inherited from DataQuery.) |
| SetXSLTText | (Inherited from DataQuery.) |
| ShallowClone | (Inherited from EngineClassBase.) |
| ShallowCopy | (Inherited from EngineClassBase.) |
| Synchronize | (Inherited from EngineDataClassBase.) |
| TableExists | (Inherited from EngineDataClassBase.) |
| Test |
Test Executes the Data Command Query against the Data Source without updating Log and Execution Parameters.
|
| ToString | (Inherited from Object.) |
| Update(Boolean) | (Inherited from EngineDataClassBase.) |
| Update(DataRowState) | (Inherited from EngineDataClassBase.) |
| Update(String, Int32 ) | (Inherited from EngineDataClassBase.) |
| Update(Int32, DataRowState) | (Inherited from EngineDataClassBase.) |
| Update(String, DataRowState) | (Inherited from EngineDataClassBase.) |
| Update(DataTable, DataRowState) | (Inherited from EngineDataClassBase.) |
| UpdateDB | (Inherited from EngineDataClassBase.) |
| UpdateExecuteStatus | |
| Validate |
Function Validates the Data Command Query and returns True if successful.
|
| ValidateIDColumn | (Inherited from EngineDataClassBase.) |
| ValidateIDColumn(DataColumn) | (Inherited from EngineDataClassBase.) |
| WriteDataOutputs | |
| WriteHTMLReport | |
| WriteLog(String, String, LogLevels) |
Writes an Entry into the Data Execution Log. This is automatic if the EnableLog option is set to True and the Execute is successful.
|
| WriteLog(String, String, LogLevels, DateTime, DateTime) |
Writes an Entry into the Data Execution Log. This is automatic if the EnableLog option is set to True and the Execute is successful.
|
| WriteResultDataCSV | |
| WriteResultDataJSon | |
| WriteResultDataRSS | |
| WriteResultDataXML | |
| WriteRSSFeed | |
| WriteRSSXSLT | |
| WriteSharedReport |
Function Writes the shared Data Report.
|
Properties
| Name | Description | |
|---|---|---|
 | AddExecutionData |
Gets or sets the option to Add Execution Data to the Data Command Query Result Outputs.
(Inherited from DataQuery.) |
| AlwaysClose | (Inherited from DataSourceConnection.) |
| AsyncRead | (Inherited from EngineDataClassBase.) |
| BOF | (Inherited from EngineDataClassBase.) |
| Builder | (Inherited from DataConnection.) |
| Cancelled |
Returns True if Execution was Cancelled.
|
| ClassType | (Inherited from EngineClassBase.) |
| CommandEncrypted |
Gets or sets the Encrypted Option for the Data Command Text or File.
(Inherited from DataQuery.) |
| CommandFile |
Gets or sets the Location of the Data Command File.
(Inherited from DataQuery.) |
| CommandSource |
Gets or sets the Command Source for the Data Command Query.
(Inherited from DataQuery.) |
| CommandText |
Gets or sets the Data Command Text.
(Inherited from DataQuery.) |
| CommandTimeout | (Inherited from DataSourceConnection.) |
| ConnectionState |
Property returns the Connection State of the Data Source. Read-only.
|
| ConnectionString |
Gets or sets the Data Connection String.
(Inherited from DataSourceBase.) |
| ConnectionTime |
Property returns the Connection Time of the Data Source.
|
| CreatedBy |
Gets or sets the User Name of the Creator.
(Inherited from DataSourceBase.) |
| CreatedDate |
Gets or sets the Date the Item was Created.
(Inherited from DataSourceBase.) |
 | DataAccessLayer | (Inherited from EngineDataClassBase.) |
| DataAdapter | (Inherited from EngineDataClassBase.) |
| DatabaseName | (Inherited from DataConnection.) |
| DataDestinationConnectionGUID |
Gets or sets the Data Destination GUID to be used for the Data Migration.
(Inherited from DataQuery.) |
| DataDestinationConnectionString |
Gets or sets the Data Destination Connection String.
(Inherited from DataQuery.) |
| DataDestinationInstance |
Gets or sets Data Destination Instance for Migration.
(Inherited from DataQuery.) |
| DataDestinationTableName |
Gets or sets the Data Table Name used for mapping the Result Data in the Migration.
(Inherited from DataQuery.) |
| DataDestinationType |
Gets or sets the Data Destination Type.
(Inherited from DataQuery.) |
| DataDistincts |
Gets or sets the Data Distinct options for the Result Data.
(Inherited from DataQuery.) |
| DataFile | (Inherited from EngineDataClassBase.) |
| DataFilters |
Gets or sets the Data Filter for Filtering and Sorting Result Data.
(Inherited from DataQuery.) |
| DataFiltersEnabled |
Gets or sets the Option to Enable the Data Filters for Filtering and Sorting Result Data.
(Inherited from DataQuery.) |
| DataFiltersFile |
Gets or sets the Location of the Data Filters File.
(Inherited from DataQuery.) |
| DataFiltersSource |
Gets or sets the Source for the Data Filters.
(Inherited from DataQuery.) |
| DataFolderGUID |
Gets or sets the Data Folder GUID of the Item.
(Inherited from DataSourceBase.) |
| DataLinkType |
Returns the Location of the Data Source as either a Connection String or Data Raw. Read-only.
|
| DataMapping |
Gets or sets the Data Mapping for the Data Command Query.
(Inherited from DataQuery.) |
| DataMigrationEnabled |
Gets or sets the option to Enable Migration of Result Data to another Data Source.
(Inherited from DataQuery.) |
| DataName | (Inherited from EngineDataClassBase.) |
| DataOutputItems | (Inherited from DataQuery.) |
| DataPrefix | (Inherited from EngineDataClassBase.) |
| DataRaw |
Gets or sets the Raw Data for the Data Command Query.
|
| DataReportGUID |
Gets or sets the Data Report ID to be used for the Data Command.
(Inherited from DataQuery.) |
| DataRow | (Inherited from EngineDataClassBase.) |
| DataSchedule |
Gets or sets the Data Schedule for the Data Command Query.
(Inherited from DataQuery.) |
| DataScript |
Gets or sets the Data Script for the Data Command Query.
(Inherited from DataQuery.) |
| DataServerName | (Inherited from DataConnection.) |
| DataSet | (Inherited from EngineDataClassBase.) |
| DataSource | (Inherited from EngineDataClassBase.) |
| DataSourceConnection | |
| DataSourceConnectionGUID |
Gets or sets the Data Connection GUID to be used for the Data Command.
(Inherited from DataQuery.) |
| DataSourceConnectionText | (Inherited from DataConnection.) |
| DataSourceInstance |
Gets or sets the Data Source Connection Instance to be used for the Data Command Query.
(Inherited from DataQuery.) |
| DataSourceName | (Inherited from DataConnection.) |
| DataSourceType | (Inherited from DataConnection.) |
| DataTable | (Inherited from EngineDataClassBase.) |
| DataTruncate | (Inherited from DataSourceConnection.) |
| DataType | (Inherited from EngineDataClassBase.) |
| DataURI | (Inherited from EngineDataClassBase.) |
| DBCommand | (Inherited from EngineDataClassBase.) |
| DBConnection | (Inherited from EngineDataClassBase.) |
| DefaultSelectCommand | (Inherited from EngineDataClassBase.) |
| DefaultSortOrder | (Inherited from EngineDataClassBase.) |
| Description |
Gets or sets the Description for the Data Command Query.
(Inherited from DataQuery.) |
| DestinationConnectionText |
Gets or sets the Data Destination Connection String.
(Inherited from DataQuery.) |
| DisableExecution |
Gets or sets the option to Disable Execution of the Data Command Query.
(Inherited from DataQuery.) |
| Disposed | (Inherited from EngineClassBase.) |
| DistinctSelectCommand | (Inherited from EngineDataClassBase.) |
| ElapsedTime |
Gets the Execution Elapsed Time of the Data Command Query. Read-only
|
| EnableAutoExecute |
Gets or sets the option to Automatically Execute the Data Command Query on Selection.
(Inherited from DataQuery.) |
| EnableDataMigrationLog |
Gets or sets the option to Enable the Data Execution Log for the Data Migration.
(Inherited from DataQuery.) |
| EnableDataMigrationWarning |
Gets or sets the option to display a Warning Dialog before attempting Data Migration.
(Inherited from DataQuery.) |
| EnableEvents | (Inherited from EngineDataClassBase.) |
| EnableFilterExpressionPrompt |
Gets or sets the Option to display a Select Filter Expression prompt to apply additional Filtering to the Result Data upon Execution.
(Inherited from DataQuery.) |
| EnableHTMLReport |
Gets or sets the Option to Enable the HTML Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| EnableLog |
Gets or sets the Option to Log the Executed Data Command.
(Inherited from DataQuery.) |
| EnableRSSReport |
Gets or sets the Option to Enable the RSS Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| EnableSecurity |
Gets or sets the option to Enable the Security options for the User Manager Security Module.
(Inherited from DataQuery.) |
| EnableSnapshot |
Gets or sets the Option to Snapshot the Executed Data Command and Result Data in XML format.
(Inherited from DataQuery.) |
| EncryptConnectionString | (Inherited from DataConnection.) |
| EncryptDataDestinationConnectionString |
Gets or sets the option to Encrypt the Data Destination Connection String for Security.
(Inherited from DataQuery.) |
| EOF | (Inherited from EngineDataClassBase.) |
| ExecutedCount |
Gets or sets the Executed Count.
(Inherited from DataQuery.) |
| ExecuteError |
Returns the last Execute Error Message.
|
| ExecuteScript |
Gets or sets the option to Execute a Script or Process.
(Inherited from DataQuery.) |
| ExecuteState | |
| FinishTime |
Gets the Execution Finish Time of the Data Command Query. Read-only
|
| GetRowDataOption | (Inherited from EngineDataClassBase.) |
| GUID |
Gets or sets the GUID of the Data Command Query.
(Inherited from DataQuery.) |
| GUIDColumnName | (Inherited from EngineDataClassBase.) |
| GUIDOn | (Inherited from EngineDataClassBase.) |
| HandleExceptions | (Inherited from EngineClassBase.) |
| HasError |
Returns True if there was an Execution Error.
|
| HasExecuted |
Flag Indicates if the Data Command Query has Executed.
|
| HasIndex | (Inherited from EngineDataClassBase.) |
| HasResultXSD |
Returns True if the Result Data has a Schema XSD.
|
| HasRows | (Inherited from EngineDataClassBase.) |
| HasSchema | (Inherited from EngineDataClassBase.) |
| HasWarning |
Returns True if there was an Execution Warning.
|
| HasXSD | (Inherited from EngineDataClassBase.) |
| HTMLReportFile |
Gets or sets the Location of the Report File to be used for the Data Command Query.
(Inherited from DataQuery.) |
| HTMLReportOption |
Gets or sets the HTML Report Option for the Data Command.
(Inherited from DataQuery.) |
| HTMLReportText |
Gets or sets the Report Embedded Text RDL XML or XSLT to be used for the Data Command Query.
(Inherited from DataQuery.) |
| ID |
Gets or sets the ID of the Data Command Query.
(Inherited from DataQuery.) |
| IDColumnName | (Inherited from EngineDataClassBase.) |
| IncludeData |
Gets or sets the option to include the Data Results in a Data Execution Plan.
|
| IsAdded | (Inherited from EngineDataClassBase.) |
| IsBusy |
Property returns True if the Data Command Query is Busy.
|
| IsChanged | (Inherited from EngineClassBase.) |
| IsDataBase | (Inherited from EngineDataClassBase.) |
| IsDataFile | (Inherited from EngineDataClassBase.) |
| IsDeleted | (Inherited from EngineDataClassBase.) |
| IsDirty | (Inherited from EngineClassBase.) |
| IsEmpty | (Inherited from EngineDataClassBase.) |
| IsExecuting |
Property returns True if the Data Command Query is Executing.
|
| IsHidden |
Gets or sets the option to Hide the Data Command Query from the User View.
(Inherited from DataQuery.) |
| IsInitialized | (Inherited from EngineDataClassBase.) |
| IsJetProvider | (Inherited from EngineDataClassBase.) |
| IsLoaded | (Inherited from EngineDataClassBase.) |
| IsMSDASQLProvider | (Inherited from EngineDataClassBase.) |
| IsSaved | (Inherited from EngineDataClassBase.) |
| IsSQLProvider | (Inherited from EngineDataClassBase.) |
| IsSynchronized | (Inherited from EngineDataClassBase.) |
| IsValid | (Inherited from DataConnection.) |
| ItemKey | (Inherited from EngineClassBase.) |
| LastErrDescription | (Inherited from EngineClassBase.) |
| LastErrNumber | (Inherited from EngineClassBase.) |
| LastErrSource | (Inherited from EngineClassBase.) |
| LastException | (Inherited from EngineClassBase.) |
| LastExecutedBy |
Gets or sets the Last Executor.
(Inherited from DataQuery.) |
| LastExecutedDate |
Gets or sets the Last Executed Date.
(Inherited from DataQuery.) |
| ModifiedBy |
Gets or sets the User Name of the Modifier.
(Inherited from DataSourceBase.) |
| ModifiedDate |
Gets or sets the Date the Item was Modified.
(Inherited from DataSourceBase.) |
| NamespacePrefix |
Gets or sets the Namespace Prefix for the Data Command Query.
(Inherited from DataQuery.) |
| NamespaceURI |
Gets or sets the Namespace URI for the Data Command Query.
(Inherited from DataQuery.) |
| NoMatch | (Inherited from EngineDataClassBase.) |
| Notes |
Gets or sets the Notes for the Data Command Query.
(Inherited from DataQuery.) |
| OmitXMLDeclaration |
Gets or sets the Option to Omit the XML Declaration from the Result XML Output.
(Inherited from DataQuery.) |
| OnDirtyEvent | (Inherited from EngineClassBase.) |
| PageCount | (Inherited from EngineDataClassBase.) |
| PageIndex | (Inherited from EngineDataClassBase.) |
| PageSize | (Inherited from EngineDataClassBase.) |
| Properties | (Inherited from EngineClassBase.) |
| PythonDataOption |
Gets or sets the Python Data Option.
(Inherited from DataQuery.) |
| PythonEnabled |
Gets or sets the Enabled Option for the Python Script Text or File.
(Inherited from DataQuery.) |
| PythonEncrypted |
Gets or sets the Encrypted Option for the Python Script Text or File.
(Inherited from DataQuery.) |
| PythonExecuteWhen |
Gets or sets When to Execute the Python Script either After or Before the XQuery / XSLT.
(Inherited from DataQuery.) |
| PythonFile |
Gets or sets the Location of the Python Script File.
(Inherited from DataQuery.) |
| PythonSchemaOption |
Gets or sets the Python Schema Option.
(Inherited from DataQuery.) |
| PythonSource |
Gets or sets the Python Source.
(Inherited from DataQuery.) |
| PythonText |
Gets or sets the Python Script Text.
(Inherited from DataQuery.) |
| QueryName |
Gets or sets the Data Command Query Name.
(Inherited from DataQuery.) |
| RaiseError | (Inherited from EngineClassBase.) |
| Reference |
Gets or sets the Reference for the Data Command Query.
(Inherited from DataQuery.) |
| RemoveXMLNamespace |
Gets or sets the Option to Remove the XML Namespace from the Result XML Output.
(Inherited from DataQuery.) |
| ReportFile |
Gets or sets the Location to the Report File.
(Inherited from DataQuery.) |
| ReportInstance |
Gets or sets the Data Report Instance to be used for the Data Command.
(Inherited from DataQuery.) |
| ReportType |
Gets or sets the Report Type.
(Inherited from DataQuery.) |
| ResultConnection | |
| ResultCSV |
Property returns CSV Data if any for the Data Class.
|
| ResultCSVSeparator |
Gets or sets the CSV Separator for the Result Data.
(Inherited from DataQuery.) |
| ResultCSVTabDelimited |
Gets or sets the CSV Result Data with a Tab Delimiter.
(Inherited from DataQuery.) |
| ResultCSVTextQualifier |
Gets or sets the Result CSV Text Qualifier for the Result Data.
(Inherited from DataQuery.) |
| ResultCSVWithHeader |
Gets or sets the Option to Enable the Column Header on the Data Results CSV.
(Inherited from DataQuery.) |
| ResultData |
The Data Results of the Data Command Query either as a Dataset or an XML Document.
|
| ResultDataName |
Gets or sets the Data Name for the Result Data.
(Inherited from DataQuery.) |
| ResultDataType |
Returns the Result Data Source Type. Read-only.
|
| ResultJSon |
Property returns JSon Data if any for the Data Class.
|
| ResultRows |
Property returns the Row Count of the Result Data. Read-only.
|
| ResultSource |
The Data Source of the Data Command Query.
|
| ResultTableName |
Gets or sets the Table Name for the Result Data.
(Inherited from DataQuery.) |
| ResultXML |
The Result XML for the Data Command Query.
|
| ResultXMLType |
Gets or sets the the Result XML Data Type.
|
| ResultXSD |
The Result XSD for the Data Command Query.
|
| RowCount | (Inherited from EngineDataClassBase.) |
| RowIndex | (Inherited from EngineDataClassBase.) |
| RowLimit | (Inherited from EngineDataClassBase.) |
| RowLock | (Inherited from EngineDataClassBase.) |
| RowsAffected | (Inherited from EngineDataClassBase.) |
| RowsRead | (Inherited from EngineDataClassBase.) |
| SaveHTMLReport |
Gets or sets the Option to Save the HTML Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| SaveHTMLReportLocation |
Gets or sets the Location to the File Name or Path to Save the HTML Report of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveHTMLReportOption |
Gets or sets the Save HTML Report Option to Save with a fixed File Name or to a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveHTMLReportToPDF |
Gets or sets the Option to Save a PDF copy of the HTML Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| SaveResultCSV |
Gets or sets the Option to Save the Data Query Result Data to a CSV File.
(Inherited from DataQuery.) |
| SaveResultCSVLocation |
Gets or sets the Location of the File Name or Path to Save the CSV / XLSX Result Data of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveResultCSVOption |
Gets or sets the Save Result Option to Save the Data Query Result Data to a CSV File with a fixed File Name or a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveResultJSon |
Gets or sets the Option to Save the Data Query Result Data to a JSon File.
(Inherited from DataQuery.) |
| SaveResultJSonLocation |
Gets or sets the Location of the File Name or Path to Save the JSon Result Data of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveResultJSonOption |
Gets or sets the Save Result Option to Save the Data Query Result Data to a JSon File with a fixed File Name or a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveResultXLSX |
Gets or sets the Option to Save the Data Query Result Data to a XLSX File.
(Inherited from DataQuery.) |
| SaveResultXML |
Gets or sets the Option to Save the Data Query Result Data to an XML File.
(Inherited from DataQuery.) |
| SaveResultXMLLocation |
Gets or sets the Location of the File Name or Path to Save the XML Result Data of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveResultXMLOption |
Gets or sets the Save Result Option to Save the Data Query Result Data to a XML File with a fixed File Name or a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveResultXSD |
Gets or sets the Option to Save the Data Query Result Data Schema to an XSD File.
(Inherited from DataQuery.) |
| SaveRSSFeed |
Gets or sets the Option to Save an RSS Feed for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| SaveRSSFeedLocation |
Gets or sets the Location to the File Name or Path to Save the RSS Feed of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveRSSFeedOption |
Gets or sets the Save RSS Feed Option to Save with a fixed File Name or to a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveRSSFeedWithXSLT |
Gets or sets the Option to Save the RSS Feed with a default XSL Transform thus formatting the Feed.
(Inherited from DataQuery.) |
| ScriptArguments |
Gets or sets the Script or Process Arguments.
(Inherited from DataQuery.) |
| ScriptFile |
Gets or sets the Location of the Script or Process File to Execute.
(Inherited from DataQuery.) |
| ScriptWait |
Gets or sets the option to Wait until the Script or Process has finished Executing.
(Inherited from DataQuery.) |
| StartTime |
Gets the Execution Start Time of the Data Command Query. Read-only.
|
| StatusIcon |
Gets or sets the Status Icon of the Data Command Query.
|
| StatusMessage |
Gets the Status Message of the Data Command Query. Read-only.
|
| StatusText |
Gets or sets the Status Text of the Data Command Query.
|
| TableName | (Inherited from EngineDataClassBase.) |
| TablePrefix | (Inherited from DataSourceConnection.) |
| Tag | (Inherited from EngineClassBase.) |
| TypeClassName | (Inherited from EngineClassBase.) |
| UserID | (Inherited from DataConnection.) |
| UserPassword | (Inherited from DataConnection.) |
| XQueryEnabled |
Gets or sets the Enabled Option for the Data XQuery Text or File.
(Inherited from DataQuery.) |
| XQueryEncrypted |
Gets or sets the Encrypted Option for the Data XQuery Text or File.
(Inherited from DataQuery.) |
| XQueryEngine |
Gets or sets the XQuery Engine to be used for the Data Command Query.
(Inherited from DataQuery.) |
| XQueryFile |
Gets or sets the Location of the Data XQuery File.
(Inherited from DataQuery.) |
| XQuerySchemaOption |
Gets or sets the XQuery Schema Option for the Data Command Query.
(Inherited from DataQuery.) |
| XQuerySource |
Gets or sets the XQuery Source for the Data XQuery.
(Inherited from DataQuery.) |
| XQueryText |
Gets or sets the Data XQuery Text.
(Inherited from DataQuery.) |
| XSLTEnabled |
Gets or sets the Option to Enable the XSLT for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| XSLTEncrypted |
Gets or sets the XSLT is Encrypted.
(Inherited from DataQuery.) |
| XSLTExecuteWhen |
Gets or sets When to Execute the Data XSLT.
(Inherited from DataQuery.) |
| XSLTFile |
Gets or sets the Location of the XSLT File to be used for the Data Command Query.
(Inherited from DataQuery.) |
| XSLTSource |
Gets or sets the XSLT Source for the Data Command.
(Inherited from DataQuery.) |
| XSLTText |
Gets or sets the Embedded Text XSLT to be used for the Data Command Query.
(Inherited from DataQuery.) |
Events
| Name | Description | |
|---|---|---|
 | Added | (Inherited from EngineDataClassBase.) |
| Changed | (Inherited from EngineClassBase.) |
| Deleted | (Inherited from EngineDataClassBase.) |
| Dirty | (Inherited from EngineClassBase.) |
| Enumerated | (Inherited from EngineDataClassBase.) |
| Executed | |
| ExecuteProgress | |
| Found | (Inherited from EngineDataClassBase.) |
| Loaded | (Inherited from EngineDataClassBase.) |
| PropertyChanged | (Inherited from EngineClassBase.) |
| ReadComplete | (Inherited from EngineDataClassBase.) |
| ReadRow | (Inherited from EngineDataClassBase.) |
| RowDataGet | (Inherited from EngineDataClassBase.) |
| RowDataSet | (Inherited from EngineDataClassBase.) |
| RowUpdated | (Inherited from EngineDataClassBase.) |
| Saved | (Inherited from EngineDataClassBase.) |
| Synchronized | (Inherited from EngineDataClassBase.) |
See Also