multi-line text field in dataset passed to web services

T

tms

Hi everyone

I'm having a problem with passing a dataset with a text field in one of the tables contaning multiple lines separated by \r\n to the ASP.NET web services and back. The \r\n charachters get replaced with the single space. This does not happen for the regular string parameters, only for the fields in the dataset. After a few days of research I found that it happens on extraction of the dataset from the SOAP envelop. XmlReader in the call to ReadXmlSerializable of my strongly typed dataset comes with the \r\n charachters stripped off, but raw SOAL message has them intact. Any idea of how I can make it work? I don't want to encode this string before updating it in dataset since it will require special handling of binding in asp.net web form, and I won't be able to use data adapter to update database without some weird logic in the stored procedure..

Thank you in advance for your help
Alex.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,994
Messages
2,570,222
Members
46,809
Latest member
moe77

Latest Threads

Top