The Code Project

By Pete2004

http://www.dotnet247.com/247reference/a.aspx?u=http://www.codeproject.com/csharp/PracticalGuideDataGrids1.asp

## DataSet Methods

DataSet Method | Description
AcceptChanges() | Accepts all changes to the DataSet
Clear() | Removes all rows from all tables in the DataSet – that is, removes all data.
Clone() | Creates a new DataSet with all tables having the same Table structure including any constraints and relationships. No Data is copied.
Copy() | Same as for the DataSet Clone() but it includes all Data.
GetChanges() | Creates a DataSet that contains all changes made to the dataset. If AcceptChanges was called then only changes made since the last call are returned.
HasChanges() | Returns true if any changes were made to the DataSet including adding tables and modifying rows.
WriteXml() | Outputs an XML file containing schema with all Tables, Data, Constraints and relationships.
ReadXml() | Inputs an XML file containing schema, Tables, Data, Constraints and relationships..

DataSet Properties

DataSet Property | Description
CaseSensitive | If set to true then string compares in DataSet tables are case sensitive otherwise they are not.
DataSetName | Name of the DataSet
HasErrors | Returns true if there are any errors within any tables in the DataSet
Relationss | Collection of Relations

Method/Property | Description
Add() |
AddRange() | If two or more relations are to be added to the collection they can be added using this method. They are appended to the existing collection in the order specified in the range.
CanRemove | Returns true if the relation can be removed from the collectionn
Clear() | Removes all relations from the relations collection
Contains() | Returns a true if the collection contains the named relation.
Count | Returns the number of relations in the collection
IndexOf() | Returns the index of a relation in the collection equal to name.
Remove() | Removes a relation by Name from the collection
RemoveAt() | Removes a relation by index from the collection.

Tables | Collection of Tables

Method/Property | Description
Add() | Adds a table to the collection
AddRange() | If two or more tables are to be added to the collection they can be added using this method. They are appended to the existing collection in the order specified in the range.
Clear() | Removes all tables from the collection
Contains() | Returns a true if the collection contains a table with TableName equal to name.
Count | Returns the number of tables in the collection
IndexOf() | Returns the index of a table in the collection with a TableName equal to name.
Remove() | Removes a table by TableName from the collection
RemoveAt() | Removes a table by index from the collection.