Funny Character in String 1

[Trob70]

I have a web page written in web express 2012 using vb.net
using webform


i am copying a text field from an existing database and adding it to another

Dbe = New DAO.DBEngine()
Db = Dbe.OpenDatabase(svr)

etc
Rs.Fields("Title").Value = TextBox4.Text
Rs.Fields("Composer").Value = TextBox9.Text

textbox4 contains as below
notice the ' above the o

Aclamación 1

when this line is written out to the title field it converts it to asc 243 and shows 243 rather than
the o with a ' above it

Is there any way to get it written out correct it...


Regards Trob70

 

[xwb]

Possibly the code page. By default, it is UTF-8. Try changing it to windows-1252.

 

[Trob70]

xwb Thanks for your reply

I am not real sure how to carry out your idea.

Basically what i am doing is just

load an access database into a gridview

then transfer content to a textbox

gridview looks like

Aclamación 1 (misa Querubines Para



in the textbox i get


Aclamación 1 (misa Querubines Para


Dim x As String
x = GridView1.Rows.Cells(1).Text
TextBox4.Text = x




Note.....
if i just manually copy and paste it works fine


Appreciate any ideas

Regards Trob70

 

[jbenson001]

Try decoding the string before you display it:

Server.HTMLDecode(<your field here>)

 

[Trob70]

jbenson001


Thanks very much , this worked fine

Dim x As String
x = Server.HtmlDecode(GridView1.Rows.Cells(1).Text)
TextBox4.Text = x


Much appreciated.. it was driving me ''mad''


Regards Trob70

 

[jbenson001]

Glad to help