How to save bind a list of selecteditem in combobox to a database?

Question

1.00/5 (1 vote)

See more:

, +

Can somebody help me please?

Binding a list into a ComboBox from a Database table with game names. When the user selected one of the list in the ComboBox then save after not storing only this data. Still empty this selected item.

The following link then the second Solution was helped me and followed how to bind list to ComboBox.

Fill ComboBox From Sql Server On C#[^]

What I have tried:

Bind a list to ComboBox from Database table:

C#

public static void BindComboBox(ComboBox comboBox_CauseOfGame)
...
comboBox_CauseOfGame.Items.Add(reader["Name"].ToString());
...

ComboBox click action:

C#

private void comboBox_CauseOfGame_Click(object sender, EventArgs e)
BindComboBox(comboBox_CauseOfGame);

int selectedIndex = comboBox_CauseOfGame.SelectedIndex;
Object selectedItem = comboBox_CauseOfGame.SelectedItem;

The User selected an item from the list then want to save to Database into another table:

C#

funGames = new funGames(..., (int)comboBox_CauseOfGame.SelectedIndex, ..., ...,

Posted 20-Nov-22 0:42am

ernteSKY

Updated 20-Nov-22 2:20am

v8

Add a Solution

Comments

Graeme_Grant 20-Nov-22 6:44am

What database? What have you tried? What error are you seeing? What are you trying to store? Remember, we can't see your code or your screen. Please update your question with more information.

When working with data, data is the key. The UI is just another method of accessing the data, just like reading and writing to a file or a database.

ernteSKY 20-Nov-22 6:47am

What you mean what database? Database where store data and so on. I'm not well understand your question. Also you can see what I am tried at the bottom of the question. The error message you can read also at the top of my question.

Graeme_Grant 20-Nov-22 6:56am

MS Sql, MySql, Maria DB, Access DB, SQLite, etc... every DB is slightly different. As for the error " Specified cast is not valid" where is this happening, and what line? The error is saying you are trying to use one variable type as another without casting.

ernteSKY 20-Nov-22 7:06am

You right and now is clear! This one using the MS Sql and the error message come up at line of "(int)comboBox_CauseOfGame.SelectedItem". This one of the line collecting the data then send to the database manager for store into the database.

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)

Graeme_Grant · Accepted Answer · 2022-11-20T01:15:00

C#

(int)comboBox_CauseOfGame.SelectedItem

This throws the error "Specified type conversion is invalid what is mean the Specified cast is not valid." because the value is converted to an integer is not of that type, is a string display name from:

C#

comboBox_CauseOfGame.Items.Add(reader["Name"].ToString());

You want the SelectedIndex which is an integer index of the SelectedItem. Read more here: ComboBox.SelectedItem Property (System.Windows.Forms) | Microsoft Learn[^]

UPDATED

This is fundamentals of a ComboBox, but I will make an example for you:
1. Create a new project
2. Add the following 4 controls:

C#

private ComboBox comboBox1;
private TextBox txtSelectedItem;
private TextBox txtSelectedIndex;
private TextBox txtCollectionIndexOf;

3. Add the following to the code-behind:

C#

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
        GenerateNames();
        comboBox1.DataSource = Names;
    }

    public List<string> Names { get; set; } = new();

    private void GenerateNames()
    {
        for (int i = 0; i < 100; i++)
        {
            Names.Add($"Name {i}");
        }
    }

    private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
        txtSelectedIndex.Text = comboBox1.SelectedIndex.ToString();
            
        txtSelectedItem.Text = comboBox1.SelectedItem.ToString();

        txtCollectionIndexOf.Text = Names
            .IndexOf(comboBox1.SelectedItem.ToString() 
                     ?? "no item selected")
            .ToString();
    }
}

When you select items in the ComboBox, you will see the results in the TextBoxes. This is exactly what has been discussed.