PrepAway - Latest Free Exam Questions & Answers

Which code segment should you insert at line 04?

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.
You add a Web form that contains the following code fragment.
<asp:GridView ID="gvProducts" runat="server" AllowSorting="True" DataSourceID="Products"> </asp:GridView>
<asp:ObjectDataSource ID="Products" runat="server" SelectMethod="GetData" TypeName="DAL" /> </asp:ObjectDataSource>

You write the following code segment for the GetData method of the DAL class. (Line numbers are included for reference only.)
01 Public Function GetData() As Object
02 Dim cnn As New SqlConnection()
03 Dim strQuery As String = "SELECT * FROM Products"
04
05 End Function

You need to ensure that the user can use the sorting functionality of the gvProducts GridView control.
Which code segment should you insert at line 04?

PrepAway - Latest Free Exam Questions & Answers

A.
Dim cmd As New SqlCommand(strQuery, cnn)
cnn.Open()
Return cmd.ExecuteReader()

B.
Dim cmd As New SqlCommand(strQuery, cnn)
cnn.Open()
Return cmd.ExecuteReader(CommandBehavior.KeyInfo)

C.
Dim da As New SqlDataAdapter(strQuery, cnn)
Dim ds As New DataSet()
da.Fill(ds)
Return ds

D.
Dim da As New SqlDataAdapter(strQuery, cnn)
Dim ds As New DataSet()
da.Fill(ds)
ds.ExtendedProperties.Add("Sortable", True)
Return ds.Tables(0).[Select]()


Leave a Reply