Vistual Studio XML ÖÇÄÜÌáʾ
¿ª·¢Öо³£Óöµ½ÒªºÍ¸÷ÖÖ¸÷ÑùµÄ XML ´ò½»µÀ£¬±à¼ XML Îļþʱ×îÍ·Í´µÄ±ãÊÇÒª¼ÇסÐí¶à XML ÔªËØÃû³Æ¡¢ÊôÐÔÃû³Æ¡£
ÐÒÔ˵ÄÊÇ£¬Vistual Studio µÄ XML ÖÇÄÜÌáʾ¹¦ÄÜ¿ÉÒÔ´ó´óµØ¼õÇáÕâһʹ¿à¡£Ö»Ðèͨ¹ýÌí¼Ó×Ô¶¨ÒåµÄ XSD ÎļþʹµÃÔڱ༠XML Îļþʱ»ñµÃVSµÄÖÇÄÜÌáʾ£¬ÏÂÃæÒÔ VS2008 ΪÀý£º
µÚÒ»²½£º½« XSD Îļþ Copy µ½VS°²×°Ä¿Â¼Ï嵀 \Xml\Schemas Ŀ¼Ï£¬ÔÚ±¾ÈË»úÆ÷ÉÏÕâһ·¾¶Îª£ºE:\Program Files\Microsoft Visual Studio 9.0\Xml\Schemas ¡£
µÚ¶þ²½£º´´½¨ XML Îļþ£¬±à¼¸ù½ÚµãµÄ xmlns ÊôÐÔÉèÖÃÓë XSD ¶ÔÓ¦µÄÖµ¼´¿É×Ô¶¯¹ØÁªµ½ XSD Îļþ£¬ÀýÈ磺xmlns="http://ibatis.apache.org/mapping" ¡£»òÕßÒ²¿ÉÒÔͨ¹ý VS µÄ XML ±à¼Æ÷´ò¿ªXMLÎļþºó£¬ÊÖ¶¯ÔÚ“ÊôÐÔ”Öеē¼Ü¹¹”Ò»À¸Ö¸¶¨ XSD Îļþ¡£
¾¹ýÒÔÉÏÁ½²½±ãÍê³ÉÁËÅäÖ㬵«ÊÇҪעÒâ±ÜÃâÒÔÏÂÁ½ÖÖÇéÐε¼ÖÂXMLÖÇÄÜÌáʾʧЧ£º
1¡¢²»ÄÜÔÚ \Xml\Schemas Ŀ¼ÏÂÓжà¸önamespace ÏàͬµÄ XSD Îļþ£»
2¡¢½â¾ö·½°¸Öв»Äܰüº¬ÈκξßÓÐÏàͬ namespace µÄ XSD Îļþ£»
µ± xmlns ÊôÐÔÖ¸¶¨µÄÖµ¶ÔÓ¦Á˶à¸ö xsd Îļþʱ£¬Vistual Studio ²»»áÌáʾÈκδíÎó£¬Ö»ÊÇÔÚÖÇÄÜÌáʾµÄÏÂÀÁбíÖв»»áÁгö¶ÔÓ¦µÄ XML ÔªËØÃû³Æ¡£
Ïà¹ØÎĵµ£º
ref : http://blog.csdn.net/High_Mount/archive/2008/09/19/2953335.aspx
תÒå×Ö·û
²»ºÏ·¨µÄXML×Ö·û±ØÐë±»Ìæ»»ÎªÏàÓ¦µÄʵÌå¡£
Èç¹ûÔÚXMLÎĵµÖÐʹÓÃÀàËÆ"<" µÄ×Ö·û, ÄÇô½âÎöÆ÷½«»á³öÏÖ´íÎó£¬ÒòΪ½âÎöÆ÷»áÈÏΪÕâÊÇÒ»¸öÐÂÔªËØµÄ¿ªÊ¼¡£ËùÒÔ²»Ó¦¸ÃÏóÏÂÃæÄÇÑùÊéд´úÂë:
<message>if salary < 1000 then</me ......
ÒÑÖªÓÐÒ»¸öXMLÎļþ£¨bookstore.xml£©ÈçÏ£º
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price& ......
USE Test
--Create 2 tables as an example
CREATE TABLE ExampleTable
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
CREATE TABLE ExampleTable2
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
----way1
SELECT *
from sys.objects [table]
WHERE
[Name] LIKE 'ExampleTable%'
FOR XML AUTO, ROOT ......
PHP´ÓPHP5¿ªÊ¼£¬³¹µ×ÖØÐ±àдµÄºÍÐÂÔöÁ˶ÔXMLµÄÀ©Õ¹£¬Èç SAX ½âÎöÆ÷¡¢DOM¡¢SimpleXML¡¢XMLReader¡¢XMLWriter ºÍ XSLT ´¦Àí³ÌÐò¡£ËùÓÐÕâЩÀ©Õ¹¶¼ÒÔ libxml2 Ϊ»ù´¡¡£
=============================
1¡¢DOMDocument¶ÔÏó³£Ó÷½·¨£º
=============================
a£©createElement(elementName)
¸Ã· ......
ÒÔǰÔÚ²©¿ÍÉÏ·¢¹ý£¬¾ÈËÌáÐÑDataSetÒÑ×Ô´ø¶ÁдXMLµÄ¹¦ÄÜ£¬ÓÚÊDZãɾÁË£¬
²»¹ýÔÚʵ¼ùÖиоõ·â×°Ò»²ãºó£¬Ê¹ÓÃÆðÀ´»¹ÊÇÂù·½±ãµÄ¡£¹ÊÔÙ´ÎÖØ·¢¡£
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.IO;
using System.Xml;
namespace XmlDesign
{
class XmlDatasetC ......