Multiple choice technology web technology

What aer the tasks SqlDataAdapter performs when filling a DataSet with data

  1. Close connection

  2. Open connection

  3. Retrieve data into DataSet

  4. Write changes from DataSet to data source
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

SqlDataAdapter automatically handles connection lifecycle during Fill() operations: it opens the connection if closed (B), retrieves data into the DataSet (C), and returns the connection to its original state (closed if it was closed). Option D is incorrect because WriteChanges from DataSet to data source requires separate Update() method, not Fill().

Keep practicing — related questions