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)

Explain the steps to access the database in ADO.NET?
How can a user determine which SQL commands are part of a transaction?
How to connect a database through SqlConnection?
How to convert a DataSet into a DataReader?
How to fill a DataSet?