If u want to store ‘(Single Quotes) on database, you should replace the Textbox value containing Single Quotes (‘) with double Single Quotes(‘’) just before saving Textbox value.
Just convert ‘ to ‘’
Ex: if Textbox named txtAddress contain value with Single Quotes(‘), then u should write below code.
txtAddress.Text = Replace(txtAddress.Text, "'", "''")
Note:- While retrieving data from Database, you did not need to convert ‘’ to ‘.
You can assign converted Textbox value to itself, or any other string variable.
