How to invert grid data

Question

I have a database with some tables to control software sales, and among these tables, I have software that contains the fields, beginning of the contract and end of the contract. Only when I select to appear like this ''21/12/2016', they appear like this in the grid ''12/21/2016' ?

private void MontarLista()
    {

        conexao.ConnectionString = strconexao;
        cmd.CommandText = "SELECT * FROM SOFTWARES";
        cmd.Connection = conexao;

        conexao.Open();
        cmd.CommandType = CommandType.Text;
        Dr = cmd.ExecuteReader();
        DtSoftwares.Clear();
        DtSoftwares.Load(Dr);
        dataGridView1.DataSource = DtSoftwares;
        conexao.Close();
        decimal soma = 0;


        foreach (DataGridViewRow dr in dataGridView1.Rows)
        {

Answer 1

You can do

string.Format("{0:dd/MM/yyyy}", DateTime.ParseExact("12/21/2016", "MM/dd/yyyy"));

You replace "12/21/2016" with your string that is the date, or if you already have the Datetime object, just put it instead of the DateTime.ParseExact.

Answer 2

In the current way, I only see a simple way to resolve it. Format the date directly in select

cmd.CommandText = "SELECT FORMAT(INICIO, 'dd/MM/yyyy') AS INICIO, " + 
                        " OUTROS_CAMPOS FROM SOFTWARES";

This will make the column INICIO is formatted with the Brazilian standard.