problem wih inserting test with " and '

[pelegk1]

i am inserting text from a text area like this
UPDATE general_info SET data='"+area1.value+"' WHERE id=1
the problem is that in the string i have quatation marks and astrics
how can i override the problem?
beacuse after i insert i want to show it to the user with the orignal quatation marks and astrics
thnaks in advance
peleg

[Cipher]

I dnt know what is the problem :) , but try using parameters
Dim Sql = "UPDATE general_info SET data=@value WHERE id=1"
SqlCommand.Parameters.Add("@value", SqlDbType.VarChar, 400).Value = "your value"
Hope this helps;