using System;

using System.Xml; 

using System.Xml.Linq;

​

public class Program

{

    public static void Main()

    {   

        var doc = Program.GenerateXML();

        var myDoc = XDocument.Parse(doc);

        XmlReader rdr = XmlReader.Create(new System.IO.StringReader(doc));

        while (rdr.Read())

        {           

            if (rdr.NodeType == XmlNodeType.Element)

            {

                //Console.WriteLine(rdr.LocalName);

                if(rdr.LocalName == "row"){

                    var attr = rdr.GetAttribute("Problem"); 

                    var none = rdr.GetAttribute("None"); 

                    var mild = rdr.GetAttribute("Mild"); 

                    var moderate = rdr.GetAttribute("Moderate"); 

                    var severe  = rdr.GetAttribute("Severe"); 

                    Console.WriteLine("attr: " + attr + " none: " + none + " mild: "+mild + " moderate: "+moderate + " severe: "+severe);

                }

            }

        }

    }

    public static string GenerateXML() { 

        string xml =

        @" <xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'

    xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'

    xmlns:rs='urn:schemas-microsoft-com:rowset'

    xmlns:z='#RowsetSchema'>

    <s:Schema id='RowsetSchema'>

    <s:ElementType name='row' content='eltOnly' rs:updatable='true'>

        <s:AttributeType name='Problem' rs:number='1' rs:nullable='true'                   rs:writeunknown='true' rs:basecatalog='MEDEZ_KAFERRY'

             rs:basetable='##Md431884276352444' rs:basecolumn='Problem'>

            <s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='150'/>

        </s:AttributeType>

        <s:AttributeType name='None' rs:number='2' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='MEDEZ_KAFERRY'

             rs:basetable='##Md431884276352444' rs:basecolumn='None'>

            <s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='1'/>

        </s:AttributeType>

        <s:AttributeType name='Mild' rs:number='3' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='MEDEZ_KAFERRY'

             rs:basetable='##Md431884276352444' rs:basecolumn='Mild'>

            <s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='1'/>

        </s:AttributeType>

        <s:AttributeType name='Moderate' rs:number='4' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='MEDEZ_KAFERRY'

             rs:basetable='##Md431884276352444' rs:basecolumn='Moderate'>

            <s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='1'/>

        </s:AttributeType>

        <s:AttributeType name='Severe' rs:number='5' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='MEDEZ_KAFERRY'

             rs:basetable='##Md431884276352444' rs:basecolumn='Severe'>

            <s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='1'/>

        </s:AttributeType>

        <s:extends type='rs:rowbase'/>

    </s:ElementType>

</s:Schema>

<rs:data>

    <z:row Problem='DEPRESSED MOOD' None='s'/>

    <z:row Problem='MOOD SWINGS' Mild='a' Moderate='g' Severe='s'/>

    <z:row Problem='IRRITABILITY'/>

    <z:row Problem='POOR CONCENTRATION' None='s' Moderate='s'/>

    <z:row Problem='AGITATION' Moderate='s'/>

    <z:row Problem='SLEEP DISTURBANCE'/>

    <z:row Problem='FATIGUE/LOW ENERGY'/>

    <z:row Problem='POOR GROOMING'/>

    <z:row Problem='GENERALIZED ANXIETY'/>

    <z:row Problem='PANIC ATTACKS'/>

    <z:row Problem='PHOBIAS'/>

    <z:row Problem='OBSESSIONS/COMPULSIONS'/>

    <z:row Problem='PSYCHOMOTOR DISTURBANCE'/>

    <z:row Problem='LOOSE ASSOCIATION'/>

    <z:row Problem='SEVERE PSYCHOMOTOR RETARDATION'/>

    <z:row Problem='SEVERE GRIEF'/>

    <z:row Problem='PARANOID IDEATION'/>

    <z:row Problem='DELUSIONS'/>

    <z:row Problem='HALLUCINATIONS'/>

    <z:row Problem='AGGRESSIVE BEHAVIORS'/>

    <z:row Problem='CONDUCT PROBLEMS'/>

    <z:row Problem='SEXUAL DYSFUNCTION'/>

    <z:row Problem='HOPELESSNESS'/>

    <z:row Problem='SOCIAL ISOLATION'/>

    <z:row Problem='WORTHLESSNESS'/>

    <z:row Problem='GUILT'/>

    <z:row Problem='ELEVATED MOOD'/>

    <z:row Problem='HYPERACTIVITY'/>

    <z:row Problem='DISSOCIATIVE STATES'/>

    <z:row Problem='SOMATIC-COMPLAINTS'/>

    <z:row Problem='SELF-MUTILATION'/>

    <z:row Problem='SIGNIFICANT WEIGHT GAIN/LOSS'/>

    <z:row Problem='CONCOMITANT MEDICAL CONDITION'/>

    <z:row Problem='EMOTIONAL/PSYCHOLOGICAL TRAUMA VICTIM'/>

    <z:row Problem='PHYSICAL TRAUMA VICTIM'/>

    <z:row Problem='SEXUAL TRAUMA VICTIM'/>

    <z:row Problem='EMOTIONAL/PSYCHOLOGICAL TRAUMA PERPETRATOR'/>

    <z:row Problem='PHYSICAL TRAUMA PERPETRATOR'/>

    <z:row Problem='SEXUAL TRAUMA PERPETRATOR'/>

    <z:row Problem='SUBSTANCE ABUSE'/>

</rs:data>

</xml>";

        return xml;

    }

}