How to read multiple resultset from SqlDataReader?
49,549
Here you have a sample about how to handle multiple result sets with a data reader
static void RetrieveMultipleResults(SqlConnection connection)
{
using (connection)
{
SqlCommand command = new SqlCommand(
"SELECT CategoryID, CategoryName FROM dbo.Categories;" +
"SELECT EmployeeID, LastName FROM dbo.Employees",
connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
do
{
Console.WriteLine("\t{0}\t{1}", reader.GetName(0),
reader.GetName(1));
while (reader.Read())
{
Console.WriteLine("\t{0}\t{1}", reader.GetInt32(0),
reader.GetString(1));
}
}
while (reader.NextResult());
}
}
The key for retrieving data from multiple data sets is using reader.NextResult
![Rocky](https://i.stack.imgur.com/5cTmY.jpg?s=256&g=1)
Author by
Rocky
Updated on April 07, 2020Comments
-
Rocky about 4 years
I have a SP from that I am trying to return 2 result set from, and in my .cs file i am trying something like this:
dr = cmd.ExecuteReader(); while (dr.Read()) { RegistrationDetails regDetails = new RegistrationDetails() { FName = dr["FName"].ToString(), LName = dr["LName"].ToString(), MName = dr["MName"].ToString(), EntityName = dr["EntityName"].ToString(),// in 2nd result set Percentage = dr["Percentage"].ToString()// in 2nd result set }; }
However I am getting an :
error:IndexOutOfRange {"EntityName"}