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

´ÓJCOµ½SAPµÄIDOCµÄxml¸ñʽ

      <?xml version="1.0"?>
    <BANK_CREATE01>  
        <IDOC BEGIN="1">   
            <EDI_DC40 SEGMENT="1">    
                <TABNAM>EDI_DC40</TABNAM>    
                <MANDT>110</MANDT>    
                <DOCNUM>1</DOCNUM>    
                <DOCREL>710</DOCREL>    
                <DIRECT>2</DIRECT>    
                <IDOCTYP>BANK_CREATE01</IDOCTYP>    
                <MESTYP>BANK_CREATE</MESTYP>    
                <SNDPOR>A000000005</SNDPOR>   
                <SNDPRT>LS</SNDPRT>    
                <SNDPRN>E8DJCO</SNDPRN>    
                <RCVPOR>SAPE8D</RCVPOR>    
                <RCVPRT>LS</RCVPRT>     
  


Ïà¹ØÎĵµ£º

JAVAÓëXML_¶ÁÊé±Ê¼Ç_2010 05 14

JAVATMÓëXML 2010-05-14
Ò»¡¢¸ÅÄî
l  ÈκÎXMLÎĵµ¶ÔÈκÎÀàÐ͵ÄÓ¦ÓÃÒÔ¼°ÕýÈ·µÄ½âÎö¶¼±ØÐë¾ßÓÐÁ¼ºÃµÄ½á¹¹well-formed
l  XMLÎĵµ¿ÉÒÔÊÇÓÐЧµØ£¨valid£©£¬µ«²¢·ÇÒ»¶¨ÒªÇóÓÐЧ¡£
l  PI£¨processing instruction£©¸ñʽ£º<?target instructions?>¡£XMLÖеĴ¦ÀíÖ¸ÁîÖ»ÄÜÊǽâÎöÆ÷¿ÉÒÔʶ±ðµÄXML±ê×¼´¦ÀíÃüÁ ......

sqlserver FOR XML PATH Óï¾äµÄÓ¦ÓÃ

´úÂëÈçÏÂ:

DECLARE
@TempTable table(UserID int , UserName nvarchar(50));
insert into
@TempTable (UserID,UserName) values (1,'a')
insert into @TempTable
(UserID,UserName) values (2,'b')

select UserID,UserName
from @TempTable FOR XML PATH
ÔËÐÐÕâ¶Î½Å±¾£¬½«Éú³ÉÈçϽá¹û£º
¸´ÖÆ´úÂë ......

C#¶ÁÈ¡º¬ÓÐxmlnsµÄXMLÎļþ

1 ÀàËÆxmlns=""µÄÎļþ
ʾÀýXMLÎļþ:
 <?xml version="1.0" encoding="UTF-8"?>
<WebSrvMessage xmlns="http://www.lenoval.com/">
  <version>1.0</version>
  <DataContent>
    <DateTag>2010-5-17</DateTag>
  </DataCont ......

VB.NET2005¶ÁÈ¡XMLÊý¾Ý

ͨ¹ýµ÷ÓÃCreateDataSetfromXmlÈ¡µÃXMLÊý¾Ý
Imports System.Xml
Public Const FILE_CONFIG = "MZZ.xml"
Public Const PATH_CONFIG = "\XML\"
Dim dstXML As DataSet
Dim tblXML_DB As DataTable
Dim dtCod As New DataTable
Dim strSQL As String = ""

clsPublic ......

Ò»¸ö¿ÉÒÔ´ÓexcelÖжÁÈ¡Êý¾Ý²¢Éú³ÉxmlµÄvba³ÌÐò

NND EXCEL2007£¬ÈÃÀÏ×ÓÕÒÁË°ëÌì²Å°ÑbuttonÌí¼ÓÉÏÈ¥¡£
Sub °´Å¥1_Click()
 
    Dim sFileName As String          
    Dim ws As Worksheet               ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ