private void submitUpdateOwner_btn_Click(object sender, EventArgs e)
{
ownerResultBindingSource.Position = 0;
OwnerResult OwnerToUpdate = (OwnerResult)ownerResultBindingSource.Current;
OwnerToUpdate.Update(Form1.MasterConnection);
updateSuccess_label.Text = "Owner Updated Successfully!";
updateSuccess_label.Show();
}
private void ownerSelection_box_SelectedIndexChanged(object sender, EventArgs e)
{
ownerResultBindingSource.Clear();
OwnerResult SelectedOwner = new OwnerResult();
SelectedOwner.IDName = ownerSelection_box.SelectedItem.ToString();
MySqlCommand QueryOwner = new MySqlCommand("select * from `gaminginv`.`owner` where `Name` = @NameParam" + ';', Form1.MasterConnection);
QueryOwner.Parameters.AddWithValue("@NameParam", SelectedOwner.IDName);
MySqlDataReader OwnerReader = QueryOwner.ExecuteReader();
if (OwnerReader.Read())
{
SelectedOwner.BadgeName = OwnerReader.GetString("BadgeName");
SelectedOwner.EmailAddress = OwnerReader.GetString("Email");
SelectedOwner.ItemQty = OwnerReader.GetInt32("ItemCount");
SelectedOwner.OwnerID = OwnerReader.GetInt32("ID");
SelectedOwner.PhoneNumber = OwnerReader.GetString("Phone");
ownerResultBindingSource.Add(SelectedOwner);
}
OwnerReader.Close();
}