private void btnSignUp_Click(object sender, EventArgs e)
        {
            string errorString = "";
            bool   showMessage = false;

            isFilled = new bool[7];
            if (txtRptPassword.Text != typedPassword)
            {
                errorString += "The given password doesn't match with the previous one.\n";
                isFilled[0]  = false;
                showMessage  = true;
            }
            if (txtCity.Text == "" || txtCountry.Text == "" || txtEmail.Text == "" || txtPhoneNumber.Text == "" || txtState.Text == "" || txtZipCode.Text == "")
            {
                errorString += "All fields must be filled in order to create an account!";
                showMessage  = true;
            }
            if (showMessage)
            {
                MessageBox.Show(errorString);
            }
            else
            {
                DBSteamDataSet db = new DBSteamDataSet();
                DBSteamDataSetTableAdapters.UserTableAdapter userTableAdapter =
                    new DBSteamDataSetTableAdapters.UserTableAdapter();

                DBSteamDataSetTableAdapters.AddressTableAdapter addressTableAdapter =
                    new DBSteamDataSetTableAdapters.AddressTableAdapter();

                DBSteamDataSet.UserRow newUserRow = db.User.NewUserRow();
                userTableAdapter.Insert(txtEmail.Text, 0, typedPassword, txtPhoneNumber.Text, 0, typedUsername);

                SqlDataReader MineReader = DatabaseAccess.getDataFromDB("SELECT ID FROM [User] WHERE userName LIKE '" + typedUsername + "'");
                int           id         = 0;
                if (MineReader.Read())
                {
                    id = Convert.ToInt32(MineReader["ID"].ToString());
                    DBSteamDataSet.AddressRow newAddressRow = db.Address.NewAddressRow();
                    addressTableAdapter.Insert(id, txtCity.Text, txtCountry.Text, txtState.Text, txtZipCode.Text, "default");
                }
                MessageBox.Show("Account successfully created!");
                this.Close();
            }
        }
        private void btnSignUp_Click(object sender, EventArgs e)
        {
            string errorString = "";
            bool showMessage = false;
            isFilled = new bool[7];
            if (txtRptPassword.Text != typedPassword)
            {
                errorString += "The given password doesn't match with the previous one.\n";
                isFilled[0] = false;
                showMessage = true;
            }
            if (txtCity.Text == "" || txtCountry.Text == "" || txtEmail.Text == "" || txtPhoneNumber.Text == "" || txtState.Text == "" || txtZipCode.Text == "")
            {
                errorString += "All fields must be filled in order to create an account!";
                showMessage = true;
            }
            if (showMessage)
                MessageBox.Show(errorString);
            else
            {
                DBSteamDataSet db = new DBSteamDataSet();
                DBSteamDataSetTableAdapters.UserTableAdapter userTableAdapter =
                            new DBSteamDataSetTableAdapters.UserTableAdapter();

                DBSteamDataSetTableAdapters.AddressTableAdapter addressTableAdapter =
                            new DBSteamDataSetTableAdapters.AddressTableAdapter();

                DBSteamDataSet.UserRow newUserRow = db.User.NewUserRow();
                userTableAdapter.Insert(txtEmail.Text, 0, typedPassword, txtPhoneNumber.Text, 0, typedUsername);

                 SqlDataReader MineReader = DatabaseAccess.getDataFromDB("SELECT ID FROM [User] WHERE userName LIKE '" + typedUsername + "'");
                 int id = 0;
                 if (MineReader.Read())
                 {
                     id = Convert.ToInt32(MineReader["ID"].ToString());
                     DBSteamDataSet.AddressRow newAddressRow = db.Address.NewAddressRow();
                     addressTableAdapter.Insert(id,txtCity.Text,txtCountry.Text,txtState.Text,txtZipCode.Text,"default");
                 }
                 MessageBox.Show("Account successfully created!");
                this.Close();
            }
        }