If you got the answer, thank you so much.


OK I have to ask this question again as I know it can’t be that
difficult, nor is it that rare. So a lot of people are doing something
wrong, but what are we doing wrong?


Someone types text in Ms Word, say a blog entry or forum post, then
they cut that text out of word and past it into a form on the web and
submit it. It get written to SQL Server.


The problem, word takes a single quote character #39 and turns it into
#146 in most cases, by default.



You then use a method let’s say GetDataSet()  and work with that
data. The text is messed up:  "It’s" becomes   "it’s" This is
NOT a problem when using a DataReader, but when you return a DataSet...
XML you get this behavior.


Example


I have searched the web for the afore mention characters and found that
"many" web sites are displaying text in this manner For example here is
one that does so:


http://www.artima.com/forums/flat.jsp?forum=152&thread=159914

The first paragraph starts off this way:

“Using ASP.NET 2.0’s new GridView control with the new
ObjectDataSource ”

same messed up text in firefox


Using ASP.NET 2.0’s new GridView control with the new
ObjectDataSource allows

Inserting Records Best Practice
reuse connection object with diff username password?
SqlTransaction rollback error
Querying a Dataset
DataAdapter.Update bug updating Child table via Relations / RowState corrupted?