Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ʵÏÖÊ¡ÊÐÇø¼¶ÁªÏÂÀ­ÁÐ±í²¢±£´æ×´Ì¬

asp.netʵÏÖÊ¡ÊÐÁª¶¯²¢ÇÒ±£´æ×´Ì¬£¬ÊµÏÖÔ­Àí£º³õ´ÎʹÓÃC#´«Í³µÄDataBind½øÐÐÊý¾Ý°ó¶¨£¬Ñ¡ÔñÊ¡£¬Êкó½øÐÐajax·½Ê½¼ÓÔØÏ¼¶ÁÐ±í£¬²¢½«Ñ¡¶¨Öµ±£´æµ½HiddenÖУ¬µã»÷Ìá½»ºó¸ù¾ÝHiddenµÄÖµ½øÐÐÊ¡£¬Êа󶨣¬ÔÙ½«HiddenµÄÖµ¸³¸øDropDownListµÄSelectedValue£¬´Ó¶øÊµÏÖ״̬µÄ±£´æ¡£
HTML´úÂë
<asp:HiddenField ID="HiddenField ......

¹ØÓÚASP.netÓëAJAXÓÃgridview½øÊµÏÖÎÞˢв¢·ÖÒ³Ëæ±Ê

¿ª·¢»·¾³:WIN XP   VS2005
Êý¾Ý¿â:SQL server 2000
´Ë´¦²»¿¼Âǰ²È«ÎÊÌâ.
¾ßÌåÈçÏÂ:
Ê×ÏȽ¨Á¢Ò»¸öÊý¾Ý¿âºÍÒ»¸ö±í½á¹¹²¢ÔÚ±íÖÐÊäÈëһЩÊý¾ÝÒÔ±ã²âÊÔ:´Ë²½ÂÔ¹ý
´ò¿ªVS2005н¨Ò»¸öÍøÕ¾²¢Ìí¼ÓÒ»¸öHTMLÒ³
ÔÚĬÈϵÄDefault.aspxÖзÅÈëGridview¿Ø¼þÓÃÓÚÏÔʾÊý¾Ý
.cs´úÂë
using System;
using System.Data;
usi ......

asp.net ajax, ASPxCallBackѧϰ

----------------------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ÊôÐÔ

ASP.NET ProfileÊôÐÔ
×÷Óãº
´æ´¢ºÍʹÓÃΨһÓëÓû§¶ÔÓ¦µÄÐÅÏ¢
Õ¹ÏÖ¸öÈË»¯°æ±¾µÄWebÓ¦ÓóÌÐò
Óû§µÄΨһÉí·Ý±êʶÔÚÔٴηÃÎÊʱʶ±ðÓû§
ASP.NET ProfileÈçºÎ¹¤×÷
ÄãµÄWebÓ¦ÓóÌÐòÔËÐÐʱ£¬ASP.NET´´½¨Ò»¸ö´ÓProfileBaseÀද̬¼Ì³ÐÏÂÀ´µÄ¶¯Ì¬Éú³É³öÀ´µÄProfileCommonÀà¡£¶¯Ì¬ProfileCommonÀà°üº¬ÁËÄãÔÚWebÓ¦ÓóÌÐòÅäÖÃÎļ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ