how to avoid special characters display in listview control

Question

Hi to All,

I have one problem, i have sql database in this table one colume is having special character, if am tring to display the data its giving error

like "Incorrect syntax error 's'."

For example data like this "Allari Naresh's 'ARRJJ' In Tamil "
 
its raising this type of error "

Incorrect syntax near 'ARRJJ'.

"

so please help to me to avoid this kind of errors.

Am using listview control to display the whole data.