In ADO.NET, how can you handle multiple result sets returned by a SELECT statement?
- Using the SqlCommand.ExecuteReader() method
- Using the SqlConnection.Open() method
- Using the SqlDataAdapter.Fill() method
- Using the SqlDataReader.NextResult() method
In ADO.NET, you can handle multiple result sets returned by a SELECT statement using the SqlDataReader.NextResult() method. This method advances the SqlDataReader to the next result set if available. It allows you to iterate through multiple result sets returned by the same command execution.
Loading...
Related Quiz
- How can you enable data binding to a DropDownList control in a web application?
- Which SQL keyword is used to sort the result set in ascending order?
- In ADO.NET, the DataAdapter uses a combination of ___________ to perform its operations.
- Scenario: Your application needs to perform complex data transformations on a collection of customer records. Which LINQ feature allows you to achieve this efficiently?
- Which LINQ to SQL operation is used to delete records from a database table?