How To Read XML Data into a DataSet by Using Visual C# .NET
public class XMLtoDataset
{
public static DataSet GetDatasetFromXMLString(string inString)
{
StringReader StringReader;
XmlReader XmlReader = null;
try
{
Console.WriteLine("Initializing StringReader ...");
if (inString.IndexOf("<?xml version='1.0'?>") == -1)
{
inString = "<?xml version='1.0'?>" + inString;
}
//StringReader = new StringReader("<?xml version='1.0'?>" +
// "<!-- This file represents a fragment of a book store inventory database -->" +
// "<bookstore>" +
// " <book genre=\"autobiography\" publicationdate=\"1981\" ISBN=\"1-861003-11-0\">" +
// " <title>The Autobiography of Benjamin Franklin</title>" +
// " <author>" +
// " <first-name>Benjamin</first-name>" +
// " <last-name>Franklin</last-name>" +
// " </author>" +
// " <price>8.99</price>" +
// " </book>" +
// " <book genre=\"novel\" publicationdate=\"1967\" ISBN=\"0-201-63361-2\">" +
// " <title>The Confidence Man</title>" +
// " <author>" +
// " <first-name>Herman</first-name>" +
// " <last-name>Melville</last-name>" +
// " </author>" +
// " <price>11.99</price>" +
// " </book>" +
// " <book genre=\"philosophy\" publicationdate=\"1991\" ISBN=\"1-861001-57-6\">" +
// " <title>The Gorgias</title>" +
// " <author>" +
// " <name>Plato</name>" +
// " </author>" +
// " <price>9.99</price>" +
// " </book>" +
// "</bookstore>");
StringReader = new StringReader(inString);
//Create XmlReader and load reader from StringReader
XmlReader = XmlReader.Create(StringReader);
////Output reader to console
//using (XmlWriter XmlWriter = XmlWriter.Create(Console.Out))
//{
// XmlWriter.WriteNode(XmlReader, true);
//}
DataSet ds = new DataSet();
ds.ReadXml(XmlReader);
return ds;
}
finally
{
//Console.WriteLine("Processing of StringReader complete.");
}
}
}