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