XML to String value

Question

I use an XMLWriter to manually make an XML document. Is there a way to put that in string form so I can write it to my DB?

I am coding in VB..Net

Answer 1

You can make it write to a StringBuilder:

StringBuilder sb = new StringBuilder():
using (var writer = XmlWriter.Create(sb))
{
    // write the xml
}

string writtenXml = sb.ToString();

In VB.NET:

Dim sb As New StringBuilder()

Using writer As XmlWriter = XmlWriter.Create(sb)
    ' write the xml '
End Using

Dim writtenXml As String = sb.ToString()

Answer 2

You have have your XmlWriter wrap a StringWriter. Then you process it as you already are. when you want to access the string itself call StringWriter.ToString().