What is C# ADO.NET Dataset
The ADO.NET DataSet contains DataTableCollection and their DataRelationCollection . It represents a collection of data retrieved from the Data Source. We can use Dataset in combination with DataAdapter Class . The DataSet object offers a disconnected data source architecture. The Dataset can work with the data without knowing the source of the data coming from. That is , the Dataset can work with a disconnected mode from its Data Source . It gives a better advantage over DataReader , because the DataReader is working only with the connection oriented Data Sources.
The Dataset contains the copy of the data we requested. The Dataset contains more than one Table at a time. We can set up Data Relations between these tables within the DataSet. The data set may comprise data for one or more members, corresponding to the number of rows.
The DataAdapter Object allows us to populate DataTables in a DataSet. We can use Fill method of the DataAdapter for populating data in a Dataset. The DataSet can be filled either from a data source or dynamically. A DataSet can be saved to an XML file and then loaded back into memory very easily. A DataSet can read and write data and schema as XML documents. The data and schema can then be transported across HTTP and used by any application, on any platform that is XML-enabled.
The following links shows more information of Dataset in details with C# Source Code .
- C# Datset with Sql Server Data Provider
- C# Datset with OLEDB Data Provider
- Find Tables in a Dataset - Sql Server
- Find Tables in a Dataset - OLEDB
- How to Dataset rows count - Sql Server
- How to Dataset rows count - OLEDB
- How to find Column Definition SqlServer
- How to find Column Definition OLEDB
- How to Dyanamic Dataset in C#
- C# Dataset with multiple tables - Sql Server
- C# Dataset with multiple tables - OLEDB
- C# Dataset table relations
- C# Dataset merge tables - Sql Server
- C# Dataset merge tables - OLEDB
- Bind a dataset to a combo box in C#, bind enum to combobox , bind dictionary to combobox
- How to find tables in a Database in C#