Problems with getting XML into dataset???

[acool]

I am using the following code to take a simple XML string and put it into a
dataset:

DataSet ds = new DataSet();
ds.ReadXml(new StringReader(document));

It puts the XML into a dataset alright but in transforms each and every node
into a separate table when it needs to be a row. in other words the parent
node "account needs to be the table and the nodes under it need to be the
rows. s it my XML or do I need to change my code or parameters or what??

The XML takes the basic form of:

<account><accountcategorycode name="name_1">1</accountcategorycode>
<accountclassificationcode name="name_1">1</accountclassificationcode>
<accountnumber>accountnumber_1</accountnumber>
<accountratingcode name="name_1">1</accountratingcode>
<address1_addresstypecode name="name_1">1</address1_addresstypecode>
<address1_city>address1_city_1</address1_city>
<address1_country>address1_country_1</address1_country>
<address1_county>address1_county_1</address1_county>
<address1_fax>address1_fax_1</address1_fax>
<address1_freighttermscode name="name_1">1</address1_freighttermscode>

<address1_latitude>1.0</address1_latitude><address1_line1>address1_line1_1 </
address1_line1>
<address1_line2>address1_line2_1</address1_line2>
<address1_line3>address1_line3_1</address1_line3>
<address1_longitude>1.0</address1_longitude>
<address1_name>address1_name_1</address1_name>
<address1_postalcode>address1_postalcode_</address1_postalcode>
</account>

[Cor Ligthert]

Hi Acool,

After a long time searching, I finally was so very easy.

I hope this helps?

Cor

Serialize
using System.IO;
\\\\
StringWriter sw = new StringWriter;
ds.WriteXml(sw);
string mystring = sw.toString;
///
Deserialize
\\\
StringReader sr = StringReader(mystring);
DataSet ds2 = new DataSet;
ds2.ReadXml(sr);
///

[acool]

Yeah, that doesn't do anything not to mention the code is FILLED with
syntactical errors.
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:eJ**************@TK2MSFTNGP12.phx.gbl...

Hi Acool,

After a long time searching, I finally was so very easy.

I hope this helps?

Cor

Serialize
using System.IO;
\\\\
StringWriter sw = new StringWriter;
ds.WriteXml(sw);
string mystring = sw.toString;
///
Deserialize
\\\
StringReader sr = StringReader(mystring);
DataSet ds2 = new DataSet;
ds2.ReadXml(sr);
///

[Cor Ligthert]

>Yeah, that doesn't do anything not to mention the code is FILLED with

syntactical errors.

Hi Accool are you not able to edit those simple () and that "new" what is
forgotten on one place.
It is not that we made your code here.

I changed it fast from VB to C# in this message

Are you sure you understand it?

In VB it works as a train and now I did it in the IDE I think also in C#.

Cor

[acool]

I understand that it didn't work and I found an alternate solution.
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Yeah, that doesn't do anything not to mention the code is FILLED with
syntactical errors.

Hi Accool are you not able to edit those simple () and that "new" what is
forgotten on one place.
It is not that we made your code here.

I changed it fast from VB to C# in this message

Are you sure you understand it?

In VB it works as a train and now I did it in the IDE I think also in C#.

Cor

[Cor Ligthert]

Hi acool,

I understand that it didn't work and I found an alternate solution.

When you do not understand code, it is good to try it, the least that can
happen is that you learn from it.

Cor