load data of listview into data table

Question

3.00/5 (1 vote)

See more:

i have a listview in my windows form and i want to load each row of my listview to data table,
please help me
regards
bunzitop

Posted 16-Mar-13 2:54am

bunzitop

Add a Solution

Comments

[no name] 16-Mar-13 9:13am

Please show what have you tried ?

bunzitop 16-Mar-13 9:27am

DataTable dt = new DataTable();

foreach (ListViewItem item in listView1.Items)

{

table.Columns.Add(item.ToString()); //For adding column namescol

foreach (var it in item.SubItems) //For adding row values

dt.Rows.Add(it.ToString());

}

[no name] 16-Mar-13 9:20am

Help with what? You did not ask a question or describe any kind of a problem.

bunzitop 16-Mar-13 9:27am

i have already stated with my problem,
i have a listview and my requirement is to load the listview items to datatable
hope you have understood my problem

[no name] 16-Mar-13 9:35am

No... as a matter of fact, you did not state any kind of a problem. If your requirement is to load items to a datatable, then do it. What exactly is the problem? We cannot read your mind. You have to tell us what the problem you are having is. Where is the code that demonstrates your problem? Do you get any errors when you run your code?

bunzitop 16-Mar-13 9:38am

DataTable dt = new DataTable();
foreach (ListViewItem item in listView1.Items)
{
table.Columns.Add(item.ToString());

foreach (var it in item.SubItems)

dt.Rows.Add(it.ToString());
}
I tried this
but didnt meet my requirement.
sorry for not posting my code
the above code inserted row as column of table and column as row of list view

[no name] 16-Mar-13 9:48am

Okay so improve your question and post your code. While you are doing that. CLEARLY explain why this does not meet your requirement. We can't see your code, your project and we still cannot read your mind. What is in your listview and what is in your datatable. Post the error messages that you are getting. First thing that jumps out at me is that I do not see anywhere where you are adding new rows to your table.

wingzero007 16-Mar-13 15:54pm

What is it exactly that is not working? Where does it crash, at what line? And What is the error message?

ridoy 17-Mar-13 2:31am

See http://stackoverflow.com/questions/11159767/how-to-convert-listview-to-datatable

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)