Solved: add cotation in database c# asp.net

[shamsam1]

i am adding some values to database like address it consists of single cotes

ex "abc's 5'4"

while adding to database i am removing single cotes by replace command ("'","") ..in database value will be stored as "abcs 54"

so when retrieving the values i want to display single cote..."abc's 5'4"

c# asp.net with mysql databse

can some body help me regarding this

[shamsam1]

solved replace("'","''")