.NET framework data provider includes the following components for data manipulation:
Connection : Used for connectivity to the data source
Command : This executes the SQL statements needed to retrieve data, modify data or execute stored procedures. It works with connection object.It requires instance of connection object.
DataReader : This class is used to retrieve data. DataReader is forward only and read-only object. We cannot modify the data using DataReader.
DataAdapter : It works as bridge between dataset and data source. DataAdapter uses fill method to load the dataset.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
.NET framework data provider includes the following components for data manipulation:
Connection : Used for connectivity to the data source
Command : This executes the SQL statements needed to retrieve data, modify data or execute stored procedures. It works with connection object.It requires instance of connection object.
DataReader : This class is used to retrieve data. DataReader is forward only and read-only object. We cannot modify the data using DataReader.
DataAdapter : It works as bridge between dataset and data source. DataAdapter uses fill method to load the dataset.