XML parsing in C#

[Venkat Chellam]

I have a XML file like as follow

<?xml version="1.0" encoding="UTF-8"?>
<NeuStarLSRRepo rt>
<NeuStarHeade r fromDate="09/10/04" toDate="09/13/04"
RequestsReceive d ="43" ResponsesSent=" 50">
</NeuStarHeader>
<NeuStarReqestL ist>
<NeuStarRequest Recieved pon="IDT2345611 " ver="AA"
dateReceived="0 9/10/04" />
<NeuStarRequest Recieved pon="IDT2345615 " ver="AA"
dateReceived="0 9/10/04" />
</NeuStarReqestLi st>
<NeuStarRespons eList>
<NeuStarRespons eSent pon="IDT2345611 " ver="AA"
dateSent="09/10/04" MessageType="Er ror"/>
<NeuStarRespons eSent pon="IDT2345622 " ver="AB"
dateSent="09/10/04" MessageType="Er ror"/>
</NeuStarResponse List>
</NeuStarLSRRepor t>
from the above XML i need to parse the nodes inside node
<NeuStarRequest List>
<NueStarRespons eList> node. Both these nodes can have 1 or more number
of child nodes as described below( in above example, its just 2 for
each of them, but they can more or less also)'
how do i part the attributes values and i need to store them in the
database. For each node in both the nodes(NeuStarRe questList and
NeuStarResponse List) i need to insert a row into database table
conatining appropriate fields

any help?

venky

[Victor Hadianto]

Well you can do the following (just one way of doing it, I'm sure there are
lots other)

1. First find the node that you want to process, you can simply do an this
XPath '//NeuStarLSRRepor t/NeuStarReqestLi st/NeuStarRequestR ecieved '. This
will give you the XmlNodeCollecti on that you want to process.

2. Loop through that collection for each node that you want to process. For
each node you can get the attributes list (using the .Attributes property).
And then for each attributes you can build your SQL string

3. Do step 1 and 2 for the NeuStarResponse List nodes.

"Venkat Chellam" wrote:

I have a XML file like as follow

<?xml version="1.0" encoding="UTF-8"?>
<NeuStarLSRRepo rt>
<NeuStarHeade r fromDate="09/10/04" toDate="09/13/04"
RequestsReceive d ="43" ResponsesSent=" 50">
</NeuStarHeader>
<NeuStarReqestL ist>
<NeuStarRequest Recieved pon="IDT2345611 " ver="AA"
dateReceived="0 9/10/04" />
<NeuStarRequest Recieved pon="IDT2345615 " ver="AA"
dateReceived="0 9/10/04" />
</NeuStarReqestLi st>
<NeuStarRespons eList>
<NeuStarRespons eSent pon="IDT2345611 " ver="AA"
dateSent="09/10/04" MessageType="Er ror"/>
<NeuStarRespons eSent pon="IDT2345622 " ver="AB"
dateSent="09/10/04" MessageType="Er ror"/>
</NeuStarResponse List>
</NeuStarLSRRepor t>
from the above XML i need to parse the nodes inside node
<NeuStarRequest List>
<NueStarRespons eList> node. Both these nodes can have 1 or more number
of child nodes as described below( in above example, its just 2 for
each of them, but they can more or less also)'
how do i part the attributes values and i need to store them in the
database. For each node in both the nodes(NeuStarRe questList and
NeuStarResponse List) i need to insert a row into database table
conatining appropriate fields

any help?

venky