you create a microsoft asp net application by using the framework..., Appendix,

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

/278

+ AnswerC

+ Report

Descriptive on Appendix Ebook

Total Preview: 1504

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

C

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