using Devart.Data.MySql;

​

namespace MySqlConnectionMauiApp;

​

public partial class MainPage : ContentPage

{

    public MainPage()

    {

        InitializeComponent();

    }

​

    private async void OnCheckConnectionClicked(object sender, EventArgs e)

    {

        ConnectionStatusLabel.Text = "Checking connection...";

        ConnectionStatusLabel.TextColor = Colors.Gray;

​

        var result = await Task.Run(() => CheckMySqlConnection());

​

        if (result.isConnected)

        {

            ConnectionStatusLabel.Text = "Connection successful!";

            ConnectionStatusLabel.TextColor = Colors.Green;

        }

        else

        {

            ConnectionStatusLabel.Text = $"Connection failed: {result.message}";

            ConnectionStatusLabel.TextColor = Colors.Red;

        }

    }

​

    private (bool isConnected, string message) CheckMySqlConnection()

    {

        // Replace with your actual connection string

        string connectionString = "" +

                "Server=;" +

                "Port=;" +

                "UserId=;" +

                "Password=;" +

                "Database=;" +

                "LicenseKey=**********";

​

        try

        {

            using (var connection = new MySqlConnection(connectionString))

            {

                connection.Open();

                if (connection.State == System.Data.ConnectionState.Open)

                {

                    return (true, "Connection successful!");

                }

                else

                {

                    return (false, "Connection failed!");

                }

            }

        }

        catch (Exception ex)

        {

            return (false, ex.Message);

        }

    }

}

​