You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The database on the Microsoft SQL Server 2005 database has two tables that are displayed by using two SqlConnection objects in two different GridView controls. You want the tables to be displayed at the same time with the use a single SqlConnection object. What should you do?()
- A Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
- B Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
- C Run the two SqlDataReader objects by using a single SqlCommand object.
- D Enable Multiple Active Result Sets (MARS) in the connection string of the application.