Difficulty to popular the Gridview

Question

I have a screen that I consult clients and fill a grid with the information coming from the bank, my project is separated by layers until where I am works, but I can not fill the grid with some information, I have the following situation within the for each:

 Cliente cliente = new Cliente();

 cliente.Pessoa = new Pessoa();
 cliente.Pessoa.IdPessoa = Convert.ToInt32(linha["IdPessoaCliente"]);
 cliente.Pessoa.Nome = Convert.ToString(linha["Nome"]);
 cliente.DataCadastro = Convert.ToDateTime(linha["DataCadastro"]); 
 cliente.DataAlteracao = Convert.ToDateTime(linha["DataAlteracao"]);
 cliente.LimiteCompra = Convert.ToDecimal(linha["LimiteCompra"]);
 cliente.Ativo = Convert.ToBoolean(linha["Ativo"]);

 cliente.Pessoa.PessoaTipo = new PessoaTipo();
 cliente.Pessoa.PessoaTipo.IdPessoaTipo = Convert.ToInt32(linha["IdPessoaTipo"]);
 cliente.Pessoa.PessoaTipo.Descricao = Convert.ToString(linha["Descricao"]);

 clienteColecao.Add(cliente);

The fields of grid that comes directly from client as for example cliente.DataCadastro carries normal, but what is cliente.Pessoa.IdPessoa in the grid appears written "transfer object", or if I customize the grid nothing comes and when threshing I see that cliente.Pessoa.IdPessoa the IdPessoa has the correct value but Pessoa is written Objeto transfer exactly what goes to the grid.

Answer 1

See if the example below helps in anything:

public void MostrarClientes()
{
        string StrCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Desktop\\Oi\\Testando.accdb";
        string sql = "SELECT * FROM Cliente";

        OleDbConnection Con = new OleDbConnection(StrCon);
        OleDbDataAdapter da = new OleDbDataAdapter(sql, Con);
        DataTable dt = new DataTable();
        da.Fill(dt);
        dataGridView1.DataSource = dt;
}

Another example:

protected void CarregarDataGridView(String parametro)
{
  MySqlConnection conn = new MySqlConnection("Server=NomeServidor;Database=Teste;Uid=root;Pwd=sua_senha;");
  conn.Open();

  try
  {
    MySqlCommand cmd = new MySqlCommand("SELECT * FROM TABELA WHERE CAMPO=@CAMPO", conn);
    cmd.Parameters.Add(new MySqlParameter("@CAMPO", parametro));

    MySqlDataReader reader = cmd.ExecuteReader();
    DataTable table = new DataTable();

    table.Load(reader);

    this.dataGridView1.DataSource = table;

    table.Dispose();
    reader.Close();
    reader.Dispose();

  }
  catch (Exception ex)
  {
    MessageBox.Show(ex.Message);
  }
  finally
  {
    conn.Close();
    conn.Dispose();
  }
}

Answer 2

You are populating your Datagridview ?

Datagridview has a property called Datasource. Here you get the source of your dice.

It would be something like:

dgvClientes.DataSource = cliente.Listagem();

Check:

Datagridview - MSDN

Answer 3

The Client.Person will not appear because there is no representation of the class objects. In simplistic terms the objects in the cells show the result of Tostring().

The question you can ask is what did you expect the Person class to show in the cell?