Name | Description | |
---|---|---|
SqlDataTable Constructor | Overloaded. Initializes a new instance of the SqlDataTable class. |
The following tables list the members exposed by SqlDataTable.
Name | Description | |
---|---|---|
SqlDataTable Constructor | Overloaded. Initializes a new instance of the SqlDataTable class. |
Name | Description | |
---|---|---|
Active | Gets or sets whether a Devart.Common.DbDataTable is filled with data from a data source. (Inherited from Devart.Common.DbDataTable) | |
CachedUpdates | Enables or disables cached updates mode. (Inherited from Devart.Common.DbDataTable) | |
CancelEditRowIfUpdateFailed | (Inherited from Devart.Common.DbDataTable) | |
CaseSensitive | Indicates whether string comparisons within the table are case-sensitive. (Inherited from System.Data.DataTable) | |
ChildRelations | Gets the collection of child relations for this System.Data.DataTable. (Inherited from System.Data.DataTable) | |
Columns | Gets the collection of columns that belong to this table. (Inherited from Devart.Common.DbDataTable) | |
ConflictOption | Specifies which System.Data.ConflictOption is to be used by the Devart.Common.DbDataTable. (Inherited from Devart.Common.DbDataTable) | |
Connection | Gets or sets the SqlConnection used to connect to the data source. | |
Constraints | Gets the collection of constraints maintained by this table. (Inherited from Devart.Common.DbDataTable) | |
Container | Gets the container for the component. (Inherited from System.ComponentModel.MarshalByValueComponent) | |
DataSet | Gets the System.Data.DataSet to which this table belongs. (Inherited from System.Data.DataTable) | |
DefaultView | Gets a customized view of the table that may include a filtered view, or a cursor position. (Inherited from System.Data.DataTable) | |
DeleteCommand | Gets or sets a SQL Server statement to delete records from the data set. | |
DesignMode | Gets a value indicating whether the component is currently in design mode. (Inherited from System.ComponentModel.MarshalByValueComponent) | |
DisplayExpression | Gets or sets the expression that returns a value used to represent this table in the user interface. The DisplayExpression property lets you display the name of this table in a user interface. (Inherited from System.Data.DataTable) | |
ExtendedProperties | Gets the collection of customized user information. (Inherited from System.Data.DataTable) | |
FetchAll | Overridden. Determines whether data is requested from server entirely or partially. | |
HasErrors | Gets a value indicating whether there are errors in any of the rows in any of the tables of the System.Data.DataSet to which the table belongs. (Inherited from System.Data.DataTable) | |
InsertCommand | Gets or sets a SQL Server statement to insert new records into the data source. | |
IsInitialized | Gets a value that indicates whether the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable) | |
Locale | Gets or sets the locale information used to compare strings within the table. (Inherited from System.Data.DataTable) | |
MaxRecords | Gets or sets max number of records to fetch starting from StartRecord. (Inherited from Devart.Common.DbDataTable) | |
MinimumCapacity | Gets or sets the initial starting size for this table. (Inherited from System.Data.DataTable) | |
MissingSchemaAction | Determines the action to take when existing DataSet schema does not match incoming data. (Inherited from Devart.Common.DbDataTable) | |
Name | Gets or sets name of the component. (Inherited from Devart.Common.DbDataTable) | |
Namespace | Gets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable) | |
NonBlocking | Gets or sets data request mode. (Inherited from Devart.Common.DbDataTable) | |
Owner | Gets or sets form that the component resides on. (Inherited from Devart.Common.DbDataTable) | |
ParentRelation | Gets or sets a Devart.Common.ParentDataRelation object that is used for server side master-detail relation. (Inherited from Devart.Common.DbDataTable) | |
ParentRelations | Gets the collection of parent relations for this System.Data.DataTable. (Inherited from System.Data.DataTable) | |
Prefix | Gets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable) | |
PrimaryKey | Gets or sets an array of columns that function as primary keys for the data table. (Inherited from Devart.Common.DbDataTable) | |
QueryRecordCount | Determines whether Devart.Common.DbDataTable should perfrom additional request to determine quantity of records in the result set. (Inherited from Devart.Common.DbDataTable) | |
Quoted | Gets or sets whether the Devart.Common.DbDataTable quotes all the names of data source objects. (Inherited from Devart.Common.DbDataTable) | |
RecordCount | Gets number of rows in the result set. (Inherited from Devart.Common.DbDataTable) | |
RefreshingFields | Gets or sets list of fields whose values should be retrieved after a DML statement execution. | |
RefreshMode | Gets or sets a value that indicates whether and how the Devart.Common.DbDataTable should retrieve field values adjusted by server after an update. (Inherited from Devart.Common.DbDataTable) | |
RemotingFormat | Gets or sets a System.Data.SerializationFormat for the Devart.Common.DbDataTable used during remoting. (Inherited from Devart.Common.DbDataTable) | |
ReturnProviderSpecificTypes | Determines whether to use provider-specific types whenever possible. (Inherited from Devart.Common.DbDataTable) | |
Rows | Gets the collection of rows that belong to this table. (Inherited from System.Data.DataTable) | |
SchemaTable | Gets the schema table corresponding to the SelectCommand query. (Inherited from Devart.Common.DbDataTable) | |
SelectCommand | Gets or sets a SQL Server statement used to select records in the data source. | |
Site | Gets or sets an System.ComponentModel.ISite for the System.Data.DataTable. (Inherited from System.Data.DataTable) | |
StartRecord | Gets or sets record number to start. (Inherited from Devart.Common.DbDataTable) | |
SyncRoot | Gets an object that can be used to synchronize access to the System.Data.DataTable.Rows collection. (Inherited from Devart.Common.DbDataTable) | |
TableMapping | Gets a System.Data.Common.DataTableMapping object that provides the master mapping between a source table and a SqlDataTable. | |
TableName | Gets or sets the name of the System.Data.DataTable. (Inherited from System.Data.DataTable) | |
UpdateBatchSize | Gets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch. (Inherited from Devart.Common.DbDataTable) | |
UpdateCommand | Gets or sets a SQL Server statement used to update records in the data source. | |
UpdatingFields | Gets or sets string containing list of field names used to generate update commands. | |
UpdatingKeyFields | Gets or sets string containing list of key field names separated by semicolon. They are used to generate update commands. | |
UpdatingTable | Gets or sets the string containing table name used to generate update commands. |
Name | Description | |
---|---|---|
AcceptChanges | Commits all the changes made to this table since the last time System.Data.DataTable.AcceptChanges was called. (Inherited from System.Data.DataTable) | |
BeginFill | Starts an asynchronous invocation of the Fill() method. (Inherited from Devart.Common.DbDataTable) | |
BeginInit | Begins the initialization of a System.Data.DataTable that is used on a form or used by another component. The initialization occurs at run time. (Inherited from System.Data.DataTable) | |
BeginLoadData | Turns off notifications, index maintenance, and constraints while loading data. (Inherited from System.Data.DataTable) | |
CancelFetch | Stops asynchronous fill operation. (Inherited from Devart.Common.DbDataTable) | |
Clear | Clears Devart.Common.DbDataTable and stops Fill operation. (Inherited from Devart.Common.DbDataTable) | |
Clone | Clones the structure of the Devart.Common.DbDataTable, including all System.Data.DataTable schemes and constraints. (Inherited from Devart.Common.DbDataTable) | |
Close | Disconnects Devart.Common.DbDataTable from the data source and frees server resources allocated for the query. (Inherited from Devart.Common.DbDataTable) | |
Compute | Computes the given expression on the current rows that pass the filter criteria. (Inherited from System.Data.DataTable) | |
Copy | Copies both the structure and data for this System.Data.DataTable. (Inherited from System.Data.DataTable) | |
CreateDataReader | Returns a System.Data.DataTableReader corresponding to the data within this System.Data.DataTable. (Inherited from System.Data.DataTable) | |
Dispose | Releases all resources used by the System.ComponentModel.MarshalByValueComponent. (Inherited from System.ComponentModel.MarshalByValueComponent) | |
EndFill | Ends an asynchronous invocation of the Fill() method. (Inherited from Devart.Common.DbDataTable) | |
EndInit | Ends the initialization of a Devart.Common.DbDataTable that is used on a form or used by another component. The initialization occurs at run time. (Inherited from Devart.Common.DbDataTable) | |
EndLoadData | Turns on notifications, index maintenance, and constraints after loading data. (Inherited from System.Data.DataTable) | |
Fill | Overloaded. Fills the System.Data.DataTable.Rows collection of the Devart.Common.DbDataTable with rows from the data source using the parameter values passed in parameterValues. (Inherited from Devart.Common.DbDataTable) | |
FillPage | Overloaded. Overridden. Fills the System.Data.DataTable.Rows collection of the Devart.Common.DbDataTable with rows from the data source starting at the row indicated by startRecord and including up to the number of rows indicated by maxRecords. | |
FillSchema | Configures the schema to match that in the data source. (Inherited from Devart.Common.DbDataTable) | |
GetChanges | Overloaded. Gets a copy of the System.Data.DataTable that contains all changes made to it since it was loaded or System.Data.DataTable.AcceptChanges was last called. (Inherited from System.Data.DataTable) | |
GetErrors | Gets an array of System.Data.DataRow objects that contain errors. (Inherited from System.Data.DataTable) | |
GetObjectData | Populates a serialization information object with the data needed to serialize the System.Data.DataTable. (Inherited from System.Data.DataTable) | |
GetService | Gets the implementer of the System.IServiceProvider. (Inherited from System.ComponentModel.MarshalByValueComponent) | |
ImportRow | Copies a System.Data.DataRow into a System.Data.DataTable, preserving any property settings, as well as original and current values. (Inherited from System.Data.DataTable) | |
Load | Overloaded. Fills a System.Data.DataTable with values from a data source using the supplied System.Data.IDataReader. If the System.Data.DataTable already contains rows, the incoming data from the data source is merged with the existing rows. (Inherited from System.Data.DataTable) | |
LoadDataRow | Overloaded. Finds and updates a specific row. If no matching row is found, a new row is created using the given values. (Inherited from System.Data.DataTable) | |
Merge | Overloaded. Merge the specified System.Data.DataTable with the current System.Data.DataTable. (Inherited from System.Data.DataTable) | |
NewRow | Creates a new System.Data.DataRow with the same schema as the table. (Inherited from System.Data.DataTable) | |
Open | Fetches data and sets the Active property to true. (Inherited from Devart.Common.DbDataTable) | |
Read | Reads the next data row when Devart.Common.DbDataTable operates in connected model. (Inherited from Devart.Common.DbDataTable) | |
ReadComplete | Fills a row with data not fetched in the initial fill operation. (Inherited from Devart.Common.DbDataTable) | |
ReadXml | Overloaded. Reads XML schema and data into the System.Data.DataTable using the specified System.IO.Stream. (Inherited from System.Data.DataTable) | |
ReadXmlSchema | Overloaded. Reads an XML schema into the System.Data.DataTable using the specified stream. (Inherited from System.Data.DataTable) | |
RefreshRow | Refreshes the specified row with values from server. (Inherited from Devart.Common.DbDataTable) | |
RejectChanges | Rolls back all changes that have been made to the table since it was loaded, or the last time System.Data.DataTable.AcceptChanges was called. (Inherited from System.Data.DataTable) | |
Reset | Resets the System.Data.DataTable to its original state. Reset removes all data, indexes, relations, and columns of the table. If a DataSet includes a DataTable, the table will still be part of the DataSet after the table is reset. (Inherited from System.Data.DataTable) | |
Select | Overloaded. Gets an array of all DataRow objects. (Inherited from Devart.Common.DbDataTable) | |
SuspendFill | Overloaded. Suspends asynchronous fill operation. (Inherited from Devart.Common.DbDataTable) | |
ToString | Gets the System.Data.DataTable.TableName and System.Data.DataTable.DisplayExpression, if there is one as a concatenated string. (Inherited from System.Data.DataTable) | |
Update | Executes the appropriate commands to delete, insert, or update rows in the data source. (Inherited from Devart.Common.DbDataTable) | |
UpdateRows | Executes the appropriate commands to delete, insert, or update the specified rows in the data source. (Inherited from Devart.Common.DbDataTable) | |
WriteXml | Overloaded. Writes the current contents of the System.Data.DataTable as XML using the specified System.IO.Stream. (Inherited from System.Data.DataTable) | |
WriteXmlSchema | Overloaded. Writes the current data structure of the System.Data.DataTable as an XML schema to the specified stream. (Inherited from System.Data.DataTable) |
Name | Description | |
---|---|---|
ColumnChanged | Occurs after a value has been changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable) | |
ColumnChanging | Occurs when a value is being changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable) | |
Disposed | Adds an event handler to listen to the Disposed event on the component. (Inherited from Devart.Common.DbDataTable) | |
FetchFinished | Occurs when a result set is completely fetched. (Inherited from Devart.Common.DbDataTable) | |
FillError | Occurs when an error is raised during a fill operation. (Inherited from Devart.Common.DbDataTable) | |
Initialized | Occurs after the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable) | |
RowChanged | Occurs after a System.Data.DataRow has been changed successfully. (Inherited from System.Data.DataTable) | |
RowChanging | Occurs when a System.Data.DataRow is changing. (Inherited from System.Data.DataTable) | |
RowDeleted | Occurs after a row in the table has been deleted. (Inherited from System.Data.DataTable) | |
RowDeleting | Occurs before a row in the table is about to be deleted. (Inherited from System.Data.DataTable) | |
RowFetched | Occurs when another row is completely fetched. (Inherited from Devart.Common.DbDataTable) | |
RowUpdated | Occurs during System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) after a command is executed against the data source. The attempt to update is made, so the event fires. | |
RowUpdating | Occurs during System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) before a command is executed against the data source. The attempt to update is made, so the event fires. | |
TableCleared | Occurs after a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable) | |
TableClearing | Occurs when a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable) | |
TableNewRow | Occurs when a new System.Data.DataRow is inserted. (Inherited from System.Data.DataTable) |