using System;

using System.Xml.Linq;

​

public static class Program

{

    public static void Main(string[] args)

    {

        const string xml =

            @"<QAS_GETQUERYRESULTS_RESP_MSG>

    <query numrows='5'>

        <row rownumber='1'>

            <APID>9</APID>

            <rownumber>1</rownumber>

            <BUSINESS_UNIT_AP>

                <![CDATA[AP001]]>

            </BUSINESS_UNIT_AP>

            <BUSINESS_UNIT_PO>

                <![CDATA[C0013]]>

            </BUSINESS_UNIT_PO>

            <PO_NUMBER>

                <![CDATA[C00130000159650]]>

            </PO_NUMBER>

            <VENDOR_ID>

                <![CDATA[0000109218]]>

            </VENDOR_ID>

            <NAME1>

                <![CDATA[E3 DIAGNOSTICS]]>

            </NAME1>

            <ADDRESS_SEQ_NUM>10</ADDRESS_SEQ_NUM>

            <ADDRESS1>

                <![CDATA[3333 N KENNICOTT AVE]]>

            </ADDRESS1>

            <ADDRESS2/>

            <CITY>

                <![CDATA[ARLINGTON HEIGHTS]]>

            </CITY>

            <STATE>

                <![CDATA[IL]]>

            </STATE>

            <POSTAL>

                <![CDATA[60004-1429]]>

            </POSTAL>

            <COUNTRY>

                <![CDATA[USA]]>

            </COUNTRY>

            <VNDR_NAME_SHRT_USR>

                <![CDATA[E3 DIAGNOS]]>

            </VNDR_NAME_SHRT_USR>

            <NAME2/>

            <LINE_NBR>1</LINE_NBR>

            <SCHED_NBR>1</SCHED_NBR>

            <ITM_SETID>

                <![CDATA[SHARE]]>

            </ITM_SETID>

            <INV_ITEM_ID/>

            <ITM_ID_VNDR>

                <![CDATA[8012984]]>

            </ITM_ID_VNDR>

            <DESCR254_MIXED>

                <![CDATA[ADI Mushroom Eartips, 19mm - 100/Pack]]>

            </DESCR254_MIXED>

            <POAMOUNT>0</POAMOUNT>

            <UNIT_OF_MEASURE>

                <![CDATA[BG]]>

            </UNIT_OF_MEASURE>

            <QTY_PO>3</QTY_PO>

            <PRICE_PO>28.5</PRICE_PO>

            <MERCHANDISE_AMT>85.5</MERCHANDISE_AMT>

            <AH_POITEM_QTYINV>0</AH_POITEM_QTYINV>

            <PO_AMT1>0</PO_AMT1>

            <PO_STATUS>

                <![CDATA[D]]>

            </PO_STATUS>

            <CANCEL_STATUS>

                <![CDATA[A]]>

            </CANCEL_STATUS>

        </row>

        <row rownumber='2'>

            <APID>9</APID>

            <rownumber>2</rownumber>

            <BUSINESS_UNIT_AP>

                <![CDATA[AP001]]>

            </BUSINESS_UNIT_AP>

            <BUSINESS_UNIT_PO>

                <![CDATA[C0013]]>

            </BUSINESS_UNIT_PO>

            <PO_NUMBER>

                <![CDATA[C00130000159650]]>

            </PO_NUMBER>

            <VENDOR_ID>

                <![CDATA[0000109218]]>

            </VENDOR_ID>

            <NAME1>

                <![CDATA[E3 DIAGNOSTICS]]>

            </NAME1>

            <ADDRESS_SEQ_NUM>10</ADDRESS_SEQ_NUM>

            <ADDRESS1>

                <![CDATA[3333 N KENNICOTT AVE]]>

            </ADDRESS1>

            <ADDRESS2/>

            <CITY>

                <![CDATA[ARLINGTON HEIGHTS]]>

            </CITY>

            <STATE>

                <![CDATA[IL]]>

            </STATE>

            <POSTAL>

                <![CDATA[60004-1429]]>

            </POSTAL>

            <COUNTRY>

                <![CDATA[USA]]>

            </COUNTRY>

            <VNDR_NAME_SHRT_USR>

                <![CDATA[E3 DIAGNOS]]>

            </VNDR_NAME_SHRT_USR>

            <NAME2/>

            <LINE_NBR>2</LINE_NBR>

            <SCHED_NBR>1</SCHED_NBR>

            <ITM_SETID>

                <![CDATA[SHARE]]>

            </ITM_SETID>

            <INV_ITEM_ID/>

            <ITM_ID_VNDR>

                <![CDATA[8520359]]>

            </ITM_ID_VNDR>

            <DESCR254_MIXED>

                <![CDATA[IA Series Eartips; 18.5mm - 100/Pack]]>

            </DESCR254_MIXED>

            <POAMOUNT>0</POAMOUNT>

            <UNIT_OF_MEASURE>

                <![CDATA[BG]]>

            </UNIT_OF_MEASURE>

            <QTY_PO>3</QTY_PO>

            <PRICE_PO>29.5</PRICE_PO>

            <MERCHANDISE_AMT>88.5</MERCHANDISE_AMT>

            <AH_POITEM_QTYINV>0</AH_POITEM_QTYINV>

            <PO_AMT1>0</PO_AMT1>

            <PO_STATUS>

                <![CDATA[D]]>

            </PO_STATUS>

            <CANCEL_STATUS>

                <![CDATA[A]]>

            </CANCEL_STATUS>

        </row>

        <row rownumber='3'>

            <APID>9</APID>

            <rownumber>3</rownumber>

            <BUSINESS_UNIT_AP>

                <![CDATA[AP001]]>

            </BUSINESS_UNIT_AP>

            <BUSINESS_UNIT_PO>

                <![CDATA[C0013]]>

            </BUSINESS_UNIT_PO>

            <PO_NUMBER>

                <![CDATA[C00130000159650]]>

            </PO_NUMBER>

            <VENDOR_ID>

                <![CDATA[0000109218]]>

            </VENDOR_ID>

            <NAME1>

                <![CDATA[E3 DIAGNOSTICS]]>

            </NAME1>

            <ADDRESS_SEQ_NUM>10</ADDRESS_SEQ_NUM>

            <ADDRESS1>

                <![CDATA[3333 N KENNICOTT AVE]]>

            </ADDRESS1>

            <ADDRESS2/>

            <CITY>

                <![CDATA[ARLINGTON HEIGHTS]]>

            </CITY>

            <STATE>

                <![CDATA[IL]]>

            </STATE>

            <POSTAL>

                <![CDATA[60004-1429]]>

            </POSTAL>

            <COUNTRY>

                <![CDATA[USA]]>

            </COUNTRY>

            <VNDR_NAME_SHRT_USR>

                <![CDATA[E3 DIAGNOS]]>

            </VNDR_NAME_SHRT_USR>

            <NAME2/>

            <LINE_NBR>3</LINE_NBR>

            <SCHED_NBR>1</SCHED_NBR>

            <ITM_SETID>

                <![CDATA[SHARE]]>

            </ITM_SETID>

            <INV_ITEM_ID/>

            <ITM_ID_VNDR>

                <![CDATA[8012980]]>

            </ITM_ID_VNDR>

            <DESCR254_MIXED>

                <![CDATA[ADI Series Mushroom Eartips, 14mm - 100 Pieces]]>

            </DESCR254_MIXED>

            <POAMOUNT>0</POAMOUNT>

            <UNIT_OF_MEASURE>

                <![CDATA[BG]]>

            </UNIT_OF_MEASURE>

            <QTY_PO>3</QTY_PO>

            <PRICE_PO>28.5</PRICE_PO>

            <MERCHANDISE_AMT>85.5</MERCHANDISE_AMT>

            <AH_POITEM_QTYINV>0</AH_POITEM_QTYINV>

            <PO_AMT1>0</PO_AMT1>

            <PO_STATUS>

                <![CDATA[D]]>

            </PO_STATUS>

            <CANCEL_STATUS>

                <![CDATA[A]]>

            </CANCEL_STATUS>

        </row>

        <row rownumber='4'>

            <APID>9</APID>

            <rownumber>4</rownumber>

            <BUSINESS_UNIT_AP>

                <![CDATA[AP001]]>

            </BUSINESS_UNIT_AP>

            <BUSINESS_UNIT_PO>

                <![CDATA[C0013]]>

            </BUSINESS_UNIT_PO>

            <PO_NUMBER>

                <![CDATA[C00130000159650]]>

            </PO_NUMBER>

            <VENDOR_ID>

                <![CDATA[0000109218]]>

            </VENDOR_ID>

            <NAME1>

                <![CDATA[E3 DIAGNOSTICS]]>

            </NAME1>

            <ADDRESS_SEQ_NUM>10</ADDRESS_SEQ_NUM>

            <ADDRESS1>

                <![CDATA[3333 N KENNICOTT AVE]]>

            </ADDRESS1>

            <ADDRESS2/>

            <CITY>

                <![CDATA[ARLINGTON HEIGHTS]]>

            </CITY>

            <STATE>

                <![CDATA[IL]]>

            </STATE>

            <POSTAL>

                <![CDATA[60004-1429]]>

            </POSTAL>

            <COUNTRY>

                <![CDATA[USA]]>

            </COUNTRY>

            <VNDR_NAME_SHRT_USR>

                <![CDATA[E3 DIAGNOS]]>

            </VNDR_NAME_SHRT_USR>

            <NAME2/>

            <LINE_NBR>4</LINE_NBR>

            <SCHED_NBR>1</SCHED_NBR>

            <ITM_SETID>

                <![CDATA[SHARE]]>

            </ITM_SETID>

            <INV_ITEM_ID/>

            <ITM_ID_VNDR>

                <![CDATA[8012978]]>

            </ITM_ID_VNDR>

            <DESCR254_MIXED>

                <![CDATA[ADI Series Mushroom Eartips, 13m - 100 Pieces]]>

            </DESCR254_MIXED>

            <POAMOUNT>0</POAMOUNT>

            <UNIT_OF_MEASURE>

                <![CDATA[BG]]>

            </UNIT_OF_MEASURE>

            <QTY_PO>3</QTY_PO>

            <PRICE_PO>28.5</PRICE_PO>

            <MERCHANDISE_AMT>85.5</MERCHANDISE_AMT>

            <AH_POITEM_QTYINV>0</AH_POITEM_QTYINV>

            <PO_AMT1>0</PO_AMT1>

            <PO_STATUS>

                <![CDATA[D]]>

            </PO_STATUS>

            <CANCEL_STATUS>

                <![CDATA[A]]>

            </CANCEL_STATUS>

        </row>

        <row rownumber='5'>

            <APID>9</APID>

            <rownumber>5</rownumber>

            <BUSINESS_UNIT_AP>

                <![CDATA[AP001]]>

            </BUSINESS_UNIT_AP>

            <BUSINESS_UNIT_PO>

                <![CDATA[C0013]]>

            </BUSINESS_UNIT_PO>

            <PO_NUMBER>

                <![CDATA[C00130000159650]]>

            </PO_NUMBER>

            <VENDOR_ID>

                <![CDATA[0000109218]]>

            </VENDOR_ID>

            <NAME1>

                <![CDATA[E3 DIAGNOSTICS]]>

            </NAME1>

            <ADDRESS_SEQ_NUM>10</ADDRESS_SEQ_NUM>

            <ADDRESS1>

                <![CDATA[3333 N KENNICOTT AVE]]>

            </ADDRESS1>

            <ADDRESS2/>

            <CITY>

                <![CDATA[ARLINGTON HEIGHTS]]>

            </CITY>

            <STATE>

                <![CDATA[IL]]>

            </STATE>

            <POSTAL>

                <![CDATA[60004-1429]]>

            </POSTAL>

            <COUNTRY>

                <![CDATA[USA]]>

            </COUNTRY>

            <VNDR_NAME_SHRT_USR>

                <![CDATA[E3 DIAGNOS]]>

            </VNDR_NAME_SHRT_USR>

            <NAME2/>

            <LINE_NBR>5</LINE_NBR>

            <SCHED_NBR>1</SCHED_NBR>

            <ITM_SETID>

                <![CDATA[SHARE]]>

            </ITM_SETID>

            <INV_ITEM_ID/>

            <ITM_ID_VNDR>

                <![CDATA[8012970]]>

            </ITM_ID_VNDR>

            <DESCR254_MIXED>

                <![CDATA[ADI Series Mushroom Eartips, 9mm - 100 Pieces]]>

            </DESCR254_MIXED>

            <POAMOUNT>0</POAMOUNT>

            <UNIT_OF_MEASURE>

                <![CDATA[BG]]>

            </UNIT_OF_MEASURE>

            <QTY_PO>2</QTY_PO>

            <PRICE_PO>28.5</PRICE_PO>

            <MERCHANDISE_AMT>57</MERCHANDISE_AMT>

            <AH_POITEM_QTYINV>0</AH_POITEM_QTYINV>

            <PO_AMT1>0</PO_AMT1>

            <PO_STATUS>

                <![CDATA[D]]>

            </PO_STATUS>

            <CANCEL_STATUS>

                <![CDATA[A]]>

            </CANCEL_STATUS>

        </row>

        <row rownumber='6'>

            <APID>9</APID>

            <rownumber>6</rownumber>

            <BUSINESS_UNIT_AP>

                <![CDATA[AP001]]>

            </BUSINESS_UNIT_AP>

            <BUSINESS_UNIT_PO>

                <![CDATA[C0013]]>

            </BUSINESS_UNIT_PO>

            <PO_NUMBER>

                <![CDATA[C00130000159650]]>

            </PO_NUMBER>

            <VENDOR_ID>

                <![CDATA[0000109218]]>

            </VENDOR_ID>

            <NAME1>

                <![CDATA[E3 DIAGNOSTICS]]>

            </NAME1>

            <ADDRESS_SEQ_NUM>10</ADDRESS_SEQ_NUM>

            <ADDRESS1>

                <![CDATA[3333 N KENNICOTT AVE]]>

            </ADDRESS1>

            <ADDRESS2/>

            <CITY>

                <![CDATA[ARLINGTON HEIGHTS]]>

            </CITY>

            <STATE>

                <![CDATA[IL]]>

            </STATE>

            <POSTAL>

                <![CDATA[60004-1429]]>

            </POSTAL>

            <COUNTRY>

                <![CDATA[USA]]>

            </COUNTRY>

            <VNDR_NAME_SHRT_USR>

                <![CDATA[E3 DIAGNOS]]>

            </VNDR_NAME_SHRT_USR>

            <NAME2/>

            <LINE_NBR>6</LINE_NBR>

            <SCHED_NBR>1</SCHED_NBR>

            <ITM_SETID>

                <![CDATA[SHARE]]>

            </ITM_SETID>

            <INV_ITEM_ID/>

            <ITM_ID_VNDR>

                <![CDATA[8013004]]>

            </ITM_ID_VNDR>

            <DESCR254_MIXED>

                <![CDATA[ADI Series Mushroom Eartips, 8mm - 100 Pieces]]>

            </DESCR254_MIXED>

            <POAMOUNT>0</POAMOUNT>

            <UNIT_OF_MEASURE>

                <![CDATA[BG]]>

            </UNIT_OF_MEASURE>

            <QTY_PO>2</QTY_PO>

            <PRICE_PO>28.5</PRICE_PO>

            <MERCHANDISE_AMT>57</MERCHANDISE_AMT>

            <AH_POITEM_QTYINV>0</AH_POITEM_QTYINV>

            <PO_AMT1>0</PO_AMT1>

            <PO_STATUS>

                <![CDATA[D]]>

            </PO_STATUS>

            <CANCEL_STATUS>

                <![CDATA[A]]>

            </CANCEL_STATUS>

        </row>

        <row rownumber='7'>

            <APID>9</APID>

            <rownumber>7</rownumber>

            <BUSINESS_UNIT_AP>

                <![CDATA[AP001]]>

            </BUSINESS_UNIT_AP>

            <BUSINESS_UNIT_PO>

                <![CDATA[C0013]]>

            </BUSINESS_UNIT_PO>

            <PO_NUMBER>

                <![CDATA[C00130000159650]]>

            </PO_NUMBER>

            <VENDOR_ID>

                <![CDATA[0000109218]]>

            </VENDOR_ID>

            <NAME1>

                <![CDATA[E3 DIAGNOSTICS]]>

            </NAME1>

            <ADDRESS_SEQ_NUM>10</ADDRESS_SEQ_NUM>

            <ADDRESS1>

                <![CDATA[3333 N KENNICOTT AVE]]>

            </ADDRESS1>

            <ADDRESS2/>

            <CITY>

                <![CDATA[ARLINGTON HEIGHTS]]>

            </CITY>

            <STATE>

                <![CDATA[IL]]>

            </STATE>

            <POSTAL>

                <![CDATA[60004-1429]]>

            </POSTAL>

            <COUNTRY>

                <![CDATA[USA]]>

            </COUNTRY>

            <VNDR_NAME_SHRT_USR>

                <![CDATA[E3 DIAGNOS]]>

            </VNDR_NAME_SHRT_USR>

            <NAME2/>

            <LINE_NBR>7</LINE_NBR>

            <SCHED_NBR>1</SCHED_NBR>

            <ITM_SETID>

                <![CDATA[SHARE]]>

            </ITM_SETID>

            <INV_ITEM_ID/>

            <ITM_ID_VNDR>

                <![CDATA[8013002]]>

            </ITM_ID_VNDR>

            <DESCR254_MIXED>

                <![CDATA[ADI Series Mushroom Eartips, 7mm - 100 Pieces]]>

            </DESCR254_MIXED>

            <POAMOUNT>0</POAMOUNT>

            <UNIT_OF_MEASURE>

                <![CDATA[BG]]>

            </UNIT_OF_MEASURE>

            <QTY_PO>2</QTY_PO>

            <PRICE_PO>28.5</PRICE_PO>

            <MERCHANDISE_AMT>57</MERCHANDISE_AMT>

            <AH_POITEM_QTYINV>0</AH_POITEM_QTYINV>

            <PO_AMT1>0</PO_AMT1>

            <PO_STATUS>

                <![CDATA[D]]>

            </PO_STATUS>

            <CANCEL_STATUS>

                <![CDATA[A]]>

            </CANCEL_STATUS>

        </row>

    </query>

</QAS_GETQUERYRESULTS_RESP_MSG>";

​

        var doc = XDocument.Parse(xml);

​

        foreach (var element in doc.Descendants())

        {

                    Console.WriteLine(element.Remove("rownumber"));

​

            if (element.Name.LocalName.StartsWith("rownumber="))

            {

                element.Name = "Raju Maurya";

            }

        }

​

        Console.WriteLine(doc);

​

    }

}