如何在我的DataGridView列中显示MM / dd / yyyy（没有时间）？ [英] How do I display MM/dd/yyyy (no time) in my DataGridView column?

问题描述

我需要我的DataGridView列日期格式的帮助。我想要的日期是MM / dd / yyyy。我不需要时间。

如何以编程方式完成？

我已经尝试过这个代码，但它不起作用code> gridView.Columns [1] .DefaultCellStyle.Format =MM / dd / yyyy;

`var connSettings = ConfigurationManager.ConnectionStrings [MyDB];
{
string CN = connSettings.ConnectionString;

  MySqlConnection conn = new MySqlConnection（CN）; 
 
 MySqlCommand cmd = new MySqlCommand（select id，entry_datetime，CONCAT（last_name，''，first_name，''，别名））成员的名称/代码按entry_datetime desc;，conn）; 
 
 MySqlDataAdapter data = new MySqlDataAdapter（cmd）; 
 conn.Open（）; 
 
 DataTable dt = new DataTable（）; 
 data.Fill（dt）; 
 gridView.DataSource = dt; 
 
 
} 
 
 
 gridView.Columns [0] .Width = 120; 
 gridView.Columns [0] .HeaderText =ID; 
 gridView.Columns [1] .Width = 120; 
 gridView.Columns [entry_datetime] DefaultCellStyle.Format =MM / dd / yyyy; 
 gridView.Columns [1] .HeaderText =收到日期; 
 gridView.Columns [2] .HeaderText =Name / Code;`
  

解决方案

例如

  gridView.DefaultCellStyle.Format = dd / MM / yyyy; 
  

尝试此

  gridView.Columns [3] .DefaultCellStyle.Format =dd / MM / yyyy; 
  

I need help on my DataGridView column date format. I want the date to be "MM/dd/yyyy". I dont need the time.

How can this be done programmatically?

i have tried this code but it doesn't work gridView.Columns[1].DefaultCellStyle.Format = "MM/dd/yyyy";

`var connSettings = ConfigurationManager.ConnectionStrings["MyDB"]; { string CN = connSettings.ConnectionString;

            MySqlConnection conn = new MySqlConnection(CN);

            MySqlCommand cmd = new MySqlCommand("select id, entry_datetime, CONCAT(last_name, ' ' ,first_name, ' ' ,alias) as Name/Code from members order by entry_datetime desc;", conn);

            MySqlDataAdapter data = new MySqlDataAdapter(cmd);
            conn.Open();

            DataTable dt = new DataTable();
            data.Fill(dt);
            gridView.DataSource = dt;


        }


        gridView.Columns[0].Width = 120;
        gridView.Columns[0].HeaderText = "ID";
        gridView.Columns[1].Width = 120;
        gridView.Columns["entry_datetime"].DefaultCellStyle.Format = "MM/dd/yyyy";
        gridView.Columns[1].HeaderText = "Date Received";
        gridView.Columns[2].HeaderText = "Name/Code";`

解决方案

for example.

  gridView.DefaultCellStyle.Format = "dd/MM/yyyy";

try this

  gridView.Columns[3].DefaultCellStyle.Format = "dd/MM/yyyy";

这篇关于如何在我的DataGridView列中显示MM / dd / yyyy（没有时间）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！