display list of customers

Question

Hi,

i want to display list of customers in my database but an error has occured , please help me

error:

'ClientServiceLibrary.ClientTopNet' does not contain a definition for 'Add' and no extension method 'Add' accepting a first argument of type 'ClientServiceLibrary.ClientTopNet' could be found (are you missing a using directive or an assembly reference?)

and there is the code:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.ServiceModel;

using System.Data.SqlClient;

using System.Data.OleDb;

using System.Data;

namespace ClientServiceLibrary

{

    [ServiceBehavior(InstanceContextMode = InstanceContextMode.Single)]

    public class ClientTopNetService  :  IClientTopNetService

    {

        #region IClientTopNetService Membres

        public ClientTopNet ConsultationClient(int ID_CLIENT)

        {

            System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();

            conn.ConnectionString = @"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=topnet;Initial Catalog=TopnetBase;Data Source=SWEET-4B6F892B4\SQLEXPRESS";

            ClientTopNet oClients = new ClientTopNet();

            System.Data.OleDb.OleDbDataReader rs;

            System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand("select * from client  where ID_CLIENT='"+ID_CLIENT+"'", conn);

            rs = comm.ExecuteReader();

            while (rs.Read())

            {

                ClientTopNet oClient = new ClientTopNet(); 

                oClient.LOGIN_CREATION = rs["LOGIN_CREATION"].ToString();

                oClient.NOM = rs["NOM"].ToString();

                oClient.ADRESSE= rs["ADRESSE"].ToString();

                oClients.Add(oClient);

              

                return oClients;

            }

}