Best way to Save Listview Items in Database

Question

0.00/5 (No votes)

See more:

, +

I am making app in WPF C# which connects with SQL Server. There is a listview in my app and i want to save each row in listview to database. My Listview consist of 4+ Column. So tell me the best way to save all rows in database at once. Usually i want this to happen on onclick event.

I tried this method:

C#

for (int i = 0; i < listview.Items.Count; i++)
{
String abc = listview.Items[i].Subitem[i].Text;
//other varables
}

But not working. I tried it with Listviewitem and with for and foreach loop. But underlined red color mean error is coming when i type .Text or Subitem or item[i]. Kindly tell the solution.

Posted 26-Nov-14 0:53am

Burhan Ahmed

Updated 26-Nov-14 1:36am

Add a Solution

4 solutions

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)

ClimerChinna · Answer 1 · 2014-11-26T00:58:00

Solution 1

check below links

[how-to-export-data-from-listview-and-save-in-database]

Store listview data at sql database[^]

Posted 26-Nov-14 0:58am

ClimerChinna

Updated 26-Nov-14 1:00am

v3

Comments

Burhan Ahmed 26-Nov-14 7:29am

i type this listView1.Items[i].SubItems[3].Text and error will appear why

Burhan Ahmed 26-Nov-14 7:37am

can u explain it more

Burhan Ahmed 26-Nov-14 7:40am

it gives error that object does not contain defination for Text. It means Text property does not exist

Richard MacCutchan · Answer 2 · 2014-11-26T01:02:00

Solution 2

The http://msdn.microsoft.com/en-us/library/system.windows.forms.listviewitem.listviewsubitem(v=vs.110).aspx[^] does not have a Text property.

Posted 26-Nov-14 1:02am

Richard MacCutchan

/\jmot · Answer 3 · 2014-11-26T02:10:00

Solution 3

Another way..

C#

foreach (ListViewItem item in listView1.Items)
{
   String abc = Convert.ToString(item.SubItems[1].Text);
//etc etc
 }

Posted 26-Nov-14 2:10am

/\jmot

Updated 26-Nov-14 2:11am

v2

Comments

Burhan Ahmed 26-Nov-14 8:24am

http://www.codeproject.com/Questions/846829/How-to-get-values-from-Class

This is link where i added my xaml + cs code. Now tell me how i get item values and SubItems[1].Text is giving error

Burhan Ahmed 26-Nov-14 8:29am

SubItems works in WinForms not in WPF

aravinth santosh · Answer 4 · 2014-11-26T04:03:00

Solution 4

I think you are manually typed this line.

String abc = listview.Items[i].Subitem[i].Text;

The line should be,

String abc = listview.Items[i].SubItems[i].Text;

SubItems and not Subitem