Question: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:
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();