You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
string query = "Select EmpNo, EmpName from dbo.Table_1;select Name,Age from dbo.Table_2";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
You need to ensure that the application reads all the rows returned by the code segment.
Which code segment should you use?
A.
while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.Read();
}
B.
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.NextResult();
}
C.
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.NextResult();
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
D.
while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.Read();
while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}