{


            string newUserName = Convert.ToString(txtCreUse);
            string newPassword = Convert.ToString(txtCrePas);
            string newFirst = Convert.ToString(txtCreFir);
            string newLast = Convert.ToString(txtCreLas);

            int loyaltyPoints = 0;
            bool staffPassword = false;
            bool vatPassword = false;


            if (txtCreSta.Text == "staff1")
            {
                staffPassword = true;
            }
            else
            {

            }

            if (txtCreVAT.Text == "vat1")
            {
                vatPassword = true;
            }
            else
            {

            }

            customerTableTableAdapter1.Insert(txtCreFir.Text, txtCreLas.Text, txtCreUse.Text, loyaltyPoints, vatPassword, staffPassword, txtCrePas.Text);

            MessageBox.Show("You have succesfully created a user.");
            Variables.loggedIn = true;
            product frm = new product();
            frm.Show();


        }