How to list Mysql results in the listview

Question

Structure of the Code

In this function below I try to grab the contents of the Mysql database and passing to a List<BDependente> lDep on the line where this facade.listDependente(bDep);

Official Method

        lvDependente.Columns.Add("Nome", 150, HorizontalAlignment.Left);
        lvDependente.Columns.Add("Parentesco", 70, HorizontalAlignment.Left);
        lvDependente.Columns.Add("Nascimento", 130, HorizontalAlignment.Left);

        lDep = facade.listDependente(bDep);            
        foreach (BDependente bDepe in lDep) {
            string[] row = {bDepe.Nome, bDepe.Grau_parentesco, bDepe.Data_nascimento };
            lvDependente.Items.Add(row);
        }
        lvDependente.View = View.Details;

The result of this is that only the last bank record comes out.

Answer 1

To popular a listview use this way:

    foreach (BDependente bDepe in lDep)
    {
        ListViewItem lvItem = new ListViewItem(bDepe.Nome);
        lvItem.SubItems.Add(bDepe.Grau_parentesco);
        lvItem.SubItems.Add(bDepe.Data_nascimento);
        lvDependente.Items.Add(lvItem);
    }