Feed XML string into Dataset

[ASPNETnewbie]

I have the code below as my XML string(dynamically generated at run time) and would like to instead save the information in a Dataset as an XML file, How do I make this transition without loosing any part of the string and have it display as it should from the dataset when called?

ASPNETNEWBIE



dynamically generated string STRXML

String STRXML = "<graph caption='Top 5 Countries for the Year 1996' shownames='1' showvalues='0' decimalPrecision='0' numberPrefix='$'>
   <set name='USA' value='38105.68' color='AFD8F8'/>
   <set name='Germany' value='35407.15' color='F6BD0F'/>
   <set name='Austria' value='25601.34' color='8BBA00'/>
   <set name='Brazil' value='20148.82' color='A66EDD'/>
   <set name='France' value='17372.76' color='F984A1'/>
</graph>"

 

[BoulderBum]

Controlling the XML formatting would be clumsy (if possible) with a DataSet.

It would be better to spend 5 minutes creating an object which uses .NET's XML serialization.

public class Graph
{
   [XmlAttribute("caption")]
   public string Caption;
   
   [XmlAttribute("shownames")]
   public int ShowNames;   
   
   private List<Set> _sets;

   [XmlArray]
   public List<Set> Sets
   {
      get{ return _sets; }
      set{ _sets = value; }
   }
}

public class Set
{
   [XmlAttribute("name")]
   public string Name;
}

http://msdn2.microsoft.com/en-us/library/83y7df3e.aspx