How to prevent line breaks in XML file?

[les]

I am creating XML from SQL2000 using a vb.net page, then posting it to
a remote server as a string.

The remote server requires that the xml contain no line breaks, but
there are some ntext fields in the database that contain long text
with line breaks.

How do I get rid of the line breaks? Can I do this with the
XmlTextWriter, or do I need to handle each affected field seperately
before handing it to the XmlTextWriter?

Thanks
Leslie

[Oleg Tkachenko [MVP]]

les wrote:

How do I get rid of the line breaks? Can I do this with the
XmlTextWriter, or do I need to handle each affected field seperately
before handing it to the XmlTextWriter?

Both ways are possible. While it's probably simpler to run
String.Replace() on each string you are writing out, you can also create
custom XmlTextWriter (deriving from XmlTextWriter) and override
WriteString method to encapsulate replacement logic.

--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[les]

Thanks Oleg,

I'm used to doing this the other way around eg:
replace(litDetails.Text,chr(10),"&nbsp;<br>")

but now I have:
textWriter.WriteString(rdr3.Item("details"))

How would I do the necessary replacement here?
Thanks
Leslie


On Mon, 26 Apr 2004 10:30:09 +0200, "Oleg Tkachenko [MVP]"
<oleg@NO!SPAM!PLEASEtkachenko.com> wrote:

les wrote:

How do I get rid of the line breaks? Can I do this with the
XmlTextWriter, or do I need to handle each affected field seperately
before handing it to the XmlTextWriter?

Both ways are possible. While it's probably simpler to run
String.Replace() on each string you are writing out, you can also create
custom XmlTextWriter (deriving from XmlTextWriter) and override
WriteString method to encapsulate replacement logic.

[Oleg Tkachenko [MVP]]

les wrote:

I'm used to doing this the other way around eg:
replace(litDetails.Text,chr(10),"&nbsp;<br>")

but now I have:
textWriter.WriteString(rdr3.Item("details"))

How would I do the necessary replacement here?

Something like

string[] lines = text.Split('\n');
foreach (string line in lines)
{
textWriter.WriteString(line);
textWriter.WriteStartElement("br");
textWriter.WriteEndElement();
}

--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com