Datetime picker in Datagridview

Question

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

Aman Gupta · Answer

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 Ahmed · Answer

https://csharp-tutorials1.blogspot.com/2016/02/add-datetimepicker-in-datagridview.html?m=1