split xmldocument to each datatable

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • David
    #1

    split xmldocument to each datatable

    this is my xml sample:

    <PipPurchaseOrd erConfirmation>
    <A>
    <A1>...</A1>
    <A2>...</A2>
    </A>
    <PurchaseOrde r>
    <PurchaseOrderH eader>
    <OrderNumber>A0 01</OrderNumber>
    <OrderDate>20 05-04-01</OrderDate>
    <PurchaseOrderD etail>
    <ProductLineIte m>
    <LineNumber>1 </LineNumber>
    <ProductNumber> AAA1</ProductNumber>
    <ShipQty>10</ShipQty>
    <LineNumber>2 </LineNumber>
    <ProductNumber> AAA2</ProductNumber>
    <ShipQty>20</ShipQty>
    </ProductLineItem >
    </PurchaseOrderHe ader>
    <PurchaseOrderH eader>
    <OrderNumber>A0 02</OrderNumber>
    <OrderDate>20 05-04-01</OrderDate>
    <PurchaseOrderD etail>
    <ProductLineIte m>
    <LineNumber>1 </LineNumber>
    <ProductNumber> BBB1</ProductNumber>
    <ShipQty>30</ShipQty>
    <LineNumber>2 </LineNumber>
    <ProductNumber> BBB2</ProductNumber>
    <ShipQty>40</ShipQty>
    </ProductLineItem >
    </PurchaseOrderHe ader>
    </PurchaseOrder>
    <B>
    <B1>...</B1>
    </B>
    <C></C>
    </PipPurchaseOrde rConfirmation>

    I want put <PurchaseOrderH eader> nodelist to DataTable1, 2...
    like these:

    [DataTable]
    <PurchaseOrderH eader>
    <OrderNumber>A0 01</OrderNumber>
    <OrderDate>20 05-04-01</OrderDate>
    <PurchaseOrderD etail>
    <ProductLineIte m>
    <LineNumber>1 </LineNumber>
    <ProductNumber> AAA1</ProductNumber>
    <ShipQty>10</ShipQty>
    <LineNumber>2 </LineNumber>
    <ProductNumber> AAA2</ProductNumber>
    <ShipQty>20</ShipQty>
    </ProductLineItem >
    </PurchaseOrderHe ader>

    how should I split them to each DataTable or DataSet?

    P.s
    Because the xml document contain several same-name table, so I can not
    put whole to one dataset.

    Thanks for any advice, David.

    Tags: None
    • VC# Jones
      #2
      RE: split xmldocument to each datatable

      Use XPath Expressions

      "David" wrote:
      [color=blue]
      > this is my xml sample:
      >
      > <PipPurchaseOrd erConfirmation>
      > <A>
      > <A1>...</A1>
      > <A2>...</A2>
      > </A>
      > <PurchaseOrde r>
      > <PurchaseOrderH eader>
      > <OrderNumber>A0 01</OrderNumber>
      > <OrderDate>20 05-04-01</OrderDate>
      > <PurchaseOrderD etail>
      > <ProductLineIte m>
      > <LineNumber>1 </LineNumber>
      > <ProductNumber> AAA1</ProductNumber>
      > <ShipQty>10</ShipQty>
      > <LineNumber>2 </LineNumber>
      > <ProductNumber> AAA2</ProductNumber>
      > <ShipQty>20</ShipQty>
      > </ProductLineItem >
      > </PurchaseOrderHe ader>
      > <PurchaseOrderH eader>
      > <OrderNumber>A0 02</OrderNumber>
      > <OrderDate>20 05-04-01</OrderDate>
      > <PurchaseOrderD etail>
      > <ProductLineIte m>
      > <LineNumber>1 </LineNumber>
      > <ProductNumber> BBB1</ProductNumber>
      > <ShipQty>30</ShipQty>
      > <LineNumber>2 </LineNumber>
      > <ProductNumber> BBB2</ProductNumber>
      > <ShipQty>40</ShipQty>
      > </ProductLineItem >
      > </PurchaseOrderHe ader>
      > </PurchaseOrder>
      > <B>
      > <B1>...</B1>
      > </B>
      > <C></C>
      > </PipPurchaseOrde rConfirmation>
      >
      > I want put <PurchaseOrderH eader> nodelist to DataTable1, 2...
      > like these:
      >
      > [DataTable]
      > <PurchaseOrderH eader>
      > <OrderNumber>A0 01</OrderNumber>
      > <OrderDate>20 05-04-01</OrderDate>
      > <PurchaseOrderD etail>
      > <ProductLineIte m>
      > <LineNumber>1 </LineNumber>
      > <ProductNumber> AAA1</ProductNumber>
      > <ShipQty>10</ShipQty>
      > <LineNumber>2 </LineNumber>
      > <ProductNumber> AAA2</ProductNumber>
      > <ShipQty>20</ShipQty>
      > </ProductLineItem >
      > </PurchaseOrderHe ader>
      >
      > how should I split them to each DataTable or DataSet?
      >
      > P.s
      > Because the xml document contain several same-name table, so I can not
      > put whole to one dataset.
      >
      > Thanks for any advice, David.
      >
      >[/color]

        Comment

        Previous template Next
        Working...