Geeks With Blogs
Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done
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.");
            }
        }
    }
 
Posted on Wednesday, December 19, 2007 8:21 AM XML & Datasets | Back to top


Comments on this post: How To Read XML Data into a DataSet by Using Visual C# .NET

# re: How To Read XML Data into a DataSet by Using Visual C# .NET
Requesting Gravatar...
fucking nigger cunt fuck
Left by fdsf on Jan 23, 2008 1:44 AM

# re: How To Read XML Data into a DataSet by Using Visual C# .NET
Requesting Gravatar...
Great... thanks!!!
Left by Lord Heken on Nov 18, 2009 9:30 AM

# re: How To Read XML Data into a DataSet by Using Visual C# .NET
Requesting Gravatar...
http://4.bp.blogspot.com/_TExouLlJqxY/THpVRDgXCVI/AAAAAAAAAAU/V31mNmfu8AM/s200/XMLDataSet1.gif

http://www.a2zmenu.com/CSharp/How%20to%20Read%20XML%20Data%20into%20DataSet.aspx
Left by rs.emenu on Aug 29, 2010 8:22 AM

# re: How To write XML Data from a DataSet by Using Visual C# .NET
Requesting Gravatar...
I want to write xml from a dataset using respong in c#.net, Please suggest..
Left by harish on Mar 03, 2011 1:01 AM

# How To write XML Data into a DataSet by Using Visual C# .NET
Requesting Gravatar...
I want to write xml from a dataset.
Left by sudheer on Mar 03, 2011 1:13 AM

# re: How To Read XML Data into a DataSet by Using Visual C# .NET
Requesting Gravatar...
Errr excellent thanks!
Left by canvas prints on Dec 02, 2011 4:30 AM

Your comment:
 (will show your gravatar)


Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net