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