Streaming an XML into a datagridview

Chris Johnson

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.

6 Replies

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

Chris Johnson10y ago
Thanks again Ali, I'll give it a try.
ali tuncer10y ago
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 Johnson10y ago
Thanks so much for your help so far Nishant.
Nishant Mittal10y ago
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 Johnson10y ago
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 Mittal10y ago
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();