Multiple parent nodes

[tomk10]

I'm creating an xml file from some data and I'm geting repeating parent
nodes in the xml file. Not sure where I'm going wrong?

<?xml version="1.0" standalone="yes"?>
<MyTestData xmlns="http://www.mytestdata.com/list_data.xsd">
<Wigets>
<Wiget>Muffler Bearing</Wiget>
</Wigets>
<Wigets>
<Wiget>5 gallons of prop wash</Wiget>
</Wigets>
<Wigets>
<Wiget>gonkalator armature</Wiget>
</Wigets>
<Gizmos>
<Gizmo>hole-mover</Gizmo>
</Gizmos>
<Gizmos>
<Gizmo>bulkhead remover</Gizmo>
</Gizmos>
</MyTestData>


ArrayList alWigets = new ArrayList();
ArrayList alGizmos = new ArrayList();
alWigets.Add("Muffler Bearing");
alWigets.Add("5 gallons of prop wash");
alWigets.Add("gonkalator armature");
alGizmos.Add("hole-mover");
alGizmos.Add("bulkhead remover");

DataSet ds = new DataSet("MyTestData");
ds.Namespace = "http://www.mytestdata.com/list_data.xsd";

DataTable dtWigets = new DataTable("Wigets");
DataTable dtGizmos = new DataTable("Gizmos");
dtWigets.Columns.Add("Wiget");
dtGizmos.Columns.Add("Gizmo");

string[] myWiget = new string[1];
string[] myGizmo = new string[1];

for (int i = 0;i < alWigets.Count; i++)
{
myWiget[0] = alWigets[i].ToString();
dtWigets.Rows.Add(myWiget);
}
for (int i = 0;i < alGizmos.Count; i++)
{
myGizmo[0] = alGizmos[i].ToString();
dtGizmos.Rows.Add(myGizmo);
}

ds.Tables.Add(dtWigets);
ds.Tables.Add(dtGizmos);

ds.WriteXml("stuff.xml");

[Cerebrus99]

Hi Tom,

Your XML file seems kinda strange to me. You need to define a proper
structure. I would like to see the XSD you're using, thought. You might
use this format in your stuff.xml file: (And by the way, it's spelled
"Widget" ;-))

<?xml version="1.0" standalone="yes" ?>
<MyTestData xmlns="http://www.mytestdata.com/list_data.xsd">
<AllWidgets>
<Widget>Muffler Bearing</Widget>
<Widget>5 gallons of prop wash</Widget>
<Widget>gonkalator armature</Widget>
</AllWidgets>
<AllGizmos>
<Gizmo>hole-mover</Gizmo>
<Gizmo>bulkhead remover</Gizmo>
</AllGizmos>
</MyTestData>

See if this helps. ;-)

[tomk10]

Thanks for your reply, The strange xml is my problem...why does
ds.WriteXml produce this strange xml structure?

[Cerebrus99]

Hi Tom,

The problem as I see it is that your Dataset is an Untyped dataset.
This means that it doesn't have an associated schema.
Setting
ds.Namespace = "http://www.mytestdata.com/list_data.xsd";
will not help in this regard.

You need to create an appropriate schema that defines the structure of
the XML you want to create. Then read the schema into the dataset. This
will create a Typed Dataset. An example :
------------------------------------------
DataSet ds = new DataSet("MyTestData");
string filename=@"..\..\list_data.xsd"; // The location relative to
the Bin\Debug folder.
XmlTextReader xtr = new XmlTextReader(filename);
// Read the schema into the DataSet and close the reader.
ds.ReadXmlSchema(xtr);
xtr.Close();

ds.Namespace = "http://www.mytestdata.com/list_data.xsd";

:
:
// Proceed with filling the datatables.
:
:
ds.WriteXml("stuff.xml");
------------------------------------------
This works to produce the format of XML that I suggested. So, to
reiterate, the key here is to determine the exact format of XML you
want, then create a schema for that. Then read that schema into the
Dataset, *before* you start filling in data into the Dataset.

Hope this helps,

Regards,
Cerebrus99.