retrieve xmlnode value in XmlDocument

[David]

I have a xml file:
<OrderDetail TotalCount="2">
<ProductLine>
<LineNumber>1 </LineNumber>
<ProductNumber> A001</ProductNumber>
<ProductDescrip tion>17"VP171b</ProductDescript ion>
<ShipQuantity>1 00</ShipQuantity>
</ProductLine>
<ProductLine>
<LineNumber>2 </LineNumber>
<ProductNumber> A002</ProductNumber>
<ProductDescrip tion>17"VP171s</ProductDescript ion>
<ShipQuantity>2 00</ShipQuantity>
</ProductLine>
</OrderDetail>

And the node [ShipQuantity] xsd:integer

I want get [ShipQuantity] value in a int[] array,
How can I retrieve the 2 ProductLine's ShipQuantity value in it via C#
code?
use XmlNodeReader or XmlTextReader?

Thanks, David.

[Cor Ligthert]

David,

Your schema is almost completly a dataset.
(The header is not there)
I would try to use it as that when I was you.

Something as this
\\\
DataSet ds = new DataSet();
ds.ReadXml(@"C: \Test1\david.tx t");
int[] ships = new int[ds.Tables["ProductLin e"].Rows.Count];
for (int i = 0;i < ds.Tables["ProductLin e"].Rows.Count;i++ )
{
ships[i] = Convert.ToInt32
(ds.Tables["ProductLin e"].Rows[i]["ShipQuanti ty"]);
}
///
I hope this helps?

Cor

[Sami Vaaraniemi]

You could of course load the XML into an XmlDocument, iterate over all the
nodes and collect the quantities as you go. Another way is to use an XPath
query (warning: untested code follows):

string xmlText = ...;
XmlDocument xmlDoc = new xmlDoc;
xmlDoc.LoadXml( xmlText);

XmlNodeList nodes = xmlDoc.SelectNo des("//ShipQuantity");
int[] quantities = new int[nodes.Count];

for (int i = 0; i < nodes.Count; i++)
{
quantities[i] = int.Parse(nodes[i].InnerText);
}

Regards,
Sami

"David" <ca*******@wall a.com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

I have a xml file:
<OrderDetail TotalCount="2">
<ProductLine>
<LineNumber>1 </LineNumber>
<ProductNumber> A001</ProductNumber>
<ProductDescrip tion>17"VP171b</ProductDescript ion>
<ShipQuantity>1 00</ShipQuantity>
</ProductLine>
<ProductLine>
<LineNumber>2 </LineNumber>
<ProductNumber> A002</ProductNumber>
<ProductDescrip tion>17"VP171s</ProductDescript ion>
<ShipQuantity>2 00</ShipQuantity>
</ProductLine>
</OrderDetail>

And the node [ShipQuantity] xsd:integer

I want get [ShipQuantity] value in a int[] array,
How can I retrieve the 2 ProductLine's ShipQuantity value in it via C#
code?
use XmlNodeReader or XmlTextReader?

Thanks, David.

[David]

Thank you, Cor.
Do you know how to transfer a XmlDocument to a DataSet?
Because my xml data is from a XLANGMessage,
and I try it like this:

XLANGPart part = msg[0];
XmlDocument doc = (XmlDocument)pa rt.RetrieveAs(t ypeof(XmlDocume nt));
DataSet ds = new DataSet();
ds.ReadXml(doc) ;

But I can not put it in Dataset...
after I execute it, I got error message.

Thanks, David

[David]

Thank you, Sami.
But I got the error message:"Can not transfer XmlDocument to
XmlNodeList."

David

[Cor Ligthert]

David,

When your xml file is as you showed, than that should do my sample, I tested
it before I have sent it.
(It was because it was in my opinion almost a dataset)

I made from your string a textfile and tested it before I have sand it.

So why you try it yourself in the same way as well.

Cor

"David" <ca*******@wall a.com>

news:11******** *************@c 13g2000cwb.goog legroups.com...

Thank you, Cor.
Do you know how to transfer a XmlDocument to a DataSet?
Because my xml data is from a XLANGMessage,
and I try it like this:

XLANGPart part = msg[0];
XmlDocument doc = (XmlDocument)pa rt.RetrieveAs(t ypeof(XmlDocume nt));
DataSet ds = new DataSet();
ds.ReadXml(doc) ;

But I can not put it in Dataset...
after I execute it, I got error message.

Thanks, David

[Cor Ligthert]

text file using notebook however with the extention xml

[David]

I try this code, It is OK to trans dataset.

msg is a XLANGMessage:

XLANGPart part = msg[0];
XmlDocument doc = (XmlDocument)pa rt.RetrieveAs(t ypeof(XmlDocume nt));

XmlNodeReader xnr = new XmlNodeReader(d oc);
DataSet ds = new DataSet();
ds.ReadXml(xnr) ;

Thank you, Cor.

David.