ADO.NET Interview questions

Total available count: 25
Subject - Microsoft Technologies
Subsubject - ADO.NET

Explain the methods of DataAdapter.Update() and DataSetAcceptChanges()?

Dataset maintains the rowstate of each row with in a table. As a dataset is loaded, it's rowstate version is unchanged. Whenever there is a modification in a paricular row with in a datatable, dataset changes the rowversion as modified.
The DataAdapter.Update() method calls UPDATE, INSERT, or DELETE statements, as the case may be to update, insert, or delete a row in a DataSet.
The DataSet.Acceptchanges() method reflects all the changes made to the row since the last time the AcceptChanges() method was called.

Next 5 interview question(s)

How to connect a database through SqlConnection?
How to fill a DataSet?
Explain about ADO.NET namespaces which are required to connect database?
How to convert a DataSet into a DataReader?
What are the differences between ADO and ADO.NET?