9 replies to this topic

[Tonchi]

I have XML file that I have write with XMLWritter class within my project. How to read that XML file in console?
I have try many codes but they are not working.

[VNFox]

Can you just use DataSet and use method like LoadXML or ReadXML ... then it returns a Dataset ... then you can parse it from there through rows and columns. It has been a while for me to play with xml.

[Tonchi]

I was last playing with XML before one year. I forget 90% of everything.
Can you give me an example?

[VNFox]

Here is an example:
http://support.microsoft.com/kb/311566

[Tonchi]

Not helpfull. Let me specify my need.
First, I need to read the name of the XML document,
second, I need to read root element,
third, I need to read attribute elements and their values.

Those 3 things need to be written in console separated.

[VNFox]

Dataset should contains everything you need. All you have to do is to debug or loop through and print out the column name, and look in the debug table. Your root should be the Datatable.

[Tonchi]

XmlDocument doc = new XmlDocument();
		 doc.Load("employees.xml");
		 XmlNodeList customers = null;
		 customers = doc.SelectNodes("Employees");
		 foreach (XmlNode customer in customers)
		 {
			 Console.WriteLine("ID = {0}, Ime = {1}, Prezime = {2}", customer.Attributes["ID"].Value, customer.Attributes["FirstName"].Value, customer.Attributes["LastName"].Value);
		 }
		 Console.ReadKey();

This is the code I found. It is easier to work than with DataSet and DataTable.
The only problem is this:

[VNFox]

Then I guess all you have to do is write a wrapper ... eg: printValue(object value)

if (value != null) { // print it out ... }

then wrap around all the column names that you want to print it out.

[Tonchi]

try
		 {
			 XmlDocument doc = new XmlDocument();
			 doc.Load("employees.xml");
			 XmlNodeList customers = null;
			 customers = doc.SelectNodes("Employees");
			 if (customers != null)
			 {
				 foreach (XmlNode customer in customers)
				 {
					 if (customers != null)
					 {
						 Console.WriteLine("ID = {0}, Ime = {1}, Prezime = {2}", customer.Attributes["ID"].Value, customer.Attributes["FirstName"].Value, customer.Attributes["LastName"].Value);
					 }
				 }
			 }
		 }
		 catch (Exception e)
		 {
			 Console.WriteLine(e.ToString());
		 }
		 Console.ReadKey();

Line 28 is where I print out values of nodes. And if I make like this:

if (customer != null)
{
...
}

then I get the same exception but this time for line 26 which is if statement.
And if I print out only customer.Name then application is executing normaly and I get the name of the node.

[VNFox]

I meant this:
printValue(customer.Attributes["ID"].Value)

and do the rest for all of them.