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
pelegI 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;
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
pelegI dnt know what is the problem
, but try using parametersDim Sql = "UPDATE general_info SET data=@value WHERE id=1"
SqlCommand.Parameters.Add("@value", SqlDbType.VarChar, 400).Value = "your value"
Hope this helps;