ADO.Net Interview Question and Answers

41. What are basic methods of Dataadapter?
 
  • Fill
  • FillSchema
  • Update
 
Your Name Your Email-ID
Your Answer
42. What are the various methods provided by the dataset object to generate XML?
  ReadXML : Read’s a XML document in to Dataset.
GetXML : This is a function which returns the string containing XML document.
WriteXML : This writes a XML data to disk.
 
Your Name Your Email-ID
Your Answer
43. What is DataSet Object?
  Dataset is a disconnected, in-memory representation of data. It can contain multiple data table from different database.
 
Your Name Your Email-ID
Your Answer
44. What is difference between Optimistic and Pessimistic locking?
  In Pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user’s can only view the data when there is pessimistic locking
In Optimistic locking multiple users can open the same record for updating, thus increase maximum concurrency. Record is only locked when updating the record.
 
Your Name Your Email-ID
Your Answer
45. What is the role of DataReader object?
 
  • A DataReader object provides forward only, read only access to a database.
  • The connection to the database must be open while accessing data through DataReader object.
  • It loads only a single row at a time in the memory.
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 9 of 16