6
votes

I have a DateTime column in my winForms DataGridView; currently the field can only be edited by typing the date in manually "2010/09/02", what would be needed to have a DateTimePicker (or equivalent) used as the editor instead?

1
You may find this helpful… How to: Host Controls in Windows Forms DataGridView Cells … this is an example of a DateTimePicker column.JohnG

1 Answers

1
votes

DataGridViewDateTimePickerColumn doesn't exist so you have to add control manually as below.

    DateTimePicker dtp = new DateTimePicker();
    Rectangle rectangle;

    public Form1()
    {
        InitializeComponent();

        dgv.Controls.Add(dtp);
        dtp.Visible = false;
        dtp.Format = DateTimePickerFormat.Custom;
        dtp.TextChanged += new EventHandler(dtp_TextChange);
    }

    private void dgv_CellClick(object sender, DataGridViewCellEventArgs e)
    {
        switch (e.ColumnIndex)
        {
            case 5: // Column index of needed dateTimePicker cell

                rectangle = dgv.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true); //  
                dtp.Size = new Size(rectangle.Width, rectangle.Height); //  
                dtp.Location = new Point(rectangle.X, rectangle.Y); //  
                dtp.Visible = true;

                break;
        }
    }

    private void dtp_TextChange(object sender, EventArgs e)
    {
        dgv.CurrentCell.Value = dtp.Text.ToString();
    }

    private void dgv_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
    {
        dtp.Visible = false;

    }

    private void dgv_Scroll(object sender, ScrollEventArgs e)
    {
        dtp.Visible = false;
    }

If you need a default date, you can handle it through the RowsAdded event.

    private void dgv_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
    {
        dgv.Rows[e.RowIndex].Cells[5].Value = DateTime.Now.ToShortDateString();
    }