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. |
|
|
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. |
|
|
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”. |
|
|
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. |
|
|
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 |
|
|