XML arabic error

Question

0.00/5 (No votes)

See more:

hi all,
i made function that convert dataset to recordset, this function takes XML string which generated from dataset.GetXML(), the error here come when dataset contains arabic values.
I want solution for this problem because i have alot of arabic data and i want to convert it to recordset.

Thanks

Posted 28-Sep-10 1:13am

rmedo

Add a Solution

Comments

Richard MacCutchan 28-Sep-10 9:03am

Quote: "the error here come when dataset contains arabic values.".
Try explaining what the error is and someone may be able to offer some advice.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

rmedo · Answer 1 · 2010-09-28T20:24:00

Solution 1

thats the error
Run-time exception thrown : System.Runtime.InteropServices.COMException - An invalid character was found in text content.

Thanks for help

Posted 28-Sep-10 20:24pm

rmedo

Comments

Toniyo Jackson 29-Sep-10 2:29am

Can you show the code how u r fetching the record?

rmedo · Answer 2 · 2010-09-28T20:33:00

i toke the code from this link http://support.microsoft.com/kb/316337[^], but i made change in GetADORS to take only XML string come from another dataset then i'm creating dataset inside the method again

<pre lang="vb">Dim xwriter As New XmlTextWriter(FileName, System.Text.Encoding.Default)
           Dim ds As New DataSet
           Dim xmlSR As StringReader = New StringReader(dsXmlString)
           ds.ReadXml(xmlSR)