Class for DatasetQuery operation.

The following tables list the members exposed by the DatasetQuery type.

Constructors
Name Description
Public constructor DatasetQuery Construct the instance
Top
Properties
Name Description
Public property ArrayIndexes (inherited from RunObj).
Public property AsyncContents Contains the TDataTable that resulted from one of the asynchronous commands, such as Select or Next.
Public property Category ReadOnly property with categories configured to DatasetQuery object.
Public property Completed The value of this property is incremented when an asynchronous operation is concluded.
Public property Count (inherited from ListObj).
Public property CursorIndex Defines the current row position in the resulting DatasetTable.
Public property DB Gets the DB configured in EditDatasetsTables.
Public property Description Gets the description of the DatasetQuery.
Public property Disable Disables the commands to the DatasetQuery when the value is greater than zero.

0 = Enables the commands to the DatasetQuery

1 = Disables the commands to the DatasetQuery
Public property Execute Sends an asynchronous Execute command when the value is changed.
Public property ExecuteCompleted The value of this property is changed when the asynchronous Execute command is completed.
Public property ID (inherited from RunObj).
Public property Id Object ID (Internal Use).
Public property InternalDBHandle
Public property Item (Overloaded) (inherited from ListObj).
Public property LastStatus Gets the status of the last (most recent) asynchronous operation.

zero = success

different than zero = error code

Public property LastStatusMessage Gets the status message of the last (most recent) asynchronous operation, where an empty string indicates success.
Public property Level ReadOnly property with levels configured to DatasetQuery object.
Public property LocalContents Contains the TDataTable that resulted from one of the sync commands, such as SelectCommand or NextCommand.
Public property Mapping Gets the mapping of the resulting DataTable columns with the Tags.
Public property MappingDateTime Mapping DateTime Mode: (0-Local, 1-UTC)
Public property Next Sends an asynchronous Next command when the value is changed.
Public property NextExecuted The value of this property is changed when the asynchronous Next command is completed.
Public property ObjServer (inherited from RunObj).
Public property ObjType (inherited from RunObj).
Public property Parent (inherited from RunObj).
Public property Root (inherited from RunObj).
Public property RowCount Gets the total number of rows in the resulting DatasetTable.
Public property Select Sends an asynchronous Select command when the value is changed.
Public property SelectExecuted The value of this property is changed when the asynchronous Select command is completed.
Public property SqlStatement Defines the SQL command to be executed.
Public property SyncRoot (inherited from ListObj).
Public property TModule (inherited from RunObj).
Top
Methods
Name Description
Public method BeginSelectCommand
Public method ClearCacheNames (inherited from ListObj).
Public method EndSelectCommand
Public method Equals (Overloaded) (inherited from Object).
Public method ExecuteCommand Execute a synchronous command according to the SqlStatement
Public method ExecuteCommandWithStatus Execute a synchronous command according to the SqlStatement; status message displays.

Parameters

string statusMessage

message with the status of the execute command
Public method GetEnumerator (inherited from ListObj).
Public method GetHashCode (inherited from Object).
Public method GetID (inherited from ListObj).
Public method GetName (Overloaded) (inherited from ListObj).
Public method GetObj (Overloaded) (inherited from ListObj).
Public method GetObjAsObject (inherited from ListObj).
Public method GetObjRef (inherited from RunObj).
Public method GetType (inherited from Object).
Public method IsInUse (inherited from ListObj).
Public method NextCommand Executes a synchronous Next command that increments the value of the CursorIndex property.
Public method NextCommandWithStatus Executes a synchronous Next command that increments the value of the CusorIndex property, and displays a status message.
Public method OnContinue (inherited from RunObj).
Public method OnPause (inherited from RunObj).
Public method OnStart (inherited from RunObj).
Public method OnStop (inherited from RunObj).
Public method PreloadRunObj (inherited from ListObj).
Public method Static ReferenceEquals (inherited from Object).
Public method SelectCommand Executes a synchronous Select command, according to the SqlStatement.
Public method SelectCommandWithStatus Executes a synchronous Select command according to the SqlStatement, and displays status information.
Public method StartPreloadRunObjs (Overloaded) (inherited from ListObj).
Public method ToString (inherited from RunObj).
Top
Extension Methods
Name Description
Public extension method ApplyCast (Overloaded) (Defined by GenericEnumerableHelper).
Public extension method ApplyCount (Defined by GenericEnumerableHelper).
Public extension method ApplySelect (Overloaded) (Defined by GenericEnumerableHelper).
Public extension method ApplyWhere (Defined by GenericEnumerableHelper).
Public extension method ApplyWhereNotNull (Defined by GenericEnumerableHelper).
Public extension method AsParallel (Defined by ParallelEnumerable).
Public extension method AsQueryable (Defined by Queryable).
Public extension method Cast (Defined by Enumerable).
Public extension method ConvertAll (Defined by IEnumerableExtensions).
Public extension method GetParentViewModel (Defined by POCOViewModelExtensions).
Public extension method GetRequiredService (Overloaded) (Defined by POCOViewModelExtensions).
Public extension method GetService (Overloaded) (Defined by POCOViewModelExtensions).
Public extension method IsInDesignMode (Defined by POCOViewModelExtensions).
Public extension method OfType (Defined by Enumerable).
Public extension method RaisePropertiesChanged (Defined by POCOViewModelExtensions).
Top
See Also