XML code:
<?xml version="1.0" encoding="utf-8"?>
<info>
<status>ok</status>
<error/>
<item><uid>1</uid><email>111@163.com</email></item>
<item><uid>2</uid><email></email></ ......
ÎÒÓÐÒ»¸öXML Îļþ£¬Ïë°ÑÆä±êÇ©È¡³öÀ´£¬Æ´³É×Ö·û´®¡£ÏÂÃæÊÇtest.xmlÎļþºÍ´úÂë
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pacs.008.001.02">
<FIToFICstmrCdtTrf>
<GrpHdr>
<MsgId>0000000000000000000000000001</MsgId>
<CreDtTm>2001-12-17T09:30:47 ......
ÓÃEXCEl¶ÁÈ¡ÍøÂçXMLÊý¾Ý£¬Êý¾ÝÌì±ä»¯£¬ÍøÖ·ÏàӦΪ******20100102£¬²»ÖªµÀÔõô¶¯Ì¬¶ÁÈ¡
ÎÒҲûÓп´Ã÷°×ÄãµÄÎÊÌâ
Óúê¿ÉÒÔ¼òµ¥¶ÁÈ¡xmlµÄÊý¾ÝÖÁExcel£¬µ«ÒªÊäÈëµØÖ·£¬ÎÒµÄÕâ¸öµØÖ·ÊÇËæʱ¼ä¹æÂɱ仯µÄ£¬ÏëÓóÌÐò×ö¡£Sub Ma()
mytime = Format(Now, "yyyymmddhh")
Workbooks.OpenXML Filename:="htt ......
DataSet ds;
string aa=ds.getXml();
Ôõô°Ñaaµ¼ÈëÁíÒ»¸ödataSet?
1Â¥Õý½â.
¿ÉÒÔ°Ñxml±£´æΪÎļþ
Ds.WriteXml(Server.MapPath("Test.xml"),XmlWriteMode.WriteSchema);
Ds.ReadXml(Server.MapPath("Test.xml"));
......
ÎÒ¸Õ¸ÕÈ¥½Ó´¥XML¸Ð¾õËü²»¾ÍÊǸöÎı¾ÐÎʽµÄÊý¾Ý¿â°¡£¿ÎªÊ²Ã´²»Ö±½Ó°ÑÊý¾Ý´æµ½Êý¾Ý¿â¶ø´æÔÚxmlÀïÄØ£¿»¹ÊǸоõÓÃDOMÈ¥·ÃÎÊÐ޸Ľڵ㲻̫·½±ã°¡¡£¡£¡£Êý¾Ý¿âÖ±½ÓÒ»¸öSQLÓï¾ä¾ÍÓÐÁË ¶à·½±ã ΪʲôҪ³öÏÖ¸öxmlÄØ£¿¶î¡£¡£¡£²»ÒªÂîÎÒ ÎÒûÓÐÆçÊÓËüµÄÒâ˼ ¾ÍÊÇÒ»¸öÐÂÊֵĺÃÆæ
Óëflash·½ÃæµÄÊý¾Ý½»»¥Í¦³£ÓÃʵÓõÄ.... Õâ¸öÎÒ³£Ó㬠......
xmlÎĵµ£º
<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE sonnet SYSTEM "XmlDomDemo.dtd">
<sonnet type="tfnew21">
<author>
<last-name>Ìì·é</last-name>
<first-name>Èý·å</first-name>
<nationality>±±¹ ......