Multiple choice technology web 2.0

Stacy wants to populate a select dropdown combo box with data in a data store. Stacy wants a fast, forward only, read-only database connection using ADO.NET.

  1. A DataAdapter object

  2. A Command object

  3. A DataReader object

  4. A Recordset object

  5. A Connection object
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DataReader is designed for fast, forward-only, read-only data retrieval - ideal for populating read-only UI controls like dropdowns. It streams data efficiently without caching. DataAdapter fills DataSets, Command executes queries, Connection manages the connection, and Recordset is from classic ADO.

AI explanation

ADO.NET's DataReader object provides a fast, forward-only, read-only stream of data directly from the database connection, ideal for quickly populating a dropdown/combo box without the overhead of a disconnected, updatable data structure. A DataAdapter is used to fill a DataSet/DataTable (disconnected, supports updates), a Command object just executes SQL/stored procedures, a Recordset is a classic ADO (not ADO.NET) construct, and a Connection object merely manages the connection itself — none of these match the specific 'fast, forward-only, read-only' requirement that DataReader is purpose-built for.

Keep practicing — related questions