UNIT-II(ADVANCED ADO .NET)

Disconnected data access in ADO.NET is achieved using the ________ object, which can store data in a disconnected state and perform data manipulation.

The ADO.NET ________ is responsible for bridging the gap between the DataSet and the database, allowing data to be updated in the database from the

disconnected DataSet.

The ________ control in ADO.NET is used to display a single record at a time and allows for data editing operations.

Crystal Reports in ADO.NET allows developers to create and display ________ based on data retrieved from the database.

The ________ object in ADO.NET is used to read data from the database in a connected state and is forward-only and read-only.

One of the main advantages of disconnected data access is the ability to work with data ________, independent of the database connection.

The purpose of the SqlCommandBuilder in ADO.NET is to automatically generate ________ commands for updating data in the database based on changes

made to a DataSet.

The ________ control in ADO.NET is used to display a read-only, tabular representation of data fetched from the database.

ADO.NET plays a significant role in distributed applications by enabling communication between ________ databases.

The ExecuteNonQuery method of the SqlCommand object is used for updating data in the database and does not return any ________.