单项选择题
You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.
| English | Chinese | Japan | Korean | - 48 - Test Information Co., Ltd. All rights reserved. You create a Web form that contains the following code fragment.
You write the following code segment in the code-behind file. (Line numbers are included for reference only.)
01 protected void Page_Load(object sender, EventArgs e)
02 {
03 DataSet objDS = new DataSet();
04 SqlDataAdapter objDA = new SqlDataAdapter(objCmd);
05 objDA.Fill(objDS);
06 gridCities.DataSource = objDs; 07 gridCities.DataBind();
08 Session["ds"] = objDS;
09 }
10 protected void btnSearch_Click(object sender, EventArgs e)
11 {
12
13 }
You need to ensure that when the btnSearch Button control is clicked, the records in the gridCities GridView control are filtered by using the value of the txtSearch TextBox. Which code segment you should insert at line 12?（）
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 write the following code segment in the code-behind file to create a Web form. (Line numbers are included for reference only.) 01 Dim strQuery As String = "select * from Products;" + _ "select * from Categories" 02 Dim cmd As New SqlCommand(strQuery, cnn) 03 cnn.Open() 04 Dim rdr As SqlDataReader = cmd.ExecuteReader() | English | Chinese | Japan | Korean | - 47 - Test Information Co., Ltd. All rights reserved. 05 06 rdr.Close() 07 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 tabl ¡¤The Categories database tabl Which code segment should you insert at line 05? （）
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 write the following code segment in the code-behind file to create a Web form. (Line numbers are included for reference only.) 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 tabl ¡¤The Categories database tabl | English | Chinese | Japan | Korean | - 46 - Test Information Co., Ltd. All rights reserved. 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. (Line numbers are included for reference only.) 01 Public Function GetCachedProducts( _ ByVal conn As SqlConnection) As Object 02 03 If Cache("products") Is Nothing Then 04 Dim cmd As New SqlCommand("SELECT * FROM Products", conn) 05 conn.Open() 06 Cache.Insert("products", GetData(cmd)) 07 conn.Close() 08 End If 09 Return Cache("products") 10 End Function 11 12 Public Function GetData(ByVal prodCmd As SqlCommand) As Object 13 14 End Function 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 13?（）
A.A
B.B
C.C
D.D
