private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
 {
     txtFirstName.Text = customer.FirstName;
     txtLastName.Text  = customer.LastName;
     txtEmail.Text     = customer.Email;
     txtState.Text     = customer.State;
     txtCity.Text      = customer.City;
     txtUserName.Text  = customer.UserName;
     txtZip.Text       = customer.Zip;
     txtAddress.Text   = customer.Address;
     txtOrderQty.Text  = DBConnection.orderQty(customer.CustomerID).ToString();
 }