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"));
* }
*/
}
