[RESOLVED] Help Reading DataSet from XML

[brandoom]

I have the following XML file:

<map gsid="101">
	<name> Dalian Plant </name>
	<briefing locid="LOADINGSCREEN_MAPDESCRIPTION_dalianplant">map description for modders maps not localized (english only)</briefing>
	<music> common/sound/menu/music/load_CH_music.ogg </music>
	<modes>
		<mode type="gpm_cq">
			<maptype ai="1" players="16" type="doubleassault" locid="GAMEMODE_DESCRIPTION_doubleassault">Unlocalized test for this mode on this map</maptype>
			<maptype players="32" type="headon" locid="GAMEMODE_DESCRIPTION_headon">Unlocalized test for this mode on this map</maptype>
			<maptype players="64" type="headon" locid="GAMEMODE_DESCRIPTION_headon">Unlocalized test for this mode on this map</maptype>
		</mode>

		<mode type="gpm_coop">
			<maptype ai="1" players="16" type="doubleassault" locid="GAMEMODE_DESCRIPTION_COOP_doubleassault">Unlocalized test for this mode on this map</maptype>
		</mode>
	</modes>
</map>

And this code:

			string gpm = "";
			System.Data.DataSet ds = new System.Data.DataSet();
			ds.ReadXml(MapFileName);

			foreach(System.Data.DataRelation myRelation in ds.Tables["mode"].ChildRelations)
			{
				foreach(System.Data.DataRow myRow in ds.Tables["mode"].Rows)
				{
					foreach(System.Data.DataRow childrow in myRelation.ChildTable.Rows)
					{
						gpm = gpm + myRow["type"] + "," + childrow["players"] + "/";
					}
				}
			}

			return gpm;

I need my output to be:

"gpm_cq,16/gpm_cq,32/gpm_cq,64/gpm_coop,16"

but it's not working the way I want.

[umilmi81]

Is there a reason you are accessing an XML file through a data source?

The XML itself is fairly powerful.

            XmlDocument xd = new XmlDocument();
            xd.Load(@"c:\temp\vbforums.xml");

            
            foreach (XmlElement xMode in xd.GetElementsByTagName("modes"))
            {
                foreach(XmlElement xMapType in xMode.GetElementsByTagName("maptype"))
                {
                    Console.WriteLine(xMapType.GetAttribute("players"));
                }
            }

[brandoom]

Thanks. I don't need a dataset, it was just an easy way to import the xml into a grid to see if it would help me visually.

How do I reference the "gpm_cq" on the same line as your Console.Writeline?

I tried pulling up all the intellisense properties on xMode and xMapType and I'm looking through the Locals window but I haven't figured it out yet.

[umilmi81]

Thanks. I don't need a dataset, it was just an easy way to import the xml into a grid to see if it would help me visually.

How do I reference the "gpm_cq" on the same line as your Console.Writeline?

I tried pulling up all the intellisense properties on xMode and xMapType and I'm looking through the Locals window but I haven't figured it out yet.

            XmlDocument xd = new XmlDocument();
            xd.Load(@"c:\temp\vbforums.xml");

            
            foreach (XmlElement xMode in xd.GetElementsByTagName("modes"))
            {
                foreach(XmlElement xMapType in xMode.GetElementsByTagName("maptype"))
                {
                    Console.WriteLine(xMapType.GetAttribute("players"));
                    Console.WriteLine(xMode.GetAttribute("type"));
                }
            }

Rate my post if it helped you.

[brandoom]

I tried that already and it returns a blank string. Any other ideas?

[umilmi81]

I tried that already and it returns a blank string. Any other ideas?

It should work. Remember it's case sensitive. So "type" is different from "Type" is different from "TYPE". Check your XML again.

[brandoom]

Sorry but it doesn't work. I know it's case sensitive.

? xMode.GetAttribute("type")
""
? xMode.GetAttribute("Type")
""
? xMode.GetAttribute("TYPE")
""

[brandoom]

Problem Solved.

Notice the top line needs to be "mode" NOT "modes".

Thanks for helping me out on this one. I have my head wrapped around the xml now.

			foreach (XmlElement xMode in xd.GetElementsByTagName("mode"))
			{
				foreach(XmlElement xMapType in xMode.GetElementsByTagName("maptype"))
				{
					Console.WriteLine(xMapType.GetAttribute("players"));
					Console.WriteLine(xMode.GetAttribute("type"));
				}