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

In This Topic
    SqlDataSet Class Members
    In This Topic

    The following tables list the members exposed by SqlDataSet.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets a value indicating whether string comparisons within System.Data.DataTable objects are case-sensitive. (Inherited from System.Data.DataSet)
    Public PropertyAssociated SqlConnection.  
    Public PropertyGets the container for the component. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public PropertyGets or sets the name of the current System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public PropertyGets a custom view of the data contained in the System.Data.DataSet to allow filtering, searching, and navigating using a custom System.Data.DataViewManager. (Inherited from System.Data.DataSet)
    Public PropertyGets a value indicating whether the component is currently in design mode. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public PropertyGets or sets a value indicating whether constraint rules are followed when attempting any update operation. (Inherited from System.Data.DataSet)
    Public PropertyGets the collection of customized user information associated with the DataSet. (Inherited from System.Data.DataSet)
    Public PropertyGets a value indicating whether there are errors in any of the System.Data.DataTable objects within this System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public PropertyGets a value that indicates whether the System.Data.DataSet is initialized. (Inherited from System.Data.DataSet)
    Public PropertyGets or sets the locale information used to compare strings within the table. (Inherited from System.Data.DataSet)
    Public PropertyGets or sets name of the Devart.Common.DbDataSet. (Inherited from Devart.Common.DbDataSet)
    Public PropertyGets or sets the namespace of the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public PropertyGets or sets a form or other container that the Devart.Common.DbDataSet instance belongs to. (Inherited from Devart.Common.DbDataSet)
    Public PropertyGets or sets an XML prefix that aliases the namespace of the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public PropertyGets the collection of relations within the SqlDataSet  
    Public PropertyGets or sets a System.Data.SerializationFormat for the Devart.Common.DbDataSet used during remoting. (Inherited from Devart.Common.DbDataSet)
    Public PropertyGets or sets a System.Data.SchemaSerializationMode for a System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public PropertyGets or sets an System.ComponentModel.ISite for the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public PropertyGets collection of tables  
    Top
    Public Methods
     NameDescription
    Public MethodCommits all the changes made to this System.Data.DataSet since it was loaded or since the last time System.Data.DataSet.AcceptChanges was called. (Inherited from System.Data.DataSet)
    Public MethodBegins the initialization of a System.Data.DataSet that is used on a form or used by another component. The initialization occurs at run time. (Inherited from System.Data.DataSet)
    Public MethodClears the Devart.Common.DbDataSet of any data by removing all rows in all tables. (Inherited from Devart.Common.DbDataSet)
    Public MethodCopies the structure of the Devart.Common.DbDataSet, including all Devart.Common.DbDataTable schemas, relations, and constraints. Does not copy any data. (Inherited from Devart.Common.DbDataSet)
    Public MethodCopies both the structure and data for this System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public MethodOverloaded. Returns a System.Data.DataTableReader with one result set per System.Data.DataTable, in the same sequence as the tables appear in the System.Data.DataSet.Tables collection. (Inherited from System.Data.DataSet)
    Public MethodOverridden. Creates and returns new SqlDataTable object.  
    Public MethodReleases all resources used by the System.ComponentModel.MarshalByValueComponent. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodEnds the initialization of a System.Data.DataSet that is used on a form or used by another component. The initialization occurs at run time. (Inherited from System.Data.DataSet)
    Public MethodFills the System.Data.DataTable.Rows collection of the Devart.Common.DbDataSet with rows from the data source. (Inherited from Devart.Common.DbDataSet)
    Public MethodOverloaded. Gets a copy of the System.Data.DataSet that contains all changes made to it since it was loaded or since System.Data.DataSet.AcceptChanges was last called. (Inherited from System.Data.DataSet)
    Public MethodPopulates a serialization information object with the data needed to serialize the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public MethodGets the implementer of the System.IServiceProvider. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodReturns the XML representation of the data stored in the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public MethodReturns the XML Schema for the XML representation of the data stored in the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public MethodOverloaded. Gets a value indicating whether the System.Data.DataSet has changes, including new, deleted, or modified rows. (Inherited from System.Data.DataSet)
    Public MethodOverloaded. Applies the XML schema from the specified System.Xml.XmlReader to the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public MethodOverloaded. Fills a System.Data.DataSet with values from a data source using the supplied System.Data.IDataReader, using an array of System.Data.DataTable instances to supply the schema and namespace information. (Inherited from System.Data.DataSet)
    Public MethodOverloaded. Merges a specified System.Data.DataSet and its schema into the current DataSet. (Inherited from System.Data.DataSet)
    Public MethodOverloaded. Reads XML schema and data into the Devart.Common.DbDataSet using the specified System.IO.Stream. (Inherited from Devart.Common.DbDataSet)
    Public MethodOverloaded. Reads the XML schema from the specified System.Xml.XmlReader into the System.Data.DataSet. (Inherited from System.Data.DataSet)
    Public MethodRolls back all the changes made to the System.Data.DataSet since it was created, or since the last time System.Data.DataSet.AcceptChanges was called. (Inherited from System.Data.DataSet)
    Public MethodClears all tables and removes all relations, foreign constraints, and tables from the System.Data.DataSet. Subclasses should override System.Data.DataSet.Reset to restore a System.Data.DataSet to its original state. (Inherited from System.Data.DataSet)
    Public MethodReturns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodExecutes the appropriate commands to delete, insert, or update rows in the data source. (Inherited from Devart.Common.DbDataSet)
    Public MethodOverloaded. Writes the current data for the System.Data.DataSet using the specified System.IO.Stream. (Inherited from System.Data.DataSet)
    Public MethodOverloaded. Writes the System.Data.DataSet structure as an XML schema to the specified System.IO.Stream object. (Inherited from System.Data.DataSet)
    Top
    Public Events
     NameDescription
    Public EventAdds an event handler to listen to the System.ComponentModel.MarshalByValueComponent.Disposed event on the component. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public EventOccurs after the System.Data.DataSet is initialized. (Inherited from System.Data.DataSet)
    Public EventOccurs when a target and source System.Data.DataRow have the same primary key value, and System.Data.DataSet.EnforceConstraints is set to true. (Inherited from System.Data.DataSet)
    Top
    See Also