C# read xml data information

Question

Hi!

I am new to C#. Now I have one project which needs to read a 130kb xml file, and display some of its data with a GUI.
What component I should use to display the data? I need a combobox to select between different datasets.
Anyone can help. Thanks a lot.....Thanks

BR
Emma

Emma Emma · Answer

Hi Here is my result. I can make it in ListBox. But the first three should be in one row. not column. That is why I want it in DataGridView. Can anyone help me with this: only select part of the nodes and every node only display three items... Thanks //// three items from one node 100 A10 Low Filter

Emma Emma · Answer

Hi I know this. This will take all the nodes information from xml. Now I only need to get some of the nodes not all. That is why I think I need to use XPath. But I do not know how to connect XPath with datagrid.... Thanks Emma

Shankar M · Answer

Hi Emma Can you Please try checking this http://csharp.net-informations.com/xml/xml-to-datagridview.htm

Emma Emma · Answer

Hi Thanks you all. But I think my problem still remains: How to put the selected items by using XPath to datagrid ...I can let it display in textbox..or listview...but I want it in DataGridView... thanks

Shankar M · Answer

Hi Emma Hope this link might help you. http://www.c-sharpcorner.com/UploadFile/c5c6e2/binding-xml-data-to-listview-control-dataset-approach/

Jignesh Trivedi · Answer

hi Please refer following link it might help you. http://support.microsoft.com/kb/308333 http://www.codeproject.com/Articles/9494/Manipulate-XML-data-with-XPath-and-XmlDocument-C http://shahvaibhav.com/how-to-read-xml-attributes-using-xpath-in-c/

Emma Emma · Answer

but..do you know how to work with XPath...itlooks like it is the right function to use

Emma Emma · Answer

The xml is generated by another application... I tried using ds.select(ID) but it said no select funciton in this library ...sorry I do not know how to work with C# BR

Ravikumar G · Answer

How the XML is generating ? and it is in Same application of different?

Ravikumar G · Answer

No After writting: datasetObj.ReadXml(path); datasetObj.select(username); like above u can write query on dataset.

Emma Emma · Answer

Sorry..I can not upload my xml file..strange thing .Maybe internet is not good

Emma Emma · Answer

Hi What do u mean by writing qurries...Do u mena use xpath? Thanks ...

Jignesh Trivedi · Answer

hi It only shows the first line of xml file I think reason behind we are taking first table of dataset. var dymmydataTable = ds.Tables[0]; it might be possible other datatable of the dataset has value that you required. also please share sample of your xml file.

Ravikumar G · Answer

You can also write querries on dataset to filter the records...

Emma Emma · Answer

Hi It only shows the first line of xml file. .. Do you know how xpath works? I read it online looks like it is the right tool BR

Jignesh Trivedi · Answer

hi Answer is as below 1) Yes 2) no  you do nothing after this. in above piece of code we already assign new data in to newdt data table. hope this will help you.

Emma Emma · Answer

Hi I think your idea is doable for my project. Can you tell me is newdt is a data table? After this :dataGridView1.DataSource = newdt; I should copy the data from table to dataset. Is that so? And How to do this.. I get confused ... Thanks ! BR Emma

Emma Emma · Answer

Hi Yes. I am trying to do it with the code you gave...but ..I never use C# before this gives little challenge to me... But lets see. Maybe I will make it !Thanks so much. BR Emma

Jignesh Trivedi · Answer

hi from this above code you might got the idea how to accomplish the task. I am sure that above code can help you to build your own logic.

Emma Emma · Answer

Hi. Thanks. I will try with that. Yes..I think I need my own idea to do this maybe. Difficult task . BR

Jignesh Trivedi · Answer

ok ideally you want to show first 200 and on next button click want to show next 200. right? to achieve this you have to introduced you own logic. I have try with following code it work. it might also work for you try // page index is change from your next or previous button int pageIndex = 0; int pageRecord = 200; DataTable newdt; var dymmydataTable = ds.Tables[0]; //if record is in between current if ((pageIndex + 1) * pageRecord > dymmydataTable.Rows.Count) { newdt = dymmydataTable.AsEnumerable().Skip(pageIndex * pageRecord).CopyToDataTable(); } else { newdt = dymmydataTable.AsEnumerable().Skip(pageIndex * pageRecord).Take((pageIndex + 1) * pageRecord).CopyToDataTable(); } hope this will help you.

Emma Emma · Answer

Hi Thanks again. But the problem is that my .xml file may change my program should work for different files not only one. So I can not count how many to take or to skip. The only thing I have is that the ID is different.. some is 100 -200 some is 400500... so I need to split them ...:( Hope you understand what I mean BR Emma

Jignesh Trivedi · Answer

hi there is good idea to create other datasource and assign it to data grid view. DataSet ds = new DataSet(); ds.ReadXml(@E:	est	estProject	estProject	estProject\XMLFile1.xml); //here you may specify the page numbers instead of 200. var newdt = ds.Tables[0].AsEnumerable().Skip(200).Take(200).CopyToDataTable(); datagrid1.DataSource = newdt; hope this will help you.

Emma Emma · Answer

Hi Thanks for your help first :D Yes you are right datagridview is the correct one I should use...I am doing windown based application not web.. But I have one more problem how can I get the value of the first column as I want when I press first button all the rows which 400 will show...like that... Do you know how can I get the value and compare it with like 200400? They are in one .xml file so I think maybe I need to split them into different dataset? Thanks a lot. BR Emma

Jignesh Trivedi · Answer

hi I thing you can use datagrid view control show the selected table data. DataSet ds = new DataSet(); ds.ReadXml(@E:	est	estProject	estProject	estProject\XMLFile1.xml); are you using window base application or web base application? both type of application containing datagrid. hope this will help you.