Display date formatted in datagridview

Question

In the datagridview has a date field in the format yyyyMMdd and need to display formatted in the correct form.

tried this:

dgvRequisicao.Columns["data"].DefaultCellStyle.Format = "dd/MM/yyyy";

But instead of showing me the formatted date shows me dd/MM/yyyy

Edit:

I populate the grid like this:

 BindingSource sbind = new BindingSource();
                sbind.DataSource = dt;
                dgv.DataSource = sbind;

Edit:

Here I charge datatable bank

  for (int i = 0; i < parametros.Length; i += 2)
                cmd.Parameters.AddWithValue(parametros[i].ToString(), parametros[i + 1]);
            OracleDataAdapter da = new OracleDataAdapter(cmd);
            da.Fill(dt);

Thank you

Answer 1

As I observed you’re using the BindingSource, so I changed the example to use the BindingSource, being as follows

private void PessoaBindingSourceForm_Load(object sender, EventArgs e)
        {
            PessoaList list = new PessoaList();

            list.Add(new Pessoa() { Id = 1, DataHora = DateTime.Now.AddDays(1), Nome = "Pablo" });
            list.Add(new Pessoa() { Id = 2, DataHora = DateTime.Now.AddDays(2), Nome = "Pablo" });
            list.Add(new Pessoa() { Id = 3, DataHora = DateTime.Now.AddDays(3), Nome = "Pablo" });
            list.Add(new Pessoa() { Id = 4, DataHora = DateTime.Now.AddDays(4), Nome = "Pablo" });

            BindingSource sbind = new BindingSource();
            sbind.DataSource = list;
            dataGridView1.DataSource = sbind;
            dataGridView1.Refresh();
        }

public class PessoaList : BindingList<Pessoa>
    {


    }

An alternative I’ve used a lot is to add to your DataGridView one DefaultCellStyle, where in this configuration you can configure the Format.

I add some prints to make it easy

I also added to git the example

Answer 2

do not do this kind of manipulation by datagridview, bring the formatted date straight from the database,

SELECT DATE_FORMAT(seuCampoDatanaTabela,'%d/%m/%Y') AS AliasSeQuiserUsar FROM suaTabela