Thanks, I was able to successfully parse the xml document using the examples in the links below.
Charles Carroll <[EMAIL PROTECTED]> wrote:XMLTextReader is easy. Samples @ http://learnasp.com/freebook/learn/xmltextreader_amazon.aspx http://learnasp.com/freebook/learn/xmltextreader.aspx http://learnasp.com/freebook/learn/cs_xmlparser.aspx http://learnasp.com/freebook/learn/xmlparser.aspx On 8/20/05, Rinki Agarwal <[EMAIL PROTECTED]> wrote: > Hi everyone, > I am trying to parse this xml file below. I need the values of all c0, > c1, c2,c3,c4,c5,c6,c7,c8, c9 and c10. I have to make a loop to read all the > values and construct another xml document. Please let me know how can I do > it. Below is the xml file > <returnXml> > > <methodStatus> > <statusType>success</statusType> > </methodStatus> > <parametersReturn> > <rowSet rowCount="17" columnCount="12"> > <columnDefinitions collection="1" > objectType="columnDefinition"> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>iReferenceId</columnName> > > <columnOrdinal>1</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>4</columnSize> > <columnType>i4</columnType> > > <columnPrecision>10</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>iParameterId</columnName> > > <columnOrdinal>2</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>4</columnSize> > <columnType>i4</columnType> > > <columnPrecision>10</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>iSiteId</columnName> > > <columnOrdinal>3</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>4</columnSize> > <columnType>i4</columnType> > > <columnPrecision>10</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>iParentId</columnName> > > <columnOrdinal>4</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>4</columnSize> > <columnType>i4</columnType> > > <columnPrecision>10</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>vchParameterDesc</columnName> > > <columnOrdinal>5</columnOrdinal> > <columnFlags>8</columnFlags> > <columnSize>50</columnSize> > <columnType>string</columnType> > > <columnPrecision>255</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>iAlternateLangId</columnName> > > <columnOrdinal>6</columnOrdinal> > <columnFlags>120</columnFlags> > <columnSize>4</columnSize> > <columnType>i4</columnType> > > <columnPrecision>10</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>vchExtraData</columnName> > > <columnOrdinal>7</columnOrdinal> > <columnFlags>104</columnFlags> > <columnSize>20</columnSize> > <columnType>string</columnType> > > <columnPrecision>255</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>vchCharacterCode</columnName> > > <columnOrdinal>8</columnOrdinal> > <columnFlags>104</columnFlags> > <columnSize>20</columnSize> > <columnType>string</columnType> > > <columnPrecision>255</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>iSeqNum</columnName> > > <columnOrdinal>9</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>4</columnSize> > <columnType>i4</columnType> > > <columnPrecision>10</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>iAccessCode</columnName> > > <columnOrdinal>10</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>4</columnSize> > <columnType>i4</columnType> > > <columnPrecision>10</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>dtModifiedDate</columnName> > > <columnOrdinal>11</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>16</columnSize> > > <columnType>dateTime</columnType> > > <columnPrecision>23</columnPrecision> > <columnScale>3</columnScale> > </columnDefinition> > <columnDefinition> > <columnHeading></columnHeading> > > <columnName>tiRecordStatus</columnName> > > <columnOrdinal>12</columnOrdinal> > <columnFlags>24</columnFlags> > <columnSize>1</columnSize> > <columnType>i1</columnType> > > <columnPrecision>3</columnPrecision> > <columnScale>255</columnScale> > </columnDefinition> > </columnDefinitions> > <rows collection="1" objectType="row"> > <row> > <c0>1</c0> > <c1>101</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Billing</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>1</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>1</c0> > <c1>102</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Business</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>2</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>1</c0> > <c1>119</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Home</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>3</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>1</c0> > <c1>148</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Visiting</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>4</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>2</c0> > <c1>102</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Business</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>1</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>2</c0> > <c1>103</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Cellular</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>2</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>2</c0> > <c1>115</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Fax</c4> > <c5></c5> > <c6>FAX</c6> > <c7></c7> > <c8>3</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>2</c0> > <c1>119</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Home</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>4</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>2</c0> > <c1>339</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Pager</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>5</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>166</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Prospect</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>1</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>170</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Evaluation</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>2</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>186</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Reseller</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>3</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>299</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Lead</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>4</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>300</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Purchased</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>5</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>303</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Analyst</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>6</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>100314</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Contact</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>7</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > <row> > <c0>3</c0> > <c1>100325</c1> > <c2>1</c2> > <c3>0</c3> > <c4>Customer</c4> > <c5></c5> > <c6></c6> > <c7></c7> > <c8>8</c8> > <c9>1</c9> > <c10>2005-05-23 13:31:55</c10> > <c11>1</c11> > </row> > </rows> > </rowSet> > </parametersReturn> > <customData></customData> > </returnXml> --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspNetAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Start your day with Yahoo! - make it your home page [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hmsd82q/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124676636/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
