Bonjour a tous je rencontre un probleme avec mon projet Csharp, je ne sais pas comment m'y prendre pour importer mon sql de "CiviliteDB"  de ma classe "Civilite" dans mon listboxCivilite. Si vous avez des idées sur ce que je devrais mettre dans ma class Addclients.cs, je suis preneur !

Classe CiviliteDB : 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
using System.Threading.Tasks;

namespace Commande.DBLib
{
    public static class CiviliteDB
    {

        public static Civilite Find(int identifiantcivilite)
        {

            MySqlConnection connection = new MySqlConnection(DB.ConnectionString);

            MySqlCommand command = new MySqlCommand();
            command.Connection = connection;
            connection.Open();
            command.CommandText = @"
    SELECT  `civilite`.`Identifiant`
      , `civilite`.CiviliteCourte
          , `civilite`.CiviliteLongue
  FROM `civilite`
WHERE `civilite`.`Identifiant` = @identifiant
";
            command.Parameters.AddWithValue("@identifiant", identifiantcivilite);
            MySqlDataReader reader = command.ExecuteReader();
            Civilite c = null;
            while (reader.Read())
            {
                c = new Civilite();
                c.IdentifiantCivilite = reader.GetInt32("IdentifiantCivilite");
                c.CiviliteCourte = reader.GetString("CiviliteCourte");
                c.CiviliteLongue = reader.GetString("CiviliteLongue");
            }

            connection.Close();
            return c;
        }

        public static List<Civilite> All()
        {
            MySqlConnection connection = new MySqlConnection(DB.ConnectionString);

            MySqlCommand command = new MySqlCommand();
            command.Connection = connection;
            connection.Open();
            command.CommandText = @"
    SELECT  `civilite`.`Identifiant`
      , `civilite`.CiviliteCourte
          , `civilite`.CiviliteLongue
  FROM `civilite`
ORDER BY `Identifiant`
";

            MySqlDataReader reader = command.ExecuteReader();
            List<Civilite> civilites = new List<Civilite>();
            while (reader.Read())
            {
                Civilite c = new Civilite();
                c.IdentifiantCivilite = reader.GetInt32("Identifiant");
                c.CiviliteCourte = reader.GetString("CiviliteCourte");
                c.CiviliteLongue = reader.GetString("CiviliteLongue");

                civilites.Add(c);
            }

            connection.Close();
            return civilites;
        }




    }
}

Classe Civilite : 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Commande.DBLib
{
    public class Civilite
    {
        #region Fields
        private int _IdentifiantCivilite;
        private string _civilitecourte;
        private string _civilitelongue;






        #endregion

        #region Properties


        public int IdentifiantCivilite
        {
            get { return _IdentifiantCivilite; }
            set { _IdentifiantCivilite = value; }
        }



        public string CiviliteCourte
        {
            get { return _civilitecourte; }
            set { _civilitecourte = value; }
        }


        public string CiviliteLongue
        {
            get { return _civilitelongue; }
            set { _civilitelongue = value; }
        }





        #endregion


    }
}

Classe Formulaire  AddClients.cs

using Commande.DBLib;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Commande.Forms
{
    public partial class AddClients : Form
    {
        private List<Civilite> _Civilites;


        public AddClients()
        {

            InitializeComponent();
            Initialisation();

        }






        public void Initialisation()
        {
            _Civilites = CiviliteDB.All();



        }



    }
}