ADO.Net Interview Question and Answers

56. What is DataAdapter?
  A data adapter represents a set of methods used to perform a two-way data updating mechanism between a disconnected DataTable and the database. It aggregates four commands: select, update, insert and delete command. One adapter can only generate and fill one table in a DataSet.
 
Your Name Your Email-ID
Your Answer
57. What is a Command Object?
  The ADO Command object is used to execute a single query against a database. The query can perform actions like creating, adding, retrieving, deleting or updating records.
 
Your Name Your Email-ID
Your Answer
58. What is basic use of DataView?
  “DataView” represents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in “datatable”.
 
Your Name Your Email-ID
Your Answer
59. What is the use of Connection Object?
  The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database.
 
Your Name Your Email-ID
Your Answer
60. What is a stored procedure?
  A stored procedure is a precompiled executable object that contains one or more SQL statements.
A stored procedure may be written to accept inputs and return output
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 12 of 16