Storing special character(s) in SQL Server through ASP.NET

By default it wont take '. U need to replace it by ' ' while storing into database but dont worry it will  store the ' only.

Use the following code:

Say u want customer name should accept '. like peter's.So the time of saving use the following convertion in your pagebehind class(.aspx).

txtCustomerName.Text.Replace(" ' ", " ' ' ").Trim()

Thnx Rakrus for your reply.

But still it's not working properly. Here i'm giving my code

string name=Server.HtmlEncode(txtName.Text);

string strsql="Update Rough Set Name='"+name.ToString()+"' Where Active=1";

string strTxtVal=Server.HtmlEncode(TextBox1.Text);

use the above encoded value to insert into database.

While retrieving the save value from database you need to decode it and set it to textbox.

TextBox1.Text=Server.HtmlDecode(encoded textbox value (i.e value from database))

I think you got it.

Plz explain it........