How to convert string to XML in C sharp?

Question

0.00/5 (No votes)

See more:

I have string in my program like

XML

<table1>
</table1>
<table2>
</table2>
<table3>
</table3>

now how to convert it in xml document format?

i can not use Loadxml command because it throws multiple root element error..please help me....

Posted 19-Oct-10 23:25pm

Sugato Pal

Updated 20-Oct-10 0:05am

#realJSOP

v2

Add a Solution

Comments

Andreas Gieriet 20-Oct-10 5:46am

Hello Sugato Pal,
Please review your example and properly escape so that we see the real data - there seem to be missing data...
What is the required result type? Do you want to store it in a file or have an object to the root node?
Add some sample C# code that you have tried out so that one can identify what went wrong with your approach.
Cheers
Andi

Sugato Pal 20-Oct-10 8:06am

yeah i know that for working with loadxml we need one tag here.I have written one web service which will fetch data from backend and send to client in xml doc format (with out newdataset tag) for that i have done folllowing steps:
1.fetching dataset from backend(say loDs is a dataset) 2.Use Getxml() to convert it in string xml document.
3.now i'm using loadxml an using this i'm getting
<newdataset>
<table1>
</table1>
<table2>
</table2>

Now i have to delete the new dataset tag so i'm taking firstchild.Innerxml to remove the Newdataset tag.But doing this the output i'm getting is in string xml format but i want it in Xml doc format..
4.so i have one string value which dont have any root element
(i.e <newdataset> )..So how i convert it in Xml doc format with C sharp code is there any other way instead of using Load Xml ..Please suggest somthing.I am terribly stuck.Time is running away.My client want this output data without the Newdataset tag.please help me....

4 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)

#realJSOP · Accepted Answer · 2010-10-20T00:07:00

Solution 1

You need to add a root element, like so:

XML

<root>
    <table1 />
    ...
</root>

After you do that, LoadXML should work just fine.

Posted 20-Oct-10 0:07am

#realJSOP

Comments

Hiren solanki 20-Oct-10 7:33am

true answer downvoted, let me counter vote.

Tarun.K.S · Accepted Answer · 2010-10-20T00:30:00

you need to add a root element to your string.

Every XML should have a root element or else it will give u an error.

VB

dim xmlString as string
xmlString="<RootTable>
             <table1>
             </table1>
             <table2>
             </table2>
            </RootTable>"

and if you cant get the root element in the string, then just append it to your string

VB

dim newString as string
newString="<table1>
</table1>
<table2>
</table2>
<table3>
</table3>"

then,

VB

dim myXmlString as string="<RootTable>" & newString & "</RootTable>

then

VB

dim xmlDoc as new xmlDocument
xmlDoc.LoadXML(myXmlString)

Now it should work!! :)

Sugato Pal · Accepted Answer · 2010-10-20T01:53:00

yeah i know that for working with loadxml we need one <root> tag
here I have written one web service which willfetch data from backend and send to client in xml doc format (with out newdataset tag) for that i have done folllowing steps:

1.fetching dataset from backend(say loDs is a dataset)
2.Use Getxml() to convert it in string xml document.
3.now i'm using loadxml an using this i'm getting

XML

<NewDataSet>
<table1>
</table1>
<table2>
</table2>
</NewDataSet>

Now i have to delete the new dataset tag so i'm taking firstchild.Innerxml to remove the Newdataset tag.bt doing this the output i'm getting is in string xml format but i want it in Xml doc format..
4.so i have one string value which dont have any root element (i.e

XML

<NewDataSet>
</NewDataSet>

)..So how i convert it in Xml doc format with C sharp code is there any other way instead of using Load Xml ..Please suggest somthing.I am terribly stuck.Time is running away.My client want this output data without the Newdataset tag.please help me....

Sugato Pal · Accepted Answer · 2010-10-21T04:16:00

I think i hav the solution..i have solved that problem just adding one line in my c sharp code.

myDatas.DocumentElement.SetAttribute("xmlns", "WebService");

It will add namespace with the

<NewDataSet>

tag..so no need to remove it..Thanks every body for the help..if any body has better solution then feel free to share here.

How to convert string to XML in C sharp?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0