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 ÌṩÈýÖÖÓÃÓÚÔÚ³öÏÖ´íÎóʱ²¶»ñºÍÏìÓ¦´íÎóµÄÖ÷Òª·½·¨£ºPage_Error ʼþ¡¢Application_Error ʼþÒÔ¼°Ó¦ÓóÌÐòÅäÖÃÎļþ (Web.config)¡£
Èç¹ûÄú²»µ÷Óà Server.ClearError »òÕß²¶»ñ Page_Error »ò Application_Error ʼþÖеĴíÎó£¬Ôò½«¸ù¾Ý Web.config ÎļþµÄ <customErrors> ²¿·ÖÖеÄÉèÖô¦Àí´íÎó¡£ÔÚ & ......
1.Á¬½ÓÊý¾Ý¿âÎļþ
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
SqlConnectionStringBuilderʵÀý»¯Ê±£¬ÒªÓõ½connectionString£¬È磺SqlConnectionStringBuild builder = new SqlC ......
ͨ¹ý SqlDataSource ¿Ø¼þ£¬¿ÉÒÔʹÓà Web ·þÎñÆ÷¿Ø¼þ·ÃÎÊλÓÚ¹ØÏµÊý¾Ý¿âÖеÄÊý¾Ý¡£ÆäÖпÉÒÔ°üÀ¨ Microsoft SQL Server ºÍ Oracle Êý¾Ý¿âÒÔ¼° OLE DB ºÍ ODBC Êý¾ÝÔ´¡£Äú¿ÉÒÔ½« SqlDataSource ¿Ø¼þÓëÊý¾Ý°ó¶¨¿Ø¼þ£¨Èç GridView¡¢FormView ºÍ DetailsView ¿Ø¼þ£©Ò»ÆðʹÓã¬Óü«ÉÙ´úÂë»òÉõÖÁ² ......
using System.Xml;//Í·²¿¼Ó´ËÃüÃû¿Õ¼ä
XmlDocument xd = new XmlDocument();//±íʾXMLÎĵµ
XmlDeclaration xde;//±íʾ XML ÉùÃ÷½Úµã£º<?xml version='1.0'...?>
xde = xd.Cre ......