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;
}
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"; }