An awkward script problem

roxettechbin

I wrote the following code in the 1.aspx screen button click event in ASP.NET:
Dim scriptStr As String = "<script>" + vbCrLf
scriptStr += "document.all.tbxitemJap.value = document.all.tbxitemJap.value +'" + DB + "';"
scriptStr += "</script>"

Among them, DB is a variable, which is obtained from the database.
But there may be such data in my database Lao People's
For this kind of data with ', this script will report an error, what should be done?
Is it necessary to convert this variable into ASCII code, and then turn it back?

660044

Just turn it around.

saintfrosty

DB = DB.replace("'","\'").replace(Chr(13),"").replace(chr(10),"\n")

roxettechbin

In DB, 'does not necessarily appear at position 13
How to turn back after turning like this
DB also shows on the screen

660044

See the following example for escaping in js:

var str="Lao People\'s ";
document.write(str);

roxettechbin

OK thanks