Hi,

I allow user to enter its name in a textbox, however, when the name contains apostrophe, e.g. D' Angelo, the SQL statement that update the DB will fail. I don't want to remove the apostrophe from the data, so how could I avoid the failure of executing the SQL in the web page?

Thank you.