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

ASP.NET


      SqlDataSource ¿Ø¼þ¿É¶ÔËü¼ìË÷¹ýµÄÊý¾Ý½øÐлº´æ£¬ÕâÑù¿ÉÒÔ±ÜÃâÔÙ´ÎÔËÐÐ×ÊÔ´ÏûºÄÁ¿½Ï´óµÄ²éѯ£¬´Ó¶øÌá¸ßÓ¦ÓóÌÐòµÄÐÔÄÜ¡£»º´æÖ÷ÒªÓÃÓÚÊý¾Ý±ä»¯²»Æµ·±µÄÇé¿ö¡£
´ËÍ⣬µ±Í¨¹ý System.Data.SqlClient Ìṩ³ÌÐòʹÓà SqlDataSource ¿Ø¼þʱ£¬¿ÉÒÔʹÓà SqlCacheDependency ¶ÔÏó¡£ÕâÑù¿Éʹ SqlDataSource ¿Ø¼þ½öÔÚ SelectCommand ·µ»ØµÄÊý¾ÝÔÚÊý¾Ý¿âÖб»ÐÞ¸Äʱ²Åˢлº´æ¡£
 
Ò»¡¢Í¨¹ý SqlDataSource ¿Ø¼þÆôÓûº´æ
µ± SqlDataSource ¿Ø¼þµÄ DataSourceMode ÊôÐÔÉèÖÃΪ DataSet ʱ£¬¸Ã¿Ø¼þ¿É¶ÔÊý¾Ý½øÐлº´æ¡£Ä¬ÈÏÇé¿öϲ¢Î´ÆôÓûº´æ£¬µ«¿ÉÒÔͨ¹ý½« EnableCaching ÊôÐÔÉèÖÃΪ true À´ÆôÓûº´æ¡£
½«»ùÓÚÒ»¸öʱ¼ä¼ä¸ô¶Ô»º´æÊý¾Ý½øÐÐˢС£¿ÉÒÔ½« CacheDuration ÊôÐÔÉèÖÃΪˢлº´æÖ®Ç°ÒªµÈ´ýµÄÃëÊý¡£SqlDataSource ¿Ø¼þΪÿ¸ö ConnectionString¡¢SelectCommand ºÍ SelectParameters ÖµµÄ×éºÏά»¤Ò»¸öµ¥¶ÀµÄ»º´æÏî¡£
ͨ¹ýÉèÖà CacheExpirationPolicy ÊôÐÔ£¬¿ÉÒÔ½øÒ»²½¿ØÖÆ SqlDataSource »º´æµÄÐÐΪ¡£Absolute Öµ»áÔÚ³¬¹ý CacheDuration ÖµÊ±Ç¿ÖÆË¢Ð»º´æ¡£½« CacheExpirationPolicy ÊôÐÔÉèÖÃΪ Sliding£¬Ôò½öÔÚ´Ó×îºóÒ»´Î·ÃÎÊ»º´æÏîÆð³¬¹ý CacheDuration ÖµÖ®ºó²Å¶Ô»º´æ½øÐÐˢС£
ÏÂÃæµÄ´úÂëʾÀýÑÝʾһ¸ö SqlDataSource ¿Ø¼þ£¬¸Ã¿Ø¼þÅäÖÃΪÿ 20 ÃëË¢ÐÂÒ»´ÎÊý¾Ý£º
<%@ Page language="C#" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html  >
    <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
        <form id="form1" runat="server">
 
            <asp:SqlDataSource
                id="SqlDataSource1"
                runat="server"
                DataSourceMode="DataSet"
    &nb


Ïà¹ØÎĵµ£º

ASP.NET×Ô¶¨Òå´íÎóÒ³Ãæ

 ASP.NET ÌṩÈýÖÖÓÃÓÚÔÚ³öÏÖ´íÎóʱ²¶»ñºÍÏìÓ¦´íÎóµÄÖ÷Òª·½·¨£ºPage_Error ʼþ¡¢Application_Error ʼþÒÔ¼°Ó¦ÓóÌÐòÅäÖÃÎļþ (Web.config)¡£
Èç¹ûÄú²»µ÷Óà Server.ClearError »òÕß²¶»ñ Page_Error »ò Application_Error ʼþÖеĴíÎó£¬Ôò½«¸ù¾Ý Web.config ÎļþµÄ <customErrors> ²¿·ÖÖеÄÉèÖô¦Àí´íÎó¡£ÔÚ & ......

Ïê½âAsp.Net SqlÊý¾Ý¿âÁ¬½Ó×Ö·û´®


1.Á¬½ÓÊý¾Ý¿âÎļþ
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
SqlConnectionStringBuilderʵÀý»¯Ê±£¬ÒªÓõ½connectionString£¬È磺SqlConnectionStringBuild builder = new SqlC ......

ASP.NET


      ͨ¹ý SqlDataSource ¿Ø¼þ£¬¿ÉÒÔʹÓà Web ·þÎñÆ÷¿Ø¼þ·ÃÎÊλÓÚ¹ØÏµÊý¾Ý¿âÖеÄÊý¾Ý¡£ÆäÖпÉÒÔ°üÀ¨ Microsoft SQL Server ºÍ Oracle Êý¾Ý¿âÒÔ¼° OLE DB ºÍ ODBC Êý¾ÝÔ´¡£Äú¿ÉÒÔ½« SqlDataSource ¿Ø¼þÓëÊý¾Ý°ó¶¨¿Ø¼þ£¨Èç GridView¡¢FormView ºÍ DetailsView ¿Ø¼þ£©Ò»ÆðʹÓã¬Óü«ÉÙ´úÂë»òÉõÖÁ² ......

asp.net ²Ù×÷xmlÎļþ

using System.Xml;//Í·²¿¼Ó´ËÃüÃû¿Õ¼ä
        XmlDocument xd = new XmlDocument();//±íʾXMLÎĵµ
        XmlDeclaration xde;//±íʾ XML ÉùÃ÷½Úµã£º<?xml version='1.0'...?>
        xde = xd.Cre ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ