XML轉DataSet¡¢DataTable
ÎÒÏëÒªÒ»個ͨÓõÄxml轉DataTable£¬xmlÎļþ來×Ô²»Í¬µÄÎÄ檔£¬
ÀýÈ磺excelÎÄ檔Áí´æ為xmlÎÄ檔Ôõô°Ñ這個xmlÎÄ檔轉換³ÉDataSet¡¢DataTable,
ÒÔϾÍÊÇÎÒµÄXMLÎÄ檔£¬ÊÇͨ過excel轉µÄ£¬µ«ÊÇ轉DataTableÀÏÊÇʧ敗£¬讀²»µ½數據
XML code
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Created>1996-12-17T01:32:42Z </Created>
<LastSaved>2009-11-03T08:14:23Z </LastSaved>
<Version>11.5606 </Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<RemovePersonalInformation/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>4530 </WindowHeight>
&nbs
Ïà¹ØÎÊ´ð£º
ÐèÒª¼æÈÝie firefox safari µÈä¯ÀÀÆ÷
IE ¿ÉÒÔÓÃFSO µ«ÊÇÔÚÆäËûä¯ÀÀÆ÷²»ÄÜÓÃ
Ò»°ãµÄä¯ÀÀÆ÷´¦ÓÚ°²È«¿¼ÂǶ¼²»ÔÊÐíJavaScript¶Áд±¾µØÎļþµÄ°É
XMLÎĵµÄÚÈÝÈçÏ£¨user.xml£©£º
<?xml version="1.0&qu ......
ÔÚ¿´Ò»¶ÎAS´úÂëʱÓöµ½¼¸¸öÒÉÎÊ¡£
ÔÚFlashÖеÄXML¶ÔÏóòËÆÓÐÒ»¸öchildÊôÐÔ
ÇëÎÊ
1.childÊôÐÔºÍchildNodesÓÐʲôÇø±ð£¿
2.ASÖÐÓÐintÊý¾ÝÀàÐÍÂð£¿AS3.0ÖÐÓÐÂð£¿
´úÂëÖÐÓõ½ÁË´ËÀàÐÍ¡£
3._name¡¢_pare ......
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
ÒÔÏ´úÂëÔÚIEÏÂÊÇ¿ÉÒÔÕý³££¬µ«ÊÇÓÃNETBOX·â×°¾Í²»ÐÐÁË£¬ÔËÐе½ºìÉ«µÄµØ·½¾Í³ö´íÁË£¬ËµÈ±ÉÙ¶ÔÏñ£¬ÇëÎÊÔõôÑùÐ޸ġ£
JScript code:
//////////////////// AJAXÀà////////////////
function getxml ......
ÎÒÔÚʹÓÃDom¶ÁxmlÎļþʱÓöµ½Ò»¸öÎÊÌ⣬¾ÍÊǵ±123.xmlÎļþ²»´æÔÚʱ£¬load(123.xml)¾Í±¨´í£¬ÔõôÑù²ÅÄÜÅжÏÕâ¸öÎļþÊÇ·ñ´æÔÚ°¡£¬ÎÒÒªµÄÊÇ´æÔÚʱ¾Í¶ÁÈ¡£¬²»´æÔÚ¾ÍÌø¹ý£¬¼ÌÐøµÄ¶ÁÏÂÒ»¸öxml£¬Çë½Ì¸÷λ´óÏÀ£¬
$file ......