Datetime picker in Datagridview

Smile

I want to display a time(only HH:mm) in a column of datagridview.Below is the code which tried .The type for column is DataGridViewTextBoxColumn

Adding row to grid using below code

private void btnAdd_Click(object sender, EventArgs e)
{
dgvDatetime.Rows.Add(1);
}
private void dgvDatetime_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
//Initialized a new DateTimePicker Control
oDateTimePicker = new DateTimePicker();
//Adding DateTimePicker control into DataGridView
dgvDatetime.Controls.Add(oDateTimePicker);
// Setting the format (i.e. 2014-10-10)
oDateTimePicker.Format = DateTimePickerFormat.Custom;
oDateTimePicker.CustomFormat = "HH:mm";
oDateTimePicker.ShowUpDown = true;
// It returns the retangular area that represents the Display area for a cell
Rectangle oRectangle = dgvDatetime.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true);
//Setting area for DateTimePicker Control
oDateTimePicker.Size = new Size(oRectangle.Width, oRectangle.Height);
// Setting Location
oDateTimePicker.Location = new Point(oRectangle.X, oRectangle.Y);
// An event attached to dateTimePicker Control which is fired when DateTimeControl is closed
oDateTimePicker.CloseUp += new EventHandler(oDateTimePicker_CloseUp);
// An event attached to dateTimePicker Control which is fired when any date is selected
oDateTimePicker.TextChanged += new EventHandler(dateTimePicker_OnTextChange);
// Now make it visible
oDateTimePicker.Visible = true;
}
}
private void dateTimePicker_OnTextChange(object sender, EventArgs e)
{
// Saving the 'Selected Date on Calendar' into DataGridView current cell
dgvDatetime.CurrentCell.Value = oDateTimePicker.Text.ToString();
}
void oDateTimePicker_CloseUp(object sender, EventArgs e)
{
// Hiding the control after use
oDateTimePicker.Visible = false;
}
By adding a button i am testing the value as below
private void btnget_Click(object sender, EventArgs e)
{
try
{
string _fromtime = dgvDatetime.Rows[0].Cells["ColFromTime"].Value.ToString();
}
catch (Exception ex)
{
ex.ToString();
// throw;
}
}

By the above code i get the time only when i click in the cell and when i want to read the cell value it returns null.If and only if i click in the cell and edit the datetimepicker i can read the value of the cell.But i want to get the time in cell on adding the row to datagrid and get the value of the cell even if i dont edit the datetimepicker

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aman Gupta6y ago
Here's a way to handle grid events with the laid out strategy:
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
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;
}
And Here's a basic setup for a form that has a DataGridView added to it
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() { 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; }
}
Farhan Ahmed6y ago
https://csharp-tutorials1.blogspot.com/2016/02/add-datetimepicker-in-datagridview.html?m=1