Problem with ReadXml into DataSet

[Linus Rörstad]

Hello!

I have created a xml-file by using the writeXml method on a dataset. The
problem arrises when I want to read the xml-file back into a dataset on a
pocket pc application. Some of the fields which are strings have whitespaces
added to end of the values in the dataset but not in the xml-file. How do I
read the xml-file without getting the whitespaces?

This is a part of the xml-file:
- <User>
<Username>hoa</Username>
<Password>hoa</Password>
<Access>1</Access>
</User>
and when it's put into the dataset it's like this:
Username="hoa "

The code I'm using to read the xml-file:

ds = new DataSet();
reader = new XmlTextReader(configs.DataPath);

ds.ReadXml( reader, XmlReadMode.ReadSchema);

Thanks
Linus

[Sonu Kapoor]

You can call the string.Trim function before you insert
the data into the dataset. Before assiging the values to
the dataset store them in a temp variable and call the
Trim function. This will delete the whitespaces. Take a
look here: http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/cpref/html/frlrfsystemstringclasstrimtopic.asp

hth

Sonu
My Blog: http://weblogs.asp.net/sonukapoor/

-----Original Message-----
Hello!

I have created a xml-file by using the writeXml method on a dataset. Theproblem arrises when I want to read the xml-file back into a dataset on apocket pc application. Some of the fields which are strings have whitespacesadded to end of the values in the dataset but not in the xml-file. How do Iread the xml-file without getting the whitespaces?

This is a part of the xml-file:
- <User>
<Username>hoa</Username>
<Password>hoa</Password>
<Access>1</Access>
</User>
and when it's put into the dataset it's like this:
Username="hoa "

The code I'm using to read the xml-file:

ds = new DataSet();
reader = new XmlTextReader(configs.DataPath);

ds.ReadXml( reader, XmlReadMode.ReadSchema);

Thanks
Linus
.