find an replace a particular character with another in strin

Whenever, you add a name to the database instead of just storing 'name' store instead:

name.Replace("'", "''")

In other words, you need to double the apostrophes.

If the name doesn't contain an apostrophe, the string.Replace method has no effect.