You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.
You create a Web page that has a GridView control named GridView1. The GridView1 control displays the
data from a database named Region and a table named Location.
You write the following code segment to populate the GridView1 control. (Line numbers are included for reference only.)
01 Protected Sub Page_Load(ByVal sender As Object, _ ByVal e As EventArgs)
02 Dim connstr As String
03 ...
04 SqlDependency.Start(connstr)
05 Using connection As New SqlConnection(connstr)
06 Dim sqlcmd As New SqlCommand()
07 Dim expires As DateTime = DateTime.Now.AddMinutes(30)
08 Dim dependency As SqlCacheDependency = _
09 New SqlCacheDependency("Region", "Location")
10 Response.Cache.SetExpires(expires)
11 Response.Cache.SetValidUntilExpires(True)
12 Response.AddCacheDependency(dependency)
13
14 sqlcmd.Connection = connection
15 GridView1.DataSource = sqlcmd.ExecuteReader()
16 GridView1.DataBind()
17 End Using
18 End Sub
You need to ensure that the proxy servers can cache the content of the GridView1 control. Which code segment should you insert at line 13? ()
| English | Chinese | Japan | Korean | - 90 - Test Information Co., Ltd. All rights reserved.