details view update problem

[jjme88]

HI All,

i have a curious problem I cant work out. i have a details view control bound to a SQL2000 table on my asp.net web page. I have one particular filed that is causing me a problem when trying to update the field. the field is a text box bound to a varchar(1000) field in the database.

if i enter the text abc123 into this field on the control and hit update all is well but if i enter;
<abc123 into this field then i get an error;

XML Parsing Error: no element found
Location:

http://localhost/...../mypage.aspx

Line Number 1, Column 1:

the trouble is I will need to enter this '<' charter into the field as it will contain an html fragment to create a link.

anyone got any ideas what the problem is. Its as though '<' is an invalid charter, but I already know SQL can store such a charter no problem.

 

[jbenson001]

you have to encode the content first
ex.
dim s as string
s = Server.HTMLEncode(yourtextbox.text)