title: how to get the value from XML tag?
body: <p>Below is the information I receive from DB. It's originally from an XML file, but this is stored in DB table and I can't change the situation. I need to work these way, since there is no more information available.</p>
  
  <p>I read these in a dataset and my rows contains the 4 POSSIBLE ways.... I used Value1, Value2, Value3, Value4.... Is there a way to easily get these Values. Value 4 is special. I don't know how it comes but it looks like a tag... But I need that.</p>
  
  <p><br /> 
  <br />
  &lt; LOCATION> \n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt; P>Value1&lt; /P> \n    &lt; /LOCATION> <br /> 
  &lt; ACCEPTED_VARIANTES VALUE=\"Value2\" /><br>
  
  &lt; PERIOD_DAY> Value3 &lt; /PERIOD_DAY>
  <br />
  &lt; AWARD_CRITERIA_DETAIL > \n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt; Value4/> \n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt; /AWARD_CRITERIA_DETAIL>
  <br /> 
  <br /></p>
  
  <p>so the result should be:<br />
  e.g. <br/>
   string location = "value1";
  <br/>
  string acceptedVariantes = "Value2";
  <br/>
  int period = Value3;
  <br/>
  string AwarDetail = "Value4";</p>