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

+ Answer
+ Report
Total Preview: 1484

Copyright © 2024. Powered by Intellect Software Ltd