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>Muffle r Bearing</Wiget>
</Wigets>
<Wigets>
<Wiget>5 gallons of prop wash</Wiget>
</Wigets>
<Wigets>
<Wiget>gonkalat or armature</Wiget>
</Wigets>
<Gizmos>
<Gizmo>hole-mover</Gizmo>
</Gizmos>
<Gizmos>
<Gizmo>bulkhe ad remover</Gizmo>
</Gizmos>
</MyTestData>


ArrayList alWigets = new ArrayList();
ArrayList alGizmos = new ArrayList();
alWigets.Add("M uffler Bearing");
alWigets.Add("5 gallons of prop wash");
alWigets.Add("g onkalator armature");
alGizmos.Add("h ole-mover");
alGizmos.Add("b ulkhead remover");

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

DataTable dtWigets = new DataTable("Wige ts");
DataTable dtGizmos = new DataTable("Gizm os");
dtWigets.Column s.Add("Wiget");
dtGizmos.Column s.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.A dd(myWiget);
}
for (int i = 0;i < alGizmos.Count; i++)
{
myGizmo[0] = alGizmos[i].ToString();
dtGizmos.Rows.A dd(myGizmo);
}

ds.Tables.Add(d tWigets);
ds.Tables.Add(d tGizmos);

ds.WriteXml("st uff.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>Muffl er Bearing</Widget>
<Widget>5 gallons of prop wash</Widget>
<Widget>gonkala tor armature</Widget>
</AllWidgets>
<AllGizmos>
<Gizmo>hole-mover</Gizmo>
<Gizmo>bulkhe ad 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("MyTest Data");
string filename=@"..\. .\list_data.xsd "; // The location relative to
the Bin\Debug folder.
XmlTextReader xtr = new XmlTextReader(f ilename);
// Read the schema into the DataSet and close the reader.
ds.ReadXmlSchem a(xtr);
xtr.Close();

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

:
:
// Proceed with filling the datatables.
:
:
ds.WriteXml("st uff.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.