XML Parsing error

Question

Hi,

I am returning a DataTable from a WebService which contains 10-100 rows depending on the query.

Sometimes in this DataTable, i have some special characters coming in, like "$", which causes the problem and i get XML Parsing Error.

One way i found was to Encode the string but I don't want to loop through each rows and column and encode it and then decode it after retrieving it on client side.

What is the best way to avoid such error?

Thanks, Murtaza