//Declaration du reader SqlDataReader reader; //Declaration de la variable SqlConnection Connection = new SqlConnection("database=LENOMDETABASE;server=LESERVEURDELABASE;User ID=USERQUIALESDROITSSURLABASE;Password=MOTDEPASSEDUUSERQUIALESDROITSSURLABASE;"); //Variable contenant la requète string myInsertQuery = "Requete"; SqlCommand myCommand = new SqlCommand(myInsertQuery, Connection); //Connexion Connection.Open(); //Execution de la commande reader = myCommand.ExecuteReader(); //boucle qui parcourt les résultats while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { ValReturn.Add(reader.GetSqlValue(i).ToString().Trim()); } } //fermeture du reader reader.Close(); //fermeture de la connection Connection.Close();