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

Asp.Net XML²Ù×÷»ùÀà(ÐÞ¸Ä,ɾ³ý,ÐÂÔö,´´½¨)

Asp.Net XML²Ù×÷»ùÀà(ÐÞ¸Ä,ɾ³ý,ÐÂÔö,´´½¨)
2009-12-21 16:59
/**********************************************************************************
*
* ¹¦ÄÜ˵Ã÷:XML´¦Àí»ùÀà
* ×÷Õß: Áõ¹¦Ñ«;
* °æ±¾:V0.1(C#2.0);ʱ¼ä:2006-12-13
*
* *******************************************************************************/
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Xml;
using System.Text;
using MSXML2;
namespace EC
{
/// <summary>
/// XML ²Ù×÷»ùÀà
/// </summary>
public class XmlObject : IDisposable
{     
       
//ÒÔÏÂΪµ¥Ò»¹¦Äܵľ²Ì¬Àà
#region ¶ÁÈ¡XMLµ½DataSet
/**************************************************
* º¯ÊýÃû³Æ:GetXml(string XmlPath)
* ¹¦ÄÜ˵Ã÷:¶ÁÈ¡XMLµ½DataSet
* ²Î    Êý:XmlPath:xmlÎĵµÂ·¾¶
* ʹÓÃʾÁÐ:
*          using EC; //ÒýÓÃÃüÃû¿Õ¼ä
*          string xmlPath = Server.MapPath("/EBDnsConfig/DnsConfig.xml"); //»ñÈ¡xml·¾¶
*          DataSet ds = EC.XmlObject.GetXml(xmlPath); //¶ÁÈ¡xmlµ½DataSetÖÐ
************************************************/
/// <summary>
/// ¹¦ÄÜ:¶ÁÈ¡XMLµ½DataSetÖÐ
/// </summary>
/// <param name="XmlPath">xml·¾¶</param>
/// <returns>DataSet</returns>
public static DataSet GetXml(string XmlPath)
{
DataSet ds = new DataSet();
ds.ReadXml(@XmlPath);
return ds;
}
#endregion
        #region ¶ÁÈ¡xmlÎĵµ²¢·µ»ØÒ»¸ö½Úµã
/**************************************************
* º¯ÊýÃû³Æ:ReadXmlReturnNode(string XmlPath,string Node)
* ¹¦ÄÜ˵Ã÷:¶ÁÈ¡xmlÎĵµ²¢·µ»ØÒ»¸ö½Úµã:ÊÊÓÃÓÚÒ»¼¶½Úµã
* ²Î  &


Ïà¹ØÎĵµ£º

ÔÚXMLÀïдSQLÓï¾ä£¨°ÑSQLÓï¾äд½øXMLÀ

ÄãÖªµÀXMLÎļþ°É£¿£¨²»ÖªµÀµÄGOOGLEÈ¥£¡£©ÄÇÄãÌý˵¹ýÔÚXMLÀïÊéдSQLÓï¾äÂ𣿻»¾ä»°Ëµ£¬°ÑÄãµÄÏîÄ¿ÀïËùÓÐSQLÓï¾ä´æ´¢ÔÚXMLÎļþÀÄãÌý˵¹ýÂð£¿Äã×ö¹ýÂð£¿
ÎÒÍ·´ÎÌý˵ÊÇС°¬¸æËßÎҵģ¬ÎҸҿ϶¨ËûÊǸöÕâ·½ÃæµÄ¸ßÊÖ£¬ºÇºÇ£¨ÔÞÒ»¸ö£¬µ½´ËΪֹ£¡£©
ÄǸøÄãչʾһÏ£¬ÔÚXMLÀïÊéдSQLÓï¾ä°É
<commands>
  <comman ......

ASP.NET°´Ê±¼ä²éѯ

select  top 6 *  from ViewHouseSale  where  1=1 and  (EstateType='0' or EstateType='1')
and DateDiff(day,PubDate,getdate()) <=7 and IfBenefit='Y' and IfValid='Y'  order by PubDate DESC
select  top 6 *  from ViewHouseSale  where  1=1 and&nb ......

SQL 2005 ASP.NETÊý¾Ý¿âÁ¬½Ó×ܽá

 
VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó×ܽá
    Í¨¹ýÉÏƪÎÄÕ£¨http://www.cnblogs.com/user34j/archive/2007/01/23/628426.html£©µÄÉèÖÃÆäʵÒѾ­²î²»¶àÍê³ÉÁË£¬Ö»ÊÇ»¹ÓÐһЩϸ½ÚµÄµØ·½Ã»ÓÐ×öºÃ£¬¾­¹ýÒ»·¬Ñо¿ÏÖÔÚÖÕÓڸ㶨ÁË¡£¶ÔÓÚÏñÎÒÕâÑùµÄÐÂÊÖÀ´Ëµ£¬Õû¸öÊý¾Ý¿âÁ¬½ÓÕæÊDz»ÈÝÒס£ÏÖ×ܽáÈçÏ£ ......

ASP.NET ¿çÒ³´«µÝ

Ò»¡¢ÏìÓ¦Öض¨Ïò·½·¨
ÏìÓ¦Öض¨Ïò·½·¨ÊÇĿǰΪֹ½«Ò»¸öÍøÒ³Öض¨Ïòµ½ÁíÒ»¸öÍøÒ³µÄ×î¼òµ¥µÄ·½·¨µÄ×î¼òµ¥µÄ·½·¨¡£µ±Web·þÎñÆ÷½Óµ½Ò»¸öÖض¨ÏòÇëÇóºó£¬Ëü»á½«Ò»¸öÏìӦͷË͸ø¿Í»§¶Ë£¬Õ⽫µ¼Ö¿ͻ§¶Ë·¢ËÍÒ»¸öеÄÇëÇóµ½·þÎñÆ÷¡£°´¾ä»°Ëµ£¬Ò»¸öÖض¨ÏòÇëÇóʵ¼ÊÉÏÊÇÁ½¸öÇëÇóÏìÓ¦£ºÒ»¸öÊÇ×î³õµÄÇëÇóÏìÓ¦£¬ÁíÒ»¸öÊÇеÄÖض¨ÏòÇëÇóÏìÓ¦¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ