private void btnLogin_Click(object sender, RoutedEventArgs e)
        {
            MySqlConnectionStringBuilder connectionStr = new MySqlConnectionStringBuilder
            {
                Server = "localhost",
                Database = "login",
                UserID = "root",
                Password = "usbw",
                ConnectionTimeout = 60,
                Port = 3307,
                AllowZeroDateTime = true
            };
            MySqlConnection MySqlCon = new MySqlConnection(connectionStr.ConnectionString);

            try
            {
                if (MySqlCon.State == System.Data.ConnectionState.Closed) MySqlCon.Open();
                String query1 = "SELECT COUNT(1) FROM login.login WHERE Username=@Username AND Password=@Password";
                MySqlCommand sqlCmd = new MySqlCommand(query1, MySqlCon);
                sqlCmd.CommandType = CommandType.Text;
                sqlCmd.Parameters.AddWithValue("@Username", txtUsername.Text);
                sqlCmd.Parameters.AddWithValue("@Password", txtPassword.Text);
                int count = Convert.ToInt32(sqlCmd.ExecuteScalar());
                if (count == 1)
                {
                    MainWindow MainWindow = new MainWindow();
                    MainWindow.Show();
                    this.Close();
                }
                else
                {
                    MessageBox.Show("Username of password is foutief, probeer opnieuw.");
                }


            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                MySqlCon.Close();
            }
        }