White Space in a dataset

[VBMental]

I have a dataset that has 2 string columns called 'Find' and 'Replace'.
I use the WriteXML method to save the XML to disk.
The problem is that if the user inputs a single space in Find or Replace, it will not save it in the data file. When the dataset is read back, the value is empty/null.

 

[chiph]

XML will truncate most whitespace inside an element, unless you have the "whitespace preserve" attribute on it. Unfortunately, I don't know how to place that attribute on the results of a dataset.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first