I have bind the combo box with the following code:
private void getCompanydata() { MySqlConnection con = new MySqlConnection(ConfigurationManager.AppSettings["RL_InventoryConnection"]); if (con.State == ConnectionState.Closed) con.Open(); MySqlCommand cmd = new MySqlCommand("select comp_id, concat(comp_name,'-', comp_add) as company from companymaster;", con); MySqlDataAdapter sda = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); DataRow dr; dr = dt.NewRow(); dr.ItemArray = new object[] {0, "--Select Delivery Location--" }; dt.Rows.InsertAt(dr, 0); comboBox1.DisplayMember = "company"; comboBox1.ValueMember = "comp_id"; comboBox1.DataSource = dt; }
in another method, i want to access comp_id which is bind with valueMember. I am trying with following code but its not working.
private void SaveData() { string company = comboBox1.Text.ToString(); int companyid = Convert.ToInt32(comboBox1.SelectedValue); }