dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlDataTable Class
Properties Methods Events

In This Topic
    SqlDataTable Class Members
    In This Topic

    The following tables list the members exposed by SqlDataTable.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the SqlDataTable class.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets whether a Devart.Common.DbDataTable is filled with data from a data source. (Inherited from Devart.Common.DbDataTable)
    Public PropertyEnables or disables cached updates mode. (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from Devart.Common.DbDataTable)
    Public PropertyIndicates whether string comparisons within the table are case-sensitive. (Inherited from System.Data.DataTable)
    Public PropertyGets the collection of child relations for this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets the collection of columns that belong to this table. (Inherited from Devart.Common.DbDataTable)
    Public PropertySpecifies which System.Data.ConflictOption is to be used by the Devart.Common.DbDataTable. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets the SqlConnection used to connect to the data source.  
    Public PropertyGets the collection of constraints maintained by this table. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets the container for the component. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public PropertyGets the System.Data.DataSet to which this table belongs. (Inherited from System.Data.DataTable)
    Public PropertyGets a customized view of the table that may include a filtered view, or a cursor position. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets a SQL Server statement to delete records from the data set.  
    Public PropertyGets a value indicating whether the component is currently in design mode. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public PropertyGets 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)
    Public PropertyGets the collection of customized user information. (Inherited from System.Data.DataTable)
    Public PropertyOverridden. Determines whether data is requested from server entirely or partially.  
    Public PropertyGets 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)
    Public PropertyGets or sets a SQL Server statement to insert new records into the data source.  
    Public PropertyGets a value that indicates whether the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets the locale information used to compare strings within the table. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets max number of records to fetch starting from StartRecord. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets the initial starting size for this table. (Inherited from System.Data.DataTable)
    Public PropertyDetermines the action to take when existing DataSet schema does not match incoming data. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets name of the component. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets data request mode. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets form that the component resides on. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets a Devart.Common.ParentDataRelation object that is used for server side master-detail relation. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets the collection of parent relations for this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets an array of columns that function as primary keys for the data table. (Inherited from Devart.Common.DbDataTable)
    Public PropertyDetermines whether Devart.Common.DbDataTable should perfrom additional request to determine quantity of records in the result set. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets whether the Devart.Common.DbDataTable quotes all the names of data source objects. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets number of rows in the result set. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets list of fields whose values should be retrieved after a DML statement execution.  
    Public PropertyGets 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)
    Public PropertyGets or sets a System.Data.SerializationFormat for the Devart.Common.DbDataTable used during remoting. (Inherited from Devart.Common.DbDataTable)
    Public PropertyDetermines whether to use provider-specific types whenever possible. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets the collection of rows that belong to this table. (Inherited from System.Data.DataTable)
    Public PropertyGets the schema table corresponding to the SelectCommand query. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets a SQL Server statement used to select records in the data source.  
    Public PropertyGets or sets an System.ComponentModel.ISite for the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets record number to start. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets an object that can be used to synchronize access to the System.Data.DataTable.Rows collection. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets a System.Data.Common.DataTableMapping object that provides the master mapping between a source table and a SqlDataTable.  
    Public PropertyGets or sets the name of the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets 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)
    Public PropertyGets or sets a SQL Server statement used to update records in the data source.  
    Public PropertyGets or sets string containing list of field names used to generate update commands.  
    Public PropertyGets or sets string containing list of key field names separated by semicolon. They are used to generate update commands.  
    Public PropertyGets or sets the string containing table name used to generate update commands.  
    Top
    Public Methods
     NameDescription
    Public MethodCommits all the changes made to this table since the last time System.Data.DataTable.AcceptChanges was called. (Inherited from System.Data.DataTable)
    Public MethodStarts an asynchronous invocation of the Fill() method. (Inherited from Devart.Common.DbDataTable)
    Public MethodBegins 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)
    Public MethodTurns off notifications, index maintenance, and constraints while loading data. (Inherited from System.Data.DataTable)
    Public MethodStops asynchronous fill operation. (Inherited from Devart.Common.DbDataTable)
    Public MethodClears Devart.Common.DbDataTable and stops Fill operation. (Inherited from Devart.Common.DbDataTable)
    Public MethodClones the structure of the Devart.Common.DbDataTable, including all System.Data.DataTable schemes and constraints. (Inherited from Devart.Common.DbDataTable)
    Public MethodDisconnects Devart.Common.DbDataTable from the data source and frees server resources allocated for the query. (Inherited from Devart.Common.DbDataTable)
    Public MethodComputes the given expression on the current rows that pass the filter criteria. (Inherited from System.Data.DataTable)
    Public MethodCopies both the structure and data for this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodReturns a System.Data.DataTableReader corresponding to the data within this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodReleases all resources used by the System.ComponentModel.MarshalByValueComponent. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodEnds an asynchronous invocation of the Fill() method. (Inherited from Devart.Common.DbDataTable)
    Public MethodEnds 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)
    Public MethodTurns on notifications, index maintenance, and constraints after loading data. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. 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)
    Public MethodOverloaded. 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.  
    Public MethodConfigures the schema to match that in the data source. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded. 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)
    Public MethodGets an array of System.Data.DataRow objects that contain errors. (Inherited from System.Data.DataTable)
    Public MethodPopulates a serialization information object with the data needed to serialize the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodGets the implementer of the System.IServiceProvider. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodCopies 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)
    Public MethodOverloaded. 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)
    Public MethodOverloaded. 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)
    Public MethodOverloaded. Merge the specified System.Data.DataTable with the current System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodCreates a new System.Data.DataRow with the same schema as the table. (Inherited from System.Data.DataTable)
    Public MethodFetches data and sets the Active property to true. (Inherited from Devart.Common.DbDataTable)
    Public MethodReads the next data row when Devart.Common.DbDataTable operates in connected model. (Inherited from Devart.Common.DbDataTable)
    Public MethodFills a row with data not fetched in the initial fill operation. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded. Reads XML schema and data into the System.Data.DataTable using the specified System.IO.Stream. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Reads an XML schema into the System.Data.DataTable using the specified stream. (Inherited from System.Data.DataTable)
    Public MethodRefreshes the specified row with values from server. (Inherited from Devart.Common.DbDataTable)
    Public MethodRolls 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)
    Public MethodResets 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)
    Public MethodOverloaded. Gets an array of all DataRow objects. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded. Suspends asynchronous fill operation. (Inherited from Devart.Common.DbDataTable)
    Public MethodGets the System.Data.DataTable.TableName and System.Data.DataTable.DisplayExpression, if there is one as a concatenated string. (Inherited from System.Data.DataTable)
    Public MethodExecutes the appropriate commands to delete, insert, or update rows in the data source. (Inherited from Devart.Common.DbDataTable)
    Public MethodExecutes the appropriate commands to delete, insert, or update the specified rows in the data source. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded. Writes the current contents of the System.Data.DataTable as XML using the specified System.IO.Stream. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Writes the current data structure of the System.Data.DataTable as an XML schema to the specified stream. (Inherited from System.Data.DataTable)
    Top
    Public Events
     NameDescription
    Public EventOccurs after a value has been changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable)
    Public EventOccurs when a value is being changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable)
    Public EventAdds an event handler to listen to the Disposed event on the component. (Inherited from Devart.Common.DbDataTable)
    Public EventOccurs when a result set is completely fetched. (Inherited from Devart.Common.DbDataTable)
    Public EventOccurs when an error is raised during a fill operation. (Inherited from Devart.Common.DbDataTable)
    Public EventOccurs after the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable)
    Public EventOccurs after a System.Data.DataRow has been changed successfully. (Inherited from System.Data.DataTable)
    Public EventOccurs when a System.Data.DataRow is changing. (Inherited from System.Data.DataTable)
    Public EventOccurs after a row in the table has been deleted. (Inherited from System.Data.DataTable)
    Public EventOccurs before a row in the table is about to be deleted. (Inherited from System.Data.DataTable)
    Public EventOccurs when another row is completely fetched. (Inherited from Devart.Common.DbDataTable)
    Public EventOccurs 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.  
    Public EventOccurs 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.  
    Public EventOccurs after a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable)
    Public EventOccurs when a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable)
    Public EventOccurs when a new System.Data.DataRow is inserted. (Inherited from System.Data.DataTable)
    Top
    See Also