C# 如何从 SqlDataReader 读取多个结果集？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/19448899/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to read multiple resultset from SqlDataReader?
提问by Rocky
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:
我有一个 SP，我试图从中返回 2 个结果集，在我的 .cs 文件中，我正在尝试这样的事情：
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"}
错误：IndexOutOfRange {"EntityName"}
采纳答案by Claudio Redi
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
从多个数据集中检索数据的关键是使用 reader.NextResult
