ASP.NET 2.0 ÖеÄSqlCacheDependencyÌØÐÔ
Ëü»¹»áÔÚÖ¸¶¨µÄÊý¾Ý¿âÖÐÔö¼Ó¼¸¸ö´æ´¢¹ý³Ì£¬ÓÃÀ´ÈÃASP.NETÒýÇæ²éѯ׷×ÙµÄÊý¾Ý±íµÄÇé¿ö¡£
È»ºó£¬Ëü»á¸øÎÒÃÇҪ׷×ÙµÄTable¼ÓÉϼ¸¸öTrigger£¬·Ö±ð¶ÔÓ¦µ½Insert¡¢Update¡¢Delete²Ù×÷£¬Õ⼸¸öTriggerµÄÓï¾ä·Ç³£¼òµ¥£¬¾ÍÊǰѓAspNet_SqlCacheTablesForChangeNotification”±íÖжÔÓ¦“tableName”×Ö¶ÎΪÕâ¸ö×·×ٵıíµÄÃû³ÆµÄ¼Ç¼µÄ“changeId”×ֶμÓÉÏÒ»¸ö1¡£
ASP.NETÒýÇæÍ¨¹ýÖ´ÐÐËü¼ÓÉϵĴ洢¹ý³Ì“AspNet_SqlCachePollingStoredProcedure”£¬Õâ¸ö´æ´¢¹ý³ÌÖ±½Ó·µ»Ø“AspNet_SqlCacheTablesForChangeNotification”±íµÄÄÚÈÝ£¬ÈÃASP.NETÒýÇæÖªµÀÄĸö±íµÄÊý¾Ý·¢ÉúµÄ±ä»¯¡£Ä¬ÈÏÿ500ºÁÃëÖ´ÐÐÕâ¸ö´æ´¢¹ý³ÌÒ»´Î£¬²»¹ý¿ÉÒÔÔÚweb.configÀïÃæÐÞ¸ÄÕâ¸ö¼ä¸ôʱ¼ä£¬ÎҵľÑéÊÇÕâ¸ö²éѯ²Ù×÷Ò²ÊǺܺÄ×ÊÔ´µÄ£¬ºÇºÇ¡£
2¡¢ web.configÅäÖÃ
ÔÚweb.configÀïÃæµÄÅäÖÃÔÙ¼òµ¥²»¹ýÁË
<configuration>
<!-- ¼ÓÉϺÏÊʵÄÊý¾Ý¿âÁ¬½Ó×Ö·û´® -->
<connectionStrings>
<add name="SqlServerConnectionString"
connectionString="server=sqlserver1;uid=sa;pwd=
password;database=PortalDB " />
</connectionStrings>
<system.web>
<!-- ÅäÖÃCacheÒ»¶Î£¬Ê¹Ö®Ö§³ÖSqlCacheDependency -->
<cache>
<sqlCacheDependency enabled="true" pollTime="500">
<databases>
<add name=" PortalDB "
connectionStringName=" SqlServerConnectionString " />
Ïà¹ØÎĵµ£º
asp.netʵÏÖÊ¡ÊÐÁª¶¯²¢ÇÒ±£´æ×´Ì¬£¬ÊµÏÖÔÀí£º³õ´ÎʹÓÃC#´«Í³µÄDataBind½øÐÐÊý¾Ý°ó¶¨£¬Ñ¡ÔñÊ¡£¬Êкó½øÐÐajax·½Ê½¼ÓÔØÏ¼¶ÁÐ±í£¬²¢½«Ñ¡¶¨Öµ±£´æµ½HiddenÖУ¬µã»÷Ìá½»ºó¸ù¾ÝHiddenµÄÖµ½øÐÐÊ¡£¬Êа󶨣¬ÔÙ½«HiddenµÄÖµ¸³¸øDropDownListµÄSelectedValue£¬´Ó¶øÊµÏÖ״̬µÄ±£´æ¡£
HTML´úÂë
<asp:HiddenField ID="HiddenField ......
¿ª·¢»·¾³:WIN XP VS2005
Êý¾Ý¿â:SQL server 2000
´Ë´¦²»¿¼Âǰ²È«ÎÊÌâ.
¾ßÌåÈçÏÂ:
Ê×ÏȽ¨Á¢Ò»¸öÊý¾Ý¿âºÍÒ»¸ö±í½á¹¹²¢ÔÚ±íÖÐÊäÈëһЩÊý¾ÝÒÔ±ã²âÊÔ:´Ë²½ÂÔ¹ý
´ò¿ªVS2005н¨Ò»¸öÍøÕ¾²¢Ìí¼ÓÒ»¸öHTMLÒ³
ÔÚĬÈϵÄDefault.aspxÖзÅÈëGridview¿Ø¼þÓÃÓÚÏÔʾÊý¾Ý
.cs´úÂë
using System;
using System.Data;
usi ......
----------------------ModalPopupExtender
D:\sourceforge\asp.net\AjaxControlToolkit_net20\SampleWebSite\ModalPopup\ModalPopup.aspx
// linkbutton1Ôö¼ÓÀ©Õ¹ModalPopupExtenderÊôÐÔ:
<asp:LinkButton ID="LinkButton1" runat="server" Text="Click here to change the paragraph styl ......
ASP.NET ProfileÊôÐÔ
×÷Óãº
´æ´¢ºÍʹÓÃΨһÓëÓû§¶ÔÓ¦µÄÐÅÏ¢
Õ¹ÏÖ¸öÈË»¯°æ±¾µÄWebÓ¦ÓóÌÐò
Óû§µÄΨһÉí·Ý±êʶÔÚÔٴηÃÎÊʱʶ±ðÓû§
ASP.NET ProfileÈçºÎ¹¤×÷
ÄãµÄWebÓ¦ÓóÌÐòÔËÐÐʱ£¬ASP.NET´´½¨Ò»¸ö´ÓProfileBaseÀද̬¼Ì³ÐÏÂÀ´µÄ¶¯Ì¬Éú³É³öÀ´µÄProfileCommonÀà¡£¶¯Ì¬ProfileCommonÀà°üº¬ÁËÄãÔÚWebÓ¦ÓóÌÐòÅäÖÃÎļ ......