add data to a database from a listbox

Question

3.50/5 (2 votes)

See more:

I'm making a Windows form which allows people to select a film from different genres. I've used list boxes to display the list of films and genres. When a user selects a genre, the films from that genre are displayed in another list box. The user selects a film from that list box, then a picture from the film is displayed in a picture box and informtion for the film is displayed in a text box. I have also added a button which the user clicks, once they have selected the film, a message box is displayed with buttons, that asks if they're sure they want to choose this film. If the user clicks "Yes", the picture and info for the film are still displayed on screen as before. If user clicks "No" then the picture and info are cleared from the screen and the user can select another film.

Now I what I want to do is store that film choice in a database. So I can keep a record of the films chosen by the user. The problem is I dont know how to send data into a database based on a selection from a listbox. So for example if I selected "Inception" and confirmed my selection using the message box with buttons, is there a way to store that film choice into the database just by clicking the "Yes" button or would I need to do something different?

Posted 8-Mar-11 12:11pm

programmer1234

Add a Solution

2 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)

Michael Bookatz · Answer 1 · 2011-03-08T12:21:00

Solution 1

You need to handle the event of the click button.

Once that is handled you can get the current selected item in the listbox by listbox.SelectedItem .

All you then need to do is pass in the relevant values to a Stored Procedure in the database via ADO.net

Posted 8-Mar-11 12:21pm

Michael Bookatz

William Winner · Answer 2 · 2011-03-08T12:41:00

Do you mean that you're using a MessageBox with YesNo buttons?

If so, you need to capture the result of the MessageBox and check it against DialogResult.Yes as in:

C#

DialogResult result;
result = MessageBox.Show("Do you want to save this?","Save Inception",MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
  //insert into database