Provides controlled access to a data table and common views, using QueryNotifications
to keep it current.
| C# |
public class DataProvider : ISuspendable, IDisposable
| All Members | Constructors | Methods | Properties | Events | |
| Icon | Member | Description |
|---|---|---|
| DataProvider(ITableAdapter, array<IQueryNotification>[]()[]) |
Creates a data provider and derives the target table schema from the query.
If the adapter has update/insert/delete queries, they will be used to commit outstanding data
prior to a refresh.
| |
| DataProvider(ITableAdapter, array<IQueryNotification>[]()[], DataTable) |
Creates a data provider and fills the specified target table.
If the adapter has update/insert/delete queries, they will be used to commit outstanding data
prior to a refresh.
Note: Adapter will be used asynchronously and should not share a SQL connection with any other class.
| |
| DataProvider(ITableAdapter, array<IQueryNotification>[]()[], DataTable, ISynchronizeInvoke) |
Creates a data provider and fills the specified target table.
If the adapter has update/insert/delete queries, they will be used to commit outstanding data
prior to a refresh.
Note: Adapter will be used asynchronously and should not share a SQL connection with any other class.
| |
| DataProvider(ITableAdapter, array<IQueryNotification>[]()[], DataTable, ISynchronizeInvoke, Boolean) |
Creates a data provider and fills the specified target table.
If the adapter has update/insert/delete queries, they will be used to commit outstanding data
prior to a refresh.
Note: Adapter will be used asynchronously and should not share a SQL connection with any other class.
| |
| DataProvider(ITableAdapter, array<IQueryNotification>[]()[], DataTable, ISynchronizeInvoke, Boolean, Boolean) |
Creates a data provider and fills the specified target table.
If the adapter has update/insert/delete queries, they will be used to commit outstanding data
prior to a refresh.
Note: Adapter will be used asynchronously and should not share a SQL connection with any other class.
| |
| Adapter |
The ITableAdapter used for interacting with the database.
| |
| ClearConnectionPool(String) |
Clears the connection pool.
| |
| ContinueOnRowError |
Gets or sets whether all updates that can be saved will be saved before raising an exception.
| |
| CurrentRefreshWorkItem |
Gets the current refresh work item.
| |
| DataChangeNotification |
Occurs when a query notification has fired, which will cause a refresh unless canceled.
| |
| DataRefreshed |
Fires immediately after data has been refresh.
| |
| DataRefreshFailed |
Data refresh has failed.
| |
| DataRefreshing |
Fires immediately before data is going to be refreshed.
| |
| DataUpdating |
Fires immediately before data is going to be updated.
| |
| Dispose()()() |
Disposes of the object.
| |
| Dispose(Boolean) |
Disposes of the object.
| |
| Disposing |
Occurs when the object is being disposed.
| |
| Equals(Object) | (Inherited from Object.) | |
| Finalize()()() |
Finalizes the object.
(Overrides Object.Finalize()()().) | |
| GetDefaultTableView(DataTable) |
Gets the default view of a table.
| |
| GetHashCode()()() |
Serves as a hash function for a particular type.
(Inherited from Object.) | |
| GetTableSuspendState(DataTable) |
Gets a table's suspend state.
| |
| GetType()()() |
Gets the Type of the current instance.
(Inherited from Object.) | |
| HasPendingRefresh |
Gets whether a refresh operation is pending.
| |
| HasRefreshed |
Gets whether the provider has ever loaded data.
| |
| InitSyncObject(Control) |
Sets the control used for invoking methods on the appropriate thread.
| |
| InRefresh |
Gets whether there is a data refresh currently in process.
| |
| IsDisposed |
True if this object has been disposed.
| |
| MemberwiseClone()()() |
Creates a shallow copy of the current Object.
(Inherited from Object.) | |
| MinimumDelay |
Gets or sets the minimum time between refreshes. Used to ensure the DataProvider doesn't refresh too quickly.
| |
| Notifications |
Gets the query notifications associated with this provider.
| |
| OnDataChangeNotification(CancelEventArgs) |
Raises the DataChangeNotification event.
| |
| OnDataRefreshed(EventArgs) |
Raises the DataRefreshed event.
| |
| OnDataRefreshFailed(ExceptionEventArgs) |
Raises the DataRefreshFailed event.
| |
| OnDataRefreshing(CancelEventArgs) |
Raises the DataRefreshing event.
| |
| OnDataUpdating(CancelEventArgs) |
Raises the DataUpdating event.
| |
| OnDisposing(EventArgs) |
Raises the Disposing event.
| |
| PromptForRetry(SqlException, String, Boolean) |
Prompts the user whether to retry.
| |
| PromptForRetry(VistaDBException, String, Boolean) |
Prompts the user whether to retry.
| |
| PromptForRetry(VistaDBSQLException, String, Boolean) |
Prompts the user whether to retry.
| |
| PromptForRetry(DataException, String, Boolean) |
Prompts the user whether to retry.
| |
| RefreshAsynchronously |
Gets whether data will be refreshed asynchronously.
| |
| RefreshData()()() |
Refreshes the data from the database using last used parameters.
This method is thread-safe.
| |
| RefreshData(Boolean) |
Refreshes the data from the database.
This method is thread-safe.
| |
| RefreshData(Boolean, Boolean) |
Refreshes the data from the database.
This method is thread-safe.
| |
| RelatedParentProviders |
Used by DataPlaceDataSource to track the relationships between
tables so that changes are commited to the database in the correct sequence.
| |
| Resume()()() |
Resumes after a call to a Suspend method.
| |
| SelfRelatingColumnName |
Gets or sets the self-relating column name.
If specified, data is collated by this column to respect FK relationships to the same table.
| |
| SortOnKey(array<DataRow>[]()[], String) |
Sorts rows according to their depth in a self-relating table.
| |
| Suspend()()() |
Suspends any data refreshes until Resume()()() is called.
| |
| Suspend(Boolean) |
Suspends any data refreshes until Resume()()() is called.
| |
| Suspended |
Gets whether the provider is suspended.
| |
| SynchronizingObject |
Object, normally a form or control, with which to synchronize when accessing the table and raising events.
This is automatically set to a control created on the thread that created this provider.
| |
| TargetTable |
The DataTable being kept updated with the database.
| |
| TargetTableSuspendable |
Gets the table's suspend state.
| |
| TargetView |
Gets a view of the target table.
| |
| ToString()()() |
Gets a string representation of the object.
(Overrides Object.ToString()()().) | |
| UpdateBeforeRefresh |
Gets or sets whether the database will be updated with changes from the table before each refresh.
| |
| UpdateData()()() |
Updates the data with the database.
| |
| UpdateData(Boolean, Boolean, Boolean, Int32%) |
Updates the data with the database.
| |
| UseChunkedLoader |
Gets or sets whether to load data in progressively larger chunks for better performance.
|
| Object | |
| DataProvider | |