latest Post

Use of DataSet object in ADO.NET?

It is used in a disconnected architecture.
  • Provides lower performance. A DataSet object has read/write access.
  • A DataSet object supports multiple tables from various databases.
  • A DataSet object is bound to multiple controls.
  • A DataSet object has slower access to data.
  • A DataSet object is supported by Visual Studio tools.
  • We can create relations in a dataset.
  • A Dataset supports integration with XML.
  • A DataSet communicates with the Data Adapter only.
  • A DataSet can modify data.
A DataSet is a collection of DataTable and DataRelations. Each DataTable is a collection of DataColumn, DataRows and Constraints.
Example:
  1. DataTable dt = new DataTable();  
  2. DataColumn col =new DataColumn();  
  3. Dt.columns.Add(col2);  
  4. DataRow row = dt.newRow();  

About Mallikarjun A

Mallikarjun A
Recommended Posts × +

0 comments:

Post a Comment