You are creating ASP.NET applications by using the .NET Framework 3.5. You plan to display data from a Microsoft SQL Server 2005 database. You write the following stored procedure. (Line numbers are included for reference only.)
01 CREATE PROCEDURE GetEventHistory
02 AS
03 SELECT HistoryID, EventName, EventDescription
04 FROM EVENTHistory FOR XML AUTO
You need to ensure that the Web page design meets the following requirements:
– Each row from the database is displayed on a separate row on the Web page.
– The result is displayed in a GridView control.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A.
Use LINQ to XML to retrieve data for the GridView control.
B.
Use the SqlDataSource control to retrieve data for the GridView control.
C.
Use the XmlDataSource control to retrieve data for the GridView control.
D.
Modify line 04 of the stored procedure in the following manner. FROM EVENTHistory
E.
Modify line 04 of the stored procedure in the following manner. FROM EVENTHistory FOR XML AUTO, ROOT(‘XML’)