PetPamonha.DAOCliente.getListClientes C# (CSharp) Method

getListClientes() public method

public getListClientes ( ) : List
return List
        public List<Cliente> getListClientes(){
            MySqlDataReader leitor;
            List<Cliente> clientes=null;
            try
            {
                this.con.Open();
                clientes = new List<Cliente>();
                MySqlCommand cmd = con.CreateCommand();
                cmd.CommandText = "select * from cliente";
                leitor = cmd.ExecuteReader();

                while(leitor.Read()){
                    Cliente c = new Cliente();
                    c.IdCliente = (int)leitor["idCliente"];
                    c.Nome = (String)leitor["Nome"];
                    c.CPF = (String)leitor["CPF"];
                    c.Email = (String)leitor["Email"];
                    c.Telefone = (String)leitor["Telefone"];
                    clientes.Add(c);
                }
                leitor.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally
            {
                this.con.Close();
            }
            return clientes;
        }

Usage Example

 private void CadastroPet_Load(object sender, EventArgs e){
     DAOCliente c = new DAOCliente();
     
     this.cmbDono.DataSource = c.getListClientes();
     this.cmbDono.DisplayMember = "nomeCPF";
     this.cmbDono.ValueMember = "idCliente";
  }       
All Usage Examples Of PetPamonha.DAOCliente::getListClientes