private void Search_Member(object sender, EventArgs e) { try { string selectedtype = usn_type.SelectedItem.ToString(); if (selectedtype != "Agent") { usn_select.Items.Clear(); connection.Open(); string query = "select user_ID,user_fname,user_lname from users where user_Type ='" + selectedtype + "'"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataAdapter mcmd = new MySqlDataAdapter(); MySqlDataReader reader; mcmd.SelectCommand = cmd; //DataSet ds = new DataSet(); //mcmd.Fill(ds); reader = cmd.ExecuteReader(); string[] data = new string[3]; while (reader.Read()) { data[0] = reader.GetString(0); data[1] = reader.GetString(1); data[2] = reader.GetString(2); usn_select.Items.Add(data[1] + " " + data[2]); } } else { usn_select.Items.Clear(); connection.Open(); string query = "select Agent_ID,Agent_fname,Agent_lname from Agent where Employed =\"Y\""; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataAdapter mcmd = new MySqlDataAdapter(); MySqlDataReader reader; mcmd.SelectCommand = cmd; //DataSet ds = new DataSet(); //mcmd.Fill(ds); reader = cmd.ExecuteReader(); string[] data = new string[3]; while (reader.Read()) { data[0] = reader.GetString(0); data[1] = reader.GetString(1); data[2] = reader.GetString(2); usn_select.Items.Add(data[1] + " " + data[2]); } } /* * DataSet orig = new DataSet(); * DataSet made = new DataSet(); * * made.Tables.Add("Userid"); * made.Tables.Add("Name"); * * //var dict = new Dictionary<Guid, string>(); * mcmd.Fill(orig, "user_ID"); * * * usn_select.DataSource = orig.Tables["user_ID"]; * usn_select.DisplayMember = "user_fname"; * usn_select.ValueMember = "user_ID"; */ connection.Close(); } catch (Exception ex) { MessageBox.Show("Error occured!"); } }