using MySql.Data.MySqlClient;
using System.Data;
namespace ConnexionMySql
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        MySqlConnection cn;
        bool Connecté =false;
        private void button1_Click(object sender, EventArgs e)
        {
            if (button1.Text == "Se connecter")
            {
                cn = new MySqlConnection("server=sql.freedb.tech;port=3306;database=freedb_Swyzyy;username=freedb_Swyzyy;pwd=*****;");
                try
                {
                    if (cn.State == ConnectionState.Closed) { cn.Open(); }
                    button1.Text = "Se déconnecter";
                    Connecté=true;
                }
                catch (Exception ex ) { MessageBox.Show(ex.Message); }
                }else
                {
                    cn.Close();
                    button1.Text = "Se connecter";
                    Connecté = false;
                }            
            }
        private void button2_Click(object sender, EventArgs e)
        {
            if(textBox1.Text == "")
            {
                MessageBox.Show("Entrez un nom");
            }else if(textBox2.Text == "")
            {
                MessageBox.Show("Entrez un age");
            }else
            {
                if (Connecté)
                {
                    MySqlCommand cmd = new MySqlCommand("INSERT INTO Utilisateurs(nom,age) VALUES(@nom,@age), cn");
                    cmd.Parameters.AddWithValue("@nom", textBox1.Text);
                    cmd.Parameters.AddWithValue("@age", textBox2.Text);
                    cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();
                    MessageBox.Show("Ajouté");
                }
                else
                {
                    MessageBox.Show("Vous n'etes pas connectés à la dbb");
                }
            } 
        }
    }
    }