save listview data to sql databse

Question

0.00/5 (No votes)

See more:

Hi ,
I am doing my project(desktop application) using vs2008 in c#.net & sql server2005,
i took a listview on my form & from textboxes on same form i added that data to listview ,now i want to save my listview dta to data base ..

database filds & textboxes are
description of goods,quantity,rate,per,amount,total.
the list view data should b save in this database within perticular fields....

Please provide me code sample for it

Thanks in advance

[edit]SHOUTING removed, urgency removed, textspeak removed, tags - OriginalGriff[/edit]

Posted 13-Aug-11 21:55pm

vishaalmandge

Updated 13-Aug-11 21:59pm

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 14-Aug-11 4:00am

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.
Urgency deleted: It may be urgent to you, but it isn't to us. All that your stressing the urgency does is to make us think you have left it too late, and want us to do it for you. This annoys some people, and can slow a response.
Please use English rather than txtspk.

There are a number of reasons:
1) txtspk is seen as "childish" by many members - you have a keyboard, use it. That reduces the chance of misunderstandings.
2) This is an international site. Many members come from countries where English is not their native langauge: India, China, The United States of America. If you use txtspk then is difficult if not impossible for them to understand, as most of your post will not be in any dictionary.

Mario Majčica 14-Aug-11 4:01am

I love gimmecode tag!

2 solutions

Solution 1

So the basis of the implemenation is that you:
- create a connection: SqlConnection[^] and open it
- create a command: SqlCommand[^] and use bind variables in it: SqlParameter[^]
- start a transaction: SqlTransaction[^]
- now you loop through the list view and change the values of the parameters and use ExecuteNonQuery[^] to execute the statement
- after the loop commit [^]the changes
- close the connection and dispose the objects

Posted 13-Aug-11 22:06pm

Wendelius

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)

Wonde Tadesse · Accepted Answer · 2011-08-14T16:13:00

Solution 2

Here are lists of Introduction to ADO.NET and Bind to ListBox Tutorial
1.Introduction to ADO.Net, [MSDN][^]
2.An introduction to ADO.NET[^]
3.Server-side ASP .NET Data Binding[^]

Posted 14-Aug-11 16:13pm

Wonde Tadesse