split xmldocument to each datatable

  • Thread starter Thread starter David
  • Start date Start date
D

David

this is my xml sample:

<PipPurchaseOrderConfirmation>
<A>
<A1>...</A1>
<A2>...</A2>
</A>
<PurchaseOrder>
<PurchaseOrderHeader>
<OrderNumber>A001</OrderNumber>
<OrderDate>2005-04-01</OrderDate>
<PurchaseOrderDetail>
<ProductLineItem>
<LineNumber>1</LineNumber>
<ProductNumber>AAA1</ProductNumber>
<ShipQty>10</ShipQty>
<LineNumber>2</LineNumber>
<ProductNumber>AAA2</ProductNumber>
<ShipQty>20</ShipQty>
</ProductLineItem>
</PurchaseOrderHeader>
<PurchaseOrderHeader>
<OrderNumber>A002</OrderNumber>
<OrderDate>2005-04-01</OrderDate>
<PurchaseOrderDetail>
<ProductLineItem>
<LineNumber>1</LineNumber>
<ProductNumber>BBB1</ProductNumber>
<ShipQty>30</ShipQty>
<LineNumber>2</LineNumber>
<ProductNumber>BBB2</ProductNumber>
<ShipQty>40</ShipQty>
</ProductLineItem>
</PurchaseOrderHeader>
</PurchaseOrder>
<B>
<B1>...</B1>
</B>
<C></C>
</PipPurchaseOrderConfirmation>

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

[DataTable]
<PurchaseOrderHeader>
<OrderNumber>A001</OrderNumber>
<OrderDate>2005-04-01</OrderDate>
<PurchaseOrderDetail>
<ProductLineItem>
<LineNumber>1</LineNumber>
<ProductNumber>AAA1</ProductNumber>
<ShipQty>10</ShipQty>
<LineNumber>2</LineNumber>
<ProductNumber>AAA2</ProductNumber>
<ShipQty>20</ShipQty>
</ProductLineItem>
</PurchaseOrderHeader>

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.
 
Back
Top