WPF ListView Iteration

Question

0.00/5 (No votes)

See more:

Hi I have rather strange requirement of gathering data through bunch of xml files and binding it to Listview(WPF one). this part was somehow completed . but the challenge I have is have to export the listviewitems to an Datatable and from there to Excel or csv

I googled , but with no luck ,is there any suggestions or examples ?

Just saw the replies ....I think i need to be more specific on my problem

I have bunch of files(xml ones) from which i gather cretain node values and bind it to Lisview.For this i have used XMl to linq technique and have binded them

below is snippet

C#

var MethodList = from Elements in XpedDoc.Descendants(ns + "Method")
                                 select Elements;
 foreach (var XpedElement in MethodList)
               { do something }

LstNodeView.Items.Add(ndXped);// adding to my list view  where ndXped is custom class

Now after this I want export all listitems into datatable to export into Excel file 

Hope this helps

Posted 19-Jun-13 14:54pm

mpslnt

Updated 19-Jun-13 18:58pm

v3

Add a Solution

Comments

Ron Beyer 19-Jun-13 21:01pm

Why the intermediate data table? Is it being displayed somewhere?

mpslnt 20-Jun-13 1:33am

Yep....... it is being exported to excel file

koleraba 19-Jun-13 21:35pm

I am afraid I don't understand your question. I guess you have to export the data which is bind to your ListViewItems not the actual ListViewItems. Since your ListView is generated from items read from xml I don't understand what the problem is.

mpslnt 20-Jun-13 1:34am

I do read from about 100 Xml files .. thats the reason...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sadique KT · Answer 1 · 2013-06-20T23:28:00

xml to data table

C#

DataTable dt=new DataTable();
DataSet ds = new DataSet();
StringReader reader = new StringReader(Xmlstring);
ds.ReadXml(reader);
dt = ds.Tables[0];

Data Table to Xml

C#

MemoryStream str = new MemoryStream();
dt.WriteXml(str, true);
str.Seek(0, SeekOrigin.Begin);
StreamReader sr = new StreamReader(str);
string Xmlstring= sr.ReadToEnd();

Hope you will get solution ...

[Edit]Code block formatting added[/Edit]