Streaming an XML into a datagridview

Question

Hi all I am streaming this XML file into a windows forms app. Can someone give me a clue as to where to start? I am at a loss as to how to populate a Datagridview. As the file is streaming I can see all the data in say a message box so I have that bit right but I have tried everything to populate a datadridview and failed. Please put me out of my misery folks :-( Repeating XML sections. -

Chris Johnson · Answer

Thanks again Ali I'll give it a try.

ali tuncer · Answer

Hi Chris I remember you had a different question about reading this XML file before. It had some error. After reading to dataset I think you can also get data this way : ds.Tables[vShipperNumber]ds.Tables[vReceivingPlant] and so on.. If you want to bind to a gridview I guess you can merge them into a single datatable.. Here is an example : http://stackoverflow.com/questions/12278978/combining-n-datatables-into-a-single-datatable I don't know if it is the best way but you can give it a try..

Chris Johnson · Answer

Thanks so much for your help so far Nishant.

Nishant Mittal · Answer

Hi Chris In that case u need to 1)read that particular section 2) create an xml file for the same 3) Loan into datatable 4) Show it on the grid Mean while let me also find some good solution for the same.As I have never implemented the same :)

Chris Johnson · Answer

Hi Nishant the problem I have is that I am unsure how to load just that section of XML the file itself is huge with many sections so my question is how would I go about loading just that particular section of the XML starting with into Datagridview?

Nishant Mittal · Answer

Hi Chris You can use below code DataSet ds = new DataSet(); ds=new DataSet(); ds.ReadXml(XML path); DataTable dt = ds.Tables[0]; grdTable.DataSource=dt; grdTable.DataBind();