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 object GetData() {
02 SqlConnection cnn = new SqlConnection();
03 string strQuery = “SELECT * FROM Products”;
04
05 }
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?
A.
SqlCommand cmd = new SqlCommand(strQuery, cnn);
cnn.Open();
return cmd.ExecuteReader();
B.
SqlCommand cmd = new SqlCommand(strQuery, cnn);
cnn.Open();
return cmd.ExecuteReader(CommandBehavior.KeyInfo);
C.
SqlDataAdapter da = new SqlDataAdapter(strQuery, cnn);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
D.
SqlDataAdapter da = new SqlDataAdapter(strQuery, cnn);
DataSet ds = new DataSet();
da.Fill(ds); ds.ExtendedProperties.Add(“Sortable”, true);
return ds.Tables[0].Select();