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)

What is the meaning of object pooling?
What is the difference between DataSet.Copy() and DataSet.Clone()?
Types of DataSet in ADO.NET?
Explain about Row States and Row Versions?
Explain the steps to access the database in ADO.NET?