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.
The database contains two tables that are displayed in two different GridView controls. The tables are displayed by using two SqlConnection objects.
You need to display the tables simultaneously by using a single SqlConnection object.
What should you do?
A.
Execute two SqlDataReader objects by using a single SqlCommand object.
B.
Enable Multiple Active Result Sets (MARS) in the connection string of the application.
C.
Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
D.
Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.