Save values from Combobox c#

Question

Hello

I’m a beginner in C# and have a combobox receiving data from mysql:

        mConn.Open();

        MySqlCommand command = new MySqlCommand("select modelonome from modelo", mConn);
        MySqlDataAdapter da = new MySqlDataAdapter(command);

        DataTable dtModelos = new DataTable();
        da.Fill(dtModelos);

        cbModelo.DisplayMember = "modelonome";
        cbModelo.ValueMember = "modelocod";
        cbModelo.DataSource = dtModelos;

I created a method to save in the database:

 public void salvar(Config config)
    {
        mConn = new MySqlConnection("Persist Security Info=False; server=localhost;database=****;uid=****;password=*****");


        string comandosql = "INSERT INTO SETUP(setcanal,setporta,setlinha,setposto,setmodelo)" +
            "VALUES(@setcanal,@setporta,@setlinha,@setposto,@setmodelo)";

        MySqlCommand command1 = new MySqlCommand(comandosql, mConn);
        command1.Parameters.AddWithValue("@setcanal",config.Setcanal);
        command1.Parameters.AddWithValue("@setporta", config.Setporta);
        command1.Parameters.AddWithValue("@setlinha", config.Setlinha);
        command1.Parameters.AddWithValue("@setposto", config.Setposto);
        command1.Parameters.AddWithValue("@setmodelo", config.Setmodelo);


        try
        {
            mConn.Open();
            int regitrosAfetados = command1.ExecuteNonQuery();
        }
        catch (MySqlException ex)
        {
            throw new ApplicationException(ex.ToString());
        }
        finally
        {
            mConn.Close();
        }
    }
}

And I’m calling him on my canvas in the boot:

ConfigDB configDB = new ConfigDB();
            Config config = new Config(int.Parse(tbCanal.Text), int.Parse(tbPorta.Text), Convert.ToInt32(cbLinha.SelectedValue), Convert.ToInt32(cbPosto.SelectedValue), Convert.ToInt32(cbModelo.SelectedValue)); 
            configDB.salvar(config);
            MessageBox.Show("Registro salvo com sucesso!");

But it always gives the error: "Unable to cast Object of type" and not saved Does anyone know what it might be? What would be the right way to save? Or at least how to get the name that is displayed? I’ve tried using Selecteditem.toString(); but it returns the name Datarowview something like this.

Answer 1

Or this combobox cbLinha or this one cbPosto doesn’t have the property ValueMember defined.

Thus its SelectedValue becomes a System.Data.DataRowView and therefore error in its conversion from value to integer.

The solution is to define the property ValueMember correctly for one of these two Combobox.