private void populate_combobox(string selectQuery, ComboBox comboBoxName, string column_name, string id) { //comboBoxName.Items.Clear(); // Clear combobox MyData myAdapter = new MyData(); MySqlDataReader reader = myAdapter.MySqlDataReader(selectQuery); while (reader.Read()) { comboBoxName.Items.Add(new { ColumnName = reader[column_name].ToString(), ColumnId = reader[id].ToString() }); } myAdapter.connectionClose(); }
private void populate_ComboBox(string comboboxName, string selectQuery) { MySqlDataReader reader; //string selectQuery = "SELECT * FROM `tb_stage` ORDER BY stages_type"; MyData myAdapter = new MyData(); //MessageBox.Show(MyData.conn.State.ToString()); reader = myAdapter.MySqlDataReader(selectQuery); while (reader.Read()) { if (comboboxName == "cmbox_Stage") { //cmbox_Stages.Items.Clear(); // Clear combobox cmbox_Stage.Items.Add(reader.GetString("stage_type")); } else { //cmbox_FailureCode.Items.Clear(); cmbox_FailureCode.Items.Add(reader.GetString("failure_code_type")); } //cmbox_Stages.Items.Items.Add(reader.GetString("Users")); } reader.Close(); /* * * selectQuery = "SELECT * FROM `tb_failure_code` ORDER BY failure_code_type"; * cmbox_FailureCode.Items.Clear(); * reader = myAdapter.MySqlDataReader(selectQuery); * while (reader.Read()) * { * cmbox_FailureCode.Items.Add(reader.GetString("failure_code_type")); * //cmbox_Stages.Items.Items.Add(reader.GetString("Users")); * } */ }