471,054 Members | 1,656 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,054 software developers and data experts.

SQLDataset.WriteXml and filtering bad characters

JR
I wrote a VB .NET program that part of it is reading from a SQL Server
2000 database and outputting data to XML. Problem is when I go to
transform the XML, from time to time, the data is bad as it contains
some of the bad XML characters like those below 0x20 ()

Below is the command I'm using to do this.

SQLDataset.WriteXml("c:\temp\output.xml", XmlWriteMode.WriteSchema)

So besides except for 0x09 ( ), 0x0A ( ), and 0x0D( ) is
there a way to filter out all characters under 0x20 as it writes to the
XML text file, replacing it with a space or nothing at all?

Thanks.

JR

Jun 10 '06 #1
0 1109

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by sorCrer | last post: by
reply views Thread by Opie | last post: by
2 posts views Thread by Christina Androne | last post: by
4 posts views Thread by MarkusJ_NZ | last post: by
3 posts views Thread by Sin Jeong-hun | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.