PDA

View Full Version : Solved: add cotation in database c# asp.net



shamsam1
10-30-2008, 03:14 AM
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
10-30-2008, 03:24 AM
solved replace("'","''")