单项选择题
You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You write the following code segment in the code-behind file to create a Web form：
01 string strQuery = "select * from Products；"
02 + "select * from Categories"；
03 SqlCommand cmd = new SqlCommand（strQuery， cnn）；
04 cnn.Open（）；
05 SqlDataReader rdr = cmd.ExecuteReader（）；
06 ►
07 rdr.Close（）；
08 cnn.Close（）；
You need to ensure that the gvProducts and gvCategories GridView controls display the data that is contained in the following two database tables： the Products database table the Categories database table
Which code segment should you insert at line 06？（）
A.A
B.B
C.C
D.D
相关考题
-
单项选择题
You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a class that contains the following code segment： 01 public object GetCachedProducts（sqlConnection conn） { 02 03 if （Cache["products"] == null） { 04 SqlCommand cmd = new SqlCommand（ 05 "SELECT * FROM Products"， conn）； 07 conn.Open（）； 08 Cache.Insert（"products"， GetData（cmd））； 09 conn.Close（）； 10 } 11 return Cache["products"]； 12 } 13 14 public object GetData（SqlCommand prodCmd） { 15 16 } Each time a Web form has to access a list of products， the GetCachedProducts method is called to provide this list from the Cache object. You need to ensure that the list of products is always available in the Cache object. Which code segment should you insert at line 15？ （）
A.A
B.B
C.C
D.D -
单项选择题
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.A
B.B
C.C
D.D -
单项选择题
You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. To add a Calendar server control to a Web page， you write the following code fragment： <asp：Calendar SelectionMode="DayWeek" ID="Calendar1" runat="server"> </asp：Calendar> You need to disable the non-week days in the Calendar control. What should you do？（）
A.A
B.B
C.C
D.D
