How can I create a Datagridview with Mongodb?

Question

I want to present the BD data in a table, but so far I could only do it using a ListView. How can I do it but using one DataGridView?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MongoDB.Bson;
using MongoDB.Driver;
using MongoDB.Driver.Builders;
using MongoDB.Driver.Linq;

namespace WFRecibos
{
    public partial class frmListaClientes : Form
    {
        public frmListaClientes()
        {
            InitializeComponent();
        }


            public IEnumerable<Cliente> getTodosClientes()
            {

                var colClientes = DbHelper.getCollection("Cliente");

                var clienteLista = from e in colClientes.AsQueryable<Cliente>() select e;

                return clienteLista;
            }

        private void frmListaCli_Load(object sender, EventArgs e)
        {
            var consulta = this.getTodosClientes();
            listView1.Items.Clear();
                foreach (var cli in consulta)
                {
                    listView1.Items.Add(cli.Nome);
                    listView1.Items.Add(cli.Municipio);
                    listView1.Items.Add(cli.Corrego);
                }
        }

        private void gdvClientes_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }


    }
}

Answer 1

Supposing the name of DataGridView be it grdDados, you can do the following:

private void frmListaCli_Load(object sender, EventArgs e)
{
    var consulta = this.getTodosClientes();
    grdDados.DataSource = consulta;

    grdDados.Columns["Municipio"].HeaderText = "Município"; // altera cabeçalho da coluna
    grdDados.Columns["Corrego"].HeaderText = "Córrego"; // altera cabeçalho da coluna
}

Observing: I also put in the code an option to change the column header, you can use if you think necessary.

If you wanted more information about the property DataSource, you can take a look at that link.

Answer 2

My problem can be solved in two ways. Follow the code of two dataGridView each presenting a solution:

private BindingSource bindingSource1 = new BindingSource();

        private void frmListaCli_Load(object sender, EventArgs e)
        {
            //-------> gdvClientes   -----------------------------------
            try
            {
                gdvClientes.AutoGenerateColumns = true;

                bindingSource1.DataSource = getTodosClientes();
                gdvClientes.DataSource = bindingSource1;
                gdvClientes.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders;
                gdvClientes.BorderStyle = BorderStyle.Fixed3D;
                gdvClientes.EditMode = DataGridViewEditMode.EditOnEnter;
            }
            catch (Exception)
            {
                MessageBox.Show("To run this sample replace connection.ConnectionString" +
                    " with a valid connection string to a Northwind" +
                    " database accessible to your system.", "ERROR",
                    MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                System.Threading.Thread.CurrentThread.Abort();

            }



            //-------> dataGridView1   -----------------------------------

            DataTable dt = new DataTable();

            dt.Columns.Add("Nome");
            dt.Columns.Add("Corrego");
            dt.Columns.Add("Municipio");
            dt.Columns.Add("Ações");

            var consulta = this.getTodosClientes();
            foreach (var cli in consulta)
            {

                dt.Rows.Add(

                             cli.Nome,

                             cli.Corrego,

                             cli.Municipio,
                             "Editar - Excluir"

                             );




            } dataGridView1.DataSource = dt;

        }

Valew @Mateus Alexandre for helping me...