DataReader and DataAdapter in ADO.NET

Define DataReader and DataAdapter in ADO.NET.

1. DataReader : It is lightweight class that provides connected and forward-only data access. It uses connection object exclusively. You can read data; you can’t modify data using DataReader.

2. DataAdapter : This class provides disconnected data access. It opens a data connection just long enough to retrieve the data, and loads the data into a DataSet, thus provides in-memory copy of the data.
VB.NET - commandType property of a SqlCommand object
VB.NET - commandType property of a SqlCommand object - CommandType property can set to Text, StoredProcedure, or TableDirect.....
VB.NET - typed and untyped DataSet objects
VB.NET - typed and untyped DataSet objects - An untyped dataset has no corresponding built-in schema......
VB.NET DataView
VB.NET - Briefly describe DataView - The data represented in a DataView object can be filtered and sorted......
Post your comment