{filelink=16149}

 using System;
 using System.Data.SqlClient;

namespace Base_de_données
{
    class ConnexionSQLExpress
    {
        static void Main(string[] args)
        {
            String chaineConnexion= @"server=(local)SQLEXPRESS;database=MesExemples.com;Integrated Security=SSPI";

            String requete = "select * from Clients";

            SqlConnection conexion = new SqlConnection(sConn);
            conexion.Open();

            SqlCommand oCmd = new SqlCommand(requete, conexion);
            SqlDataReader SQLReader = oCmd.ExecuteReader();

            int idxID = SQLReader.GetOrdinal("id");
            int idxSociété = SQLReader.GetOrdinal("Société");
            int idxAdresse = SQLReader.GetOrdinal("Adresse");

            while (SQLReader.Read())
            {
                Console.WriteLine("{0} {1} {2}",
                  SQLReader.GetValue(idxID),
                  SQLReader.GetValue(idxSociété),
                  SQLReader.GetValue(idxAdresse));
            }
        }
    }

}