📄 listing1405.aspx
字号:
<%@Page Language="VB" %>
<%@Import Namespace="System.Data" %>
<%@Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load(obj as Object,e as EventArgs)
if not Page.IsPostBack then
CreateData()
end if
end sub
sub CreateData
dim source as DataView
source =Cache("DataView")
if source is nothing then
dim strConnString as string ="Provider=" & _
"Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\ASPNET\data\banking.mdb"
dim objCmd as OleDbDataAdapter =new _
OleDbDataAdapter("select * from tblUsers ", _
strConnString)
dim ds as DataSet =new DataSet()
objCmd.Fill(ds,"tblUsers")
source =new DataView(ds.Tables("tblUsers"))
'Cache("DataView")=source
Cache.Add("DataSet", source, nothing, DateTime.Now. _
AddMinutes(1), TimeSpan.Zero, _
CacheItemPriority.High, CacheItemPriorityDecay.Slow, _
addressof HandleRemove)
lblMessage.Text ="Data set created explicitly "
else
lblMessage.Text ="Data set retrieved from cache "
end if
dgData.DataSource =source
dgData.DataBind()
end sub
sub HandleRemove(key as string,value as object, _
reason as CacheItemRemovedReason)
'
end sub
sub ExpireCache(obj as object,e as eventargs)
dim dv as dataview =Cache.Remove("DataView")
CreateData()
end sub
</script>
<html><body>
<form runat="server">
<asp:Label id="lblMessage" runat="server"
maintainState=false/><p>
<asp:Button id="btSubmit" runat="server"
text="Expire Cache"
OnClick="ExpireCache"/><p>
<asp:DataGrid id="dgData" runat="server"
BorderColor="black"
GridLines="Vertical"
cellpadding="4"
cellspacing="0"
width="450"
Font-Name="Arial"
Font-Size="8pt"
HeaderStyle-BackColor="#cccc99"
ItemStyle-BackColor="#ffffff"
AlternatingItemStyle-Backcolor="#cccccc" />
</form>
</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -