½âÎö_Net¿ò¼ÜϵÄXML±à³Ì¼¼Êõ
½âÎö_Net¿ò¼ÜϵÄXML±à³Ì¼¼Êõ
Ò»£®Ç°ÑÔ£º
XMLÊÇ΢Èí.NetÕ½ÂÔµÄÒ»¸öÖØÒª×é³É²¿·Ö£¬¶øÇÒËü¿ÉνÊÇXML Web·þÎñµÄ»ùʯ£¬ËùÒÔÕÆÎÕ.Net¿ò¼ÜϵÄXML¼¼Êõ×ÔÈ»ÏԵ÷dz£ÖØÒªÁË¡£±¾ÎĽ«Ö¸µ¼´ó¼ÒÈçºÎÔËÓÃC#ÓïÑÔÍê³É.Net¿ò¼ÜϵÄXMLÎĵµµÄ¶Áд²Ù×÷¡£Ê×ÏÈ£¬ÎÒ»áÏò´ó¼Ò½éÉÜ.Net¿ò¼ÜÖÐÓëXMLÏà¹ØµÄÃüÃû¿Õ¼äºÍÆäÖеÄÖØÒªÀà¡£Æä´Î£¬ÎÒ»¹»á¸ø³öÓйصÄʵÀýÒÔʹ¶ÁÕ߸ü½øÒ»²½µÄÁ˽âXMLÎĵµµÄ¶Áд²Ù×÷µÄ¾ßÌå·½·¨¡£
¶þ£®XMLÃüÃû¿Õ¼äºÍÏà¹ØÀà¼ò½é£º
ÔÚÉîÈë½øÐÐ.Net¿ò¼ÜϵÄXMLÎĵµµÄ²Ù×÷֮ǰ£¬ÎÒÏëºÜÓбØÒªÏò´ó¼Ò½éÉÜ.Net¿ò¼ÜÖÐÓëXML¼¼ÊõÓйصÄÃüÃû¿Õ¼äºÍÆäÖÐÒ»Ð©ÖØÒªµÄÀà¡£.Net¿ò¼ÜΪÎÒÃÇÌṩÁËÒÔÏÂһЩÃüÃû¿Õ¼ä£ºSystem.Xml¡¢System.Xml.Schema¡¢System.Xml.Serialization¡¢System.Xml.XpathÒÔ¼° System.Xml.XslÀ´°üÈݺÍXML²Ù×÷Ïà¹ØµÄÀà¡£
- System.XmlÃüÃû¿Õ¼ä°üº¬ÁËһЩ×îÖØÒªµÄXMLÀ࣬ÆäÖÐ×îÖ÷ÒªµÄÀàÊǺÍXMLÎĵµµÄ¶Áд²Ù×÷Ïà¹ØµÄÀà¡£ÕâЩÀàÖаüÀ¨4¸öÓë¶ÁÏà¹ØµÄÀàÒÔ¼°2¸öÓëдÏà¹ØµÄÀà¡£ËüÃÇ·Ö±ðÊÇ£ºXmlReader¡¢XmlTextReader¡¢XmlValidatingReader¡¢XmlNodeReader¡¢XmlWriterÒÔ¼° XmlTextWriter¡£±¾ÎĽ«Öصã½éÉÜÕâЩÀ࣬ÒòΪËüÃÇÊÇ×î»ù±¾Ò²ÊÇ×îÖØÒªµÄÀà¡£
- XmlReaderÀàÊÇÒ»¸öÐé»ùÀ࣬Ëü°üº¬Á˶ÁXMLÎĵµµÄ·½·¨ºÍÊôÐÔ¡£¸ÃÀàÖеÄRead·½·¨ÊÇÒ»¸ö»ù±¾µÄ¶ÁXMLÎĵµµÄ·½·¨£¬ËüÒÔÁ÷ÐÎʽ¶ÁÈ¡XMLÎĵµÖеĽڵ㣨Node£©¡£ÁíÍ⣬¸ÃÀ໹ÌṩÁËReadString¡¢ReadInnerXml¡¢ReadOuterXmlºÍReadStartElementµÈ¸ü¸ß¼¶µÄ¶Á·½·¨¡£³ýÁËÌṩ¶ÁXMLÎĵµµÄ·½·¨Í⣬XmlReaderÀ໹Ϊ³ÌÐòÔ±ÌṩÁËMoveToAttribute¡¢MoveToFirstAttribute¡¢MoveToContent¡¢MoveToFirstContent¡¢MoveToElementÒÔ¼° MoveToNextAttributeµÈ¾ßÓе¼º½¹¦Äܵķ½·¨¡£ÔÚ±¾ÎĺóÃæ½éÉܵÄʵÀýÖУ¬ÎÒÃǽ«ÔËÓõ½ÕâЩ·½·¨¡£
- XmlTextReader¡¢XmlNodeReaderÒÔ¼°XmlValidatingReaderµÈÀàÊÇ´ÓXmlReaderÀà¼Ì³Ð¹ýÀ´µÄ×ÓÀà¡£¸ù¾ÝËüÃǵÄÃû³Æ£¬ÎÒÃÇ¿ÉÒÔÖªµÀÆä×÷Ó÷ֱðÊǶÁÈ¡Îı¾ÄÚÈÝ¡¢¶ÁÈ¡½ÚµãºÍ¶ÁÈ¡XMLģʽ£¨Schemas£©¡£
- XmlWriterÀàΪ³ÌÐòÔ±ÌṩÁËÐí¶àдXMLÎĵµµÄ·½·¨£¬ËüÊÇXmlTextWriterÀàµÄ»ùÀ࣬ÎÒÔÚºóÃæµÄʵÀýÖÐ»á¸ø³öÏà¹ØµÄÔËÓ÷½·¨¡£
- XmlNodeÀàÊÇÒ»¸ö·Ç³£ÖØÒªµÄÀ࣬Ëü´ú±íÁËXMLÎĵµÖеÄij¸ö½Úµã¡£¸Ã½Úµã¿ÉÒÔÊÇXMLÎĵµµÄ¸ù½Úµã£¬ÕâÑùËü¾Í´ú±íÕû¸öXMLÎĵµÁË¡£ËüÊÇÐí¶àºÜÓÐÓõÄÀàµÄ»ùÀ࣬ÕâЩÀà°üÀ¨²åÈë½ÚµãµÄÀࡢɾ³ý½Úµã
Ïà¹ØÎĵµ£º
JAXB¸ÅÒª
JAXBΪJava Architecture for XML BindingµÄËõд£¬ÒâΪXML°ó¶¨µÄJAVA¿ò¼Ü¡£ËüÌṩÁËÒ»Ì׿ÉÒÔ¼òµ¥´æÈ¡XMLÊý¾ÝµÄAPI£¬Í¬Ê±£¬JAXB¿ÉÒÔ¸ù¾ÝXMLµÄschema×Ô¶¯Éú³É²Ù×÷XMLµÄJAVAÀà¡£ÀûÓÃJAXB£¬Ê¹ÓÃJAXB×Ô¶¯Éú³ÉµÄ²Ù×÷XMLµÄJAVAÀ࣬¿ÉÒÔ»ù±¾Éϲ»Óÿ¼ÂÇXML½á¹¹¶ø¼òµ¥µØ´æÈ¡XMLÊý¾Ý¡£
JAXBµÄÏÂÔØÓë°²×°
JAXBÖÁÉÙÐèÒªµ¼ÈëÒ ......
Ò»¡¢¼òµ¥½éÉÜ
using System.Xml;
//³õʼ»¯Ò»¸öxmlʵÀý
XmlDocument xml=new XmlDocument();
//µ¼ÈëÖ¸¶¨xmlÎļþ
xml.Load(path);
xml.Load(HttpContext.Current.Server.MapPath("~/file/bookstore.xml"));
//Ö¸¶¨Ò»¸ö½Úµã
XmlNode root=xml.SelectSingleNode("/root");
//»ñÈ¡½ÚµãÏÂËùÓÐÖ±½Ó×Ó½Úµã
XmlNodeList ......
ʹÓÃXmlDocumentÀàÍê³É¶ÔXMLµÄ²é¡¢É¾¡¢Ìí¡¢¸Ä
http://www.aspdiy.net/article/53.htm
ºǫ́C#´úÂë
1using System;
2using System.Collections;
3using System.ComponentModel;
4using System.Data;
5using System.Drawing;
6using System. ......
MSDNÉϵ͍Ò壺
XML ÐòÁл¯½«¶ÔÏóµÄ¹«¹²×ֶκÍÊôÐÔ»òÕß·½·¨µÄ²ÎÊýºÍ·µ»ØÖµ×ª»»£¨ÐòÁл¯£©Îª·ûºÏÌØ¶¨ XML ¼Ü¹¹¶¨ÒåÓïÑÔ (XSD) ÎĵµµÄ XML Á÷¡£XML ÐòÁл¯Éú³ÉÇ¿ÀàÐ͵ÄÀ࣬²¢Îª´æ´¢»ò´«ÊäÄ¿µÄ½«Æä¹«¹²ÊôÐÔºÍ×Ö¶Îת»»ÎªÐòÁиñʽ£¨ÔÚ´ËÇé¿öÏÂΪ XML)¼òµ¥µÄ˵¾ÍÊǽ«Ò»¸ö¶ÔÏóת»»³ÉXMLÁ÷»òÊÇÎļþµÄ¹ý³Ì¡£
×¢ÒâÊÂÏҪÐòÁл¯µÄÀ ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
create procedure [dbo].[MachiningPayedGetListByCondition]
@CustomerName varchar(50),
@CustomerPhone varchar(50),
@PactNumber varchar(50),
@Ispay bit
as
begin
set nocount on;
SELECT
dp.ID as 'MachiningPayed/@ID',
&nbs ......