如何在 DataGridView 中显示 DateTimePicker？

Question

有什么方法可以将 DateTimePicker 控件放入 DataGridView 中吗？

我检查了所有可能的属性，但它提供了复选框、组合框等选项，但没有提供 DateTimePicker。

Answer 1

您没有错过任何内置选项，但可以对 DataGridViewColumn 和 DataGridViewCell 类进行子类化以托管您选择的任何控件。

MSDN 上的这篇文章更详细地解释了该过程，甚至包括一些示例代码：
如何：在 Windows 窗体 DataGridView 单元格中托管控件

您还可以在代码项目上找到完整的示例： 通用 DataGridView V2.0

Answer 2

一种策略是：

1. 当选定的单元格接收焦点时，在其顶部绘制一个 DateTimePicker
2. 当 dtp 的值发生变化时，将 dtp 与单元格的值进行水合
3. ，将其镜像回单元格的值
4. 并隐藏 dtp当单元格失去焦点时

这是一种使用布局策略处理网格事件的方法：

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
    // determine if click was on our date column
    if (dataGridView1.Columns[e.ColumnIndex].DataPropertyName == nameof(User.BirthDate))
    {
        // initialize DateTimePicker
        DateTimePicker dtp = new DateTimePicker();
        dtp.Format = DateTimePickerFormat.Short;
        dtp.Visible = true;
        dtp.Value = DateTime.Parse(dataGridView1.CurrentCell.Value.ToString());

        // set size and location
        var rect = dataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true);
        dtp.Size = new Size(rect.Width, rect.Height);
        dtp.Location = new Point(rect.X, rect.Y);

        // attach events
        dtp.CloseUp += new EventHandler(dtp_CloseUp);
        dtp.TextChanged += new EventHandler(dtp_OnTextChange);

        dataGridView1.Controls.Add(dtp);
    }
}

// on text change of dtp, assign back to cell
private void dtp_OnTextChange(object sender, EventArgs e)
{
    dataGridView1.CurrentCell.Value = dtp.Text.ToString();
}

// on close of cell, hide dtp
void dtp_CloseUp(object sender, EventArgs e)
{
    dtp.Visible = false;
}

---

这是添加了 DataGridView 的表单的基本设置

private void Form1_Load(object sender, EventArgs e)
{
    // add columns
    var nameCol = new DataGridViewTextBoxColumn(){DataPropertyName = nameof(User.Name),HeaderText = "Name"};
    var dateCol = new DataGridViewTextBoxColumn(){DataPropertyName = nameof(User.BirthDate),HeaderText = "Birthday"};
    dataGridView1.Columns.AddRange(nameCol, dateCol);

    // add data source
    var users = new List<User>()
    {
        new User() {Name = "Briana", BirthDate = new DateTime(2019,10,10)},
        new User() {Name = "Grace", BirthDate = new DateTime(2018,1,18)}
    };
    dataGridView1.DataSource = users;
}

private  DateTimePicker dtp { get; set; }

private class User
{
    public string Name { get; set; }
    public DateTime BirthDate { get; set; }
}

注意：当 dtp 具有焦点时，此方法当前不处理键盘事件，并且在表单移动时也不处理调整大小或重新绘制

Answer 3

也许这不合适，但简单的技巧和相同的结果......更少的代码......我只是在玩，虽然在盒子外面，只需设置

我隐藏我的直到他们单击单元格，或者你可以显示
首先我声明：

DateTimePicker1.Visible = False

当您单击单元格时，运行此代码...

    DateTimePicker1.Visible = True
    ActiveControl = DateTimePicker1

然后在

 Public Sub DateTimePicker1_ValueChanged(sender As System.Object, e As System.EventArgs) Handles DateTimePicker1.ValueChanged



    requestDGV.Rows(0).Cells("requestTimeOff").Value = (DateTimePicker1.Value)
    DateTimePicker1.Visible = False
    DateTimePicker1.Enabled = False

End Sub

Super Basic 下方，我将它直接放在框中，看起来不合适

或超级简单模式......我就像隐藏我的直到列单击

Public Sub DateTimePicker1_ValueChanged(sender As System.Object, e As System.EventArgs) Handles DateTimePicker1.ValueChanged


    requestDGV.Rows(0).Cells("requestTimeOff").Value = (DateTimePicker1.Value)

End Sub

你真的只需要一行......数据将在网格中，只是少了很多代码......

Answer 4

好的...使用一些 @rajat 和 @Aaron 示例，我制作了一个在 DateTimePicker 单元格上弹出的示例。谢谢大家。

Private Sub DataGridView1_CellClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellClick

    If e.ColumnIndex = 8 Then 'CHECK IF IT IS THE RIGHT COLUMN

        'SET SIZE AND LOCATION
        Dim rect = DataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, True)
        DateTimePicker1.Size = New Size(rect.Width, rect.Height)
        DateTimePicker1.Location = New Point(rect.X + 10, rect.Y + 76) 'USE YOU OFFSET HERE

        DateTimePicker1.Visible = True
        ActiveControl = DateTimePicker1

    End If

End Sub


Private Sub DateTimePicker1_ValueChanged(sender As Object, e As EventArgs) Handles DateTimePicker1.ValueChanged

    If DataGridView1.RowCount > 0 Then 'JUST TO AVOID FORM LOAD CRASH

        DataGridView1.CurrentCell.Value = DateTimePicker1.Value.ToShortDateString
        DateTimePicker1.Visible = False

    End If

Answer 5

要解决在 DataGridView 中使用 DateTimePicker 时的一些输入问题，您需要将以下内容添加到上面引用的 Microsoft 示例中。我花了相当长的时间才找到 valuechanged 事件未按预期触发的问题。修复来自这里（stackoverflow）并在下面翻译成 C#。在此处添加此信息似乎很合适，因为我在 DataGridView 和 DateTimePicker 上搜索时不断找到此论坛帖子。

    protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
    {

        switch (keyData & Keys.KeyCode)
        {
            case Keys.Enter:
            case Keys.Tab:
                this.dataGridView.Focus();
                break; 
        }

        return base.ProcessCmdKey(ref msg, keyData);

    }

Answer 6

使用 RowsAdded 事件，如下所示 -

 private void dgvEducationalData_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
    {
        DataGridViewRow row = dgvEducationalData.Rows[e.RowIndex];
        Console.WriteLine("Rows added");
        if (e.RowIndex != -1)
        {
            foreach (DataGridViewCell cell in row.Cells)
                if (cell.ColumnIndex == 2 || cell.ColumnIndex == 1)
                {

                    dateTimePicker = new DateTimePicker();
                    dateTimePicker.Font = new Font("Segoe UI", 10);
                    dgvEducationalData.Controls.Add(dateTimePicker);
                    dateTimePicker.Format = DateTimePickerFormat.Short;
                    Rectangle oRectangle = dgvEducationalData.GetCellDisplayRectangle(cell.ColumnIndex, e.RowIndex, true);
                    dateTimePicker.Size = new Size(oRectangle.Width - 2, oRectangle.Height - 10);
                    dateTimePicker.Location = new Point(oRectangle.X, oRectangle.Y);

                }
        }
    }

Answer 7

我认为 DateTimePicker 上的 CloseUp 事件更合适，因为更改的值会在任何更改时触发，而 CloseUp 仅在选择整个日期时触发