XML and XmlDataSource Control

Re: Error: Looping through an xml twice instead on of once.

kavita_khandhadia — Mon, 06 Jul 2009 06:05:07 GMT

penkye:
Hi kavita, i'm not at this point trying to input any more data into the xml. i have the data that i need already and need to pass it to a process that will read and input the data into our system. For some strange reason when it loops through the selection node (item) it sort of loops twice and i don't know why?

Humm of course i know that,,,

i mean to say That..

whenu do this..

xmlDoc.Load("D:\website\apphtml\da_beta\xml\" + iCookie + ".xml")

u can get the xml input file by doing this

string myXml = xmlDoc.DocumentElement.OuterXml.

I wanted u to paste the myXml varibale result over here.. it wud be good if u do that..so that we can solve ur prob

Re: Error: Looping through an xml twice instead on of once.

agr001 — Fri, 03 Jul 2009 14:49:28 GMT

Remove this line... Dim node As XmlNode = xmlDoc.SelectSingleNode("/cart_item/item")

And change the loop to

For Each node as XmlNode In m_nodelist

this should do the trick.

Re: Error: Looping through an xml twice instead on of once.

penkye — Fri, 03 Jul 2009 14:34:18 GMT

Hi kavita, i'm not at this point trying to input any more data into the xml. i have the data that i need already and need to pass it to a process that will read and input the data into our system. For some strange reason when it loops through the selection node (item) it sort of loops twice and i don't know why?

Re: Error: Looping through an xml twice instead on of once.

kavita_khandhadia — Fri, 03 Jul 2009 09:33:43 GMT

Provide 2 things here...ur input xml and wot out put u need from that xml

Re: Error: Looping through an xml twice instead on of once.

penkye — Thu, 02 Jul 2009 15:47:07 GMT

Hi Samu, I tried your suggestion but it some how still loops twice through the xml file. I'm not exactly sure what to do but i do well any suggestions or different approach to my problem.

Thanks.

Re: Error: Looping through an xml twice instead on of once.

Samu Zhang - MSFT — Wed, 20 May 2009 09:28:00 GMT

Hi penkye ,

penkye:
I don't seem to understand why it does the whole for loop twice

There are two item nodes in this xml file. The xpath ("/cart_item/item") indicate that to fetch all item nodes under cart_item node. So loop twice.

Error: Looping through an xml twice instead on of once.

penkye — Thu, 14 May 2009 19:18:46 GMT

Hi All,

I just stampled accross this weired behavior trying to loop through an xml file by selecting the appropriate nodes. I don't seem to understand why it does the whole for loop twice. Any help greatly appreciated.

Dim xmlDoc As New XmlDataDocument

Dim m_nodelist As XmlNodeList

xmlDoc.Load("D:\website\apphtml\da_beta\xml\" + iCookie + ".xml")

m_nodelist = xmlDoc.SelectNodes("/cart_item/item")

Dim node As XmlNode = xmlDoc.SelectSingleNode("/cart_item/item")

For Each node In m_nodelist

StockCode = node("part_no").InnerText

Response.Write(StockCode)

And i get this from the loop:

N1005176
N1005177
N1005178
N1005179
Sales Order Posting Successfull
Sales Order: 076436N1005176
N1005177
N1005178
N1005179
Sales Order Posting Successfull
Sales Order: 076437

xml file:

<cart_item>
<item>
    <CustID>734631</CustID>
    <part_no>N1005176</part_no>
    <prod_desc>Mobile Double Drawer</prod_desc>
    <Qty>1</Qty>
    <price>$49.92</price>
    <isize>Gray</isize>
    <icolor />
    <irecnum>135924</irecnum>
    <date>5/12/2009 2:11:25 PM</date>
    <subtotal>49.92</subtotal>
</item>
<item>
    <CustID>734631</CustID>
    <part_no>N1005177</part_no>
    <prod_desc>Storage Lockers Single Tier</prod_desc>
    <Qty>1</Qty>
    <price>$147.14</price>
    <isize>Dove Grey</isize>
    <icolor>
    </icolor>
    <irecnum>135816</irecnum>
    <date>5/12/2009 2:11:36 PM</date>
    <subtotal>147.14</subtotal>
</item>

</item>
</cart_item>