Selectd child nodes only show in data grid from XML document ....

Ankit Rathore

Hi Guys,
I am very New in C# so please don't mind if I ask the silly question.........please cooperate me .

My problem is that suppose I am having very big XML file with lots of child nodes inside, and from them I have to select 2 or 3 child from the list,
What would be the approach to get data in datagrid.

Suppose I am having XML document is like:- in which I have to show only 3 child nodes like BoxName , BoxDesc, Location and Status only then how can we Show these in datagrid.
Please Help me ...........


       101
       Student Records
       5th Floor, Self 1
       10/12/2008
       10/12/2009
       Destroyed
       Bangalore- 2009 Marksheets


       201
       College Records
       6th Floor, Self 1
       10/12/2007
       10/12/2009
       Checked
       BHOPAL- 2009 Marksheets


       301
       PO Records
       5th Floor, Self 1
       10/12/2006
       10/12/2007
       Checked
       Bangalore- 2009 SOAP



       401
       PR Records
       5th Floor, Self 1
       10/04/2008
       10/08/2008
       Destroyed
       Bangalore- 2009 Soap

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa16y ago
I know is it different. I wrote the code to the new xml not for the old one. did u run it and see? if so wat;s the problem with that?
Ankit Rathore16y ago
Hi Niki,
Have u seen my XML file .........
I have to print from this XMLfile ("BoxName, BoxDesc, Location, StorageDate, StorageUntil, Status")
ok u Got it ......

Please see my XML file at once it is totally different from earlier one which I posted two days before .


        101
        Student Records
        5th Floor, Self 1
        10/12/2008
        10/12/2009
        Destroyed
        Bangalore- 2009 Marksheets


        201
        College Records
        6th Floor, Self 1
        10/12/2007
        10/12/2009
        Checked
        BHOPAL- 2009 Marksheets
Nilanka Dharmadasa16y ago
They have hardcoded everything in this code.

But you want to do it without hard coding anything. This code doesnt suit your need.

Please understand your requirement and tel it to me. Otherwise both of us will waste our time.
Ankit Rathore16y ago
Actually What kind of approach I am looking for... just gone through that sample example ......... actually I am not able to understand it properly Here they are fetching the "productCode" from "inventory.xml" file........ XmlNodeList elements = inventory.SelectNodes("//inventory/items/item"); foreach (XmlElement element in elements) { string productCode = element.GetAttribute("productCode");int quantitySold = Int32.Parse(element.GetAttribute("quantity")); string xPathExpression = "//items/item[@productCode='" + productCode + "']"; XmlElement inventoryItem = (XmlElement)inventory.SelectSingleNode(xPathExpression);
*/
Nilanka Dharmadasa16y ago
Then you should tell me how are you goin to input the required columns to the application. If you tell that, I can wrtie the code without hard coding the column names. Otherwise it's impossible. How does the application know the columns you want?
Ankit Rathore16y ago
Hi Niki,
Please just gone through my new XML,
and the code u sent me is not like that which I am looking for ........
Suppose if I have add 100 columns then what happen I am not going to write IF condition for each column.
By this the performance of the program is also reduce.

Please give the another solution.......
Nilanka Dharmadasa16y ago
hi ankit,

did a small change in the code. Get this.
Nilanka Dharmadasa16y ago
Hi Ankit,

You are back.

Find my answer for your solution.

I have hardcoded the columns you need. If you want to change them you can do that by simply change that.

If you find this answer useful, please do not forget to tick 'Do you like this answer' checkbox.