Read dynamically created xml document to dataset

Question

I have to read a dynamically created xml documnet to a dataset.But don't know how to achieve that.I wrote some code as below.

    private void ConvertXMLToDT(string myXML)
    {
        XmlDocument xmlDocs = new XmlDocument();
        xmlDocs.LoadXml(myXML);
        DataSet ds = new DataSet();
        ds.ReadXml(xmlDocs);   //--->this statement doesn't work
        DataTable dtFormats = ds.Tables[0];
        DataTable dtPreset1 = ds.Tables[1];        
        Response.Write("done");
    }

Is there any possible way to do that.

their is not parameter type of XmlDocument in DataSet.ReadXml method. it support "filename(string), IO.Stream, TextReader, XmlReader" types. — Raju Padhara, May 02 '14 at 11:09
is there any possible way to get that xml in the dataset in this context — Arvin, May 02 '14 at 11:11
Hopefull, this link will help you :http://stackoverflow.com/questions/10536637/how-to-read-xml-into-a-dataset — Kumar Manish, May 02 '14 at 11:12
@Arvin this link is also [help you] (http://stackoverflow.com/questions/8047064/convert-string-to-system-io-stream) — Raju Padhara, May 02 '14 at 11:16

score 1 · Answer 1 · answered May 02 '14 at 11:22

I have modified my code as per the comments above in the questions and working fine now

private void ConvertXMLToDT(string myXML)
{
    //XmlDocument xmlDocs = new XmlDocument();
    //xmlDocs.LoadXml(myXML);
    DataSet ds = new DataSet();
    //ds.ReadXml(xmlDocs);   //--->this statement doesn't work
    ds.ReadXml(XmlReader.Create(new StringReader(myXML)));
    DataTable dtFormats = ds.Tables[0];
    DataTable dtPreset1 = ds.Tables[1];        
    Response.Write("done");
}

score 1 · Answer 2 · edited May 02 '14 at 11:43

1

It may help for you:

 public DataTable ConvertXMLToDT(string xml)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(new XmlTextReader(new StringReader(xml)));
        return ds.Tables[0];
    }

edited May 02 '14 at 11:43

Peter

27,590
8
64
84

answered May 02 '14 at 11:25

Kumar Manish

3,746
3
37
42

Read dynamically created xml document to dataset

2 Answers2