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.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *