DataSet.WriteXml to string

Question

I'm tring to get a string from a DataSet without using GetXml. I'm using WriteXml, instead. How to use it to get a string? Thanks

score 71 · Accepted Answer · edited May 25 '23 at 10:08

71

string result = null;

using (TextWriter sw = new StringWriter())
{
    dataSet.WriteXml(sw);
    result = sw.ToString();
}

edited May 25 '23 at 10:08

shmnff

647
2
15
31

answered Jun 08 '09 at 08:27

Mehrdad Afshari

414,610
91
852
789

3

Out of interest, this fails on really large datasets (like it does on GetXML()) System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) – Rodney May 31 '11 at 01:21
1

VB.Net Version: `Dim sw As IO.StringWriter = New IO.StringWriter()` `dataset_name.WriteXml(sw)` `Dim result As String = sw.ToString()` – Jeff Dec 05 '13 at 22:20

score 9 · Answer 2 · edited May 23 '17 at 12:34

9

Write to a StringWriter, and then call ToString on that.

Note that if you want the generated XML declaration to specify UTF-8 instead of UTF-16, you'll need something like my Utf8StringWriter.

edited May 23 '17 at 12:34

Community

1
1

answered Jun 08 '09 at 08:26

Jon Skeet

1,421,763
867
9,128
9,194

score 1 · Answer 3 · answered Nov 13 '13 at 07:42

1

here is the vb.net code:

 Private Function GenerateXML(ByVal ds As DataSet) As String
    Dim obj As New StringWriter()
    Dim xmlstring As String
    ds.WriteXml(obj)
    xmlstring  = obj.ToString()
    Return xmlstring 
End Function

answered Nov 13 '13 at 07:42

DareDevil

5,249
6
50
88

Mehul Patel · Answer 4 · 2022-08-23T12:14:43.073

0

public string ConvertDatatableToXML(DataTable dt)

        MemoryStream str = new MemoryStream();
        dt.WriteXml(str, true);
        str.Seek(0, SeekOrigin.Begin);
        StreamReader sr = new StreamReader(str);
        string xmlstring = "";
        xmlstring = sr.ReadToEnd();
        return (xmlstring);

edited Aug 23 '22 at 12:14

answered Aug 23 '22 at 12:14

Mehul Patel

1
1

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Aug 26 '22 at 16:15

DataSet.WriteXml to string

4 Answers4