Question: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:

01 protected void Page_Load(object sender, EventArgs e)
02 {
03   string connstr;
04
05   SqlDependency.Start(connstr);
06   using (SqlConnection connection =
07    new SqlConnection(connstr))
08  {
09    SqlCommand sqlcmd = new SqlCommand();
10    DateTime expires = DateTime.Now.AddMinutes(30);
11    SqlCacheDependency dependency = new
12    SqlCacheDependency("Region", "Location");
13    Response.Cache.SetExpires(expires);
14    Response.Cache.SetValidUntilExpires(true);
15    Response.AddCacheDependency(dependency);
16 â–º
17    sqlcmd.Connection = connection;
18    GridView1.DataSource = sqlcmd.ExecuteReader();
19    GridView1.DataBind();
20  }
21 }

You need to ensure that the proxy servers can cache the content of the GridView1 control.
Which code segment should you insert at line 16? 

A Response.Cache.SetCacheability(HttpCacheability.Private); 

B Response.Cache.SetCacheability(HttpCacheability.Public); 

C Response.Cache.SetCacheability(HttpCacheability.Server); 

D Response.Cache.SetCacheability(HttpCacheability.ServerAndPrivate); 

+ Answer
+ Report
Total Preview: 968

Copyright © 2024. Powered by Intellect Software Ltd