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

Question

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

Nilanka Dharmadasa · Answer

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 Rathore · Answer

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 Dharmadasa · Answer

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 Rathore · Answer

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 Dharmadasa · Answer

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 Rathore · Answer

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 Dharmadasa · Answer

hi ankit did a small change in the code. Get this.

Nilanka Dharmadasa · Answer

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.