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)

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

Comments