Convert DataSet object to Xml string variable...

Question

5.00/5 (1 vote)

See more:

Hello,

I'm trying to find a way to convert a dataset object to xml and assign that
to a string variable without saving to a file. Obviously I don't want to
slow down the process by writing to disk, but all the methods I've found so
far (dataset.writexml) write to a file. I think there's a way to use a
stream object, but I haven't come up with anything. How can I get this done
without writing to disk?

Thanks.

Posted 20-Apr-11 1:37am

Pritam N. Bohra

Add a Solution

2 solutions

Solution 1

How about using StringWriter[^]?

http://geekswithblogs.net/mnf/archive/2008/08/14/convert--dataset--and-datatable-to-xml-string-helper.aspx[^]

C#

public static string ToStringAsXml(DataSet ds)
{
    StringWriter sw = new StringWriter();
    ds.WriteXml(sw, XmlWriteMode.IgnoreSchema);
    string s = sw.ToString();
    return s;
}

Oops, just noticed the VB.Net tag

VB

Public Shared Function ToStringAsXml(ds As DataSet) As String
    Dim sw As New StringWriter()
    ds.WriteXml(sw, XmlWriteMode.IgnoreSchema)
    Dim s As String = sw.ToString()
    Return s
End Function

Posted 20-Apr-11 1:45am

Dylan Morley

Updated 20-Apr-11 1:48am

v3

Comments

lllyxer 3-May-11 15:42pm

Thank you Dylan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Accepted Answer · 2011-04-20T01:47:00

Solution 2

Use a MemoryStream object.

In C#:

C#

MemoryStream stream = new MemoryStream(); 
XmlTextWriter writer = new XmlTextWriter(stream, Encoding.UTF8); 
writer.WriteStartDocument(); 
myDataSet.WriteXML(stream);

In VB:

VB

Dim stream As New MemoryStream()
Dim writer As New XmlTextWriter(stream, Encoding.UTF8)
writer.WriteStartDocument()
myDataSet.WriteXML(stream)

Posted 20-Apr-11 1:47am

#realJSOP

Comments

Simon_Whale 20-Apr-11 17:54pm

Good call :) I;m using that technique myself it works like a charm