ASP.NET Cache»º´æÏê½â
Àý×Ó£º
using system.web.caching
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
void Page_Load(Object Src, EventArgs E) {
DataView Source;
// Retrieve the DataView object from Cache. If not exist, then add DataView object to the Cache.
Source = (DataView)Cache["MyDataSet"];
if (Source == null) {
SqlConnection myConnection = new SqlConnection("Server=ServerName; database=Pubs; user id=UID; password=PWD;");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");
Source = new DataView(ds.Tables["Authors"]);
Cache["MyDataSet"] = Source;
CacheMsg.Text = "Dataset created explicitly";
}
else {
CacheMsg.Text = "Dataset retrieved from cache";
}
// Binding the DataView object with DataGrid.
MyDataGrid.DataSource=Source;
MyDataGrid.DataBind();
}
</script>
<body>
<form method="GET" runat="server">
<h3><font face="Verdana">Caching Data</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaad" />
<p>
<i><asp:label id="CacheMsg" runat="server"/></i>
</form>
</body>
</html>
ASP.NET CacheÊÇÌáÉýϵͳÐÔÄܵÄÖØÒª·½·¨£¬ËüʹÓÃÁË“×î½üʹÓÔÔÔò£¨a least-recently-used algorithm£©¡£ÔÚÊý¾Ý¿â·ÃÎÊÖо³£»áÓõ½Cache±£´æÊý¾Ý¿âÊý¾Ý¡£ 1.»º´æµÄÌí¼Ó£ºCacheµÄÌí¼Ó·½·¨ÓÐAdd()»òInsert£¨£©£¬Á½ÖÖ·½·¨¼¸ºõÀàËÆ£¬Ö»ÊÇInser·½·¨¿ÉÒÔʹÓÿÉÑ¡²ÎÊý£¬¼´Ê¹ÓÃĬÈϲÎÊý£¬À´ÊµÏÖ»º´æµÄÌ
Ïà¹ØÎĵµ£º
µÚÒ»£º
private void Button1_Click( object sender, System.EventArgs e ) { Response.Redirect( Request.Url.ToString( ) ); } µÚ¶þ£º
private void Button2_Click( object sender, System.EventArgs e ) { Response.Write( " < script language=javascript>window.location.href=document.URL; < /script&g ......
ÔÚWEB¿ª·¢Öо³£»áʹÓÃһЩJS£¬IMAGE£¬CSSµÈÏà¹ØÊý¾Ý¡£ÔÚWEB½â¾ö·½°¸Öо³£×öΪһ¸öÎļþ¼Ð´¦Àí¡£ÔÚʹÓõÄÒ³ÃæÖÐÒýÓÃÏà¶Ô·¾¶¾Í¿ÉÒÔÁË¡£µ«Ôڿؼþ¿ª·¢ÖУ¬¾ÍÅöµ½Ò»¸öÎÊÌâ¡£Èç¹ûÎҵĿؼþÐèÒªÒ»¸öJSÎļþ»òÊÇCSSÎļþ»òÊÇÒ»¸öͼƬÔõô°ì£¿×ܲ»ÄÜÔڿؼþµÄDLLÎļþÍâÔÙ¼ÓÒ»¸ö·ÅÖÃÐèÒªÎļþµÄÎļþ¼Ð¡£Ã¿´ÎÓö¼ÐèÒª¿½±´¹ýÈ¥¡£Ì«Âé·³ÁË£¬ ......
Ò»¡¢ÏÂÔØ dotnetfx.exe °²×°
¶þ¡¢×¢²áasp.net C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i
Èý¡¢ÐÞ¸ÄASPXÀ©Õ¹Ö¸Ïò C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Æô¶¯Õ¾µã ¾Í¿ÉÒÔÁË ......
ʹÓÃDataRelationÀà´´½¨¹Øϵ²¢ÀûÓø¸/×Ó¹Øϵ¶ÁÈ¡Êý¾ÝʾÀý
void Page_Load(object sender, System.EventArgs e)
{
// Á¬½Ó×Ö·û´®ºÍ SQL Óï¾ä
string ConnString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
......