placing datetimepicker in datagridview

Question

0.00/5 (No votes)

See more:

When a cell is edited in datagridview, I want to place datetimepicker in that cell.
I have written this piece of code but this doesn't seem to work.

Can any one help me in this?

C#

void DataGridView1DoubleClick(object sender, EventArgs e)
        {
MouseEventArgs args = (MouseEventArgs)e;
Point p = dataGridView1.PointToClient(new Point(args.X,args.Y));
DataGridView.HitTestInfo info = dataGridView1.HitTest(p.X, p.Y);
int Col=dataGridView1.CurrentCellAddress.X;
if(dataGridView1.Columns[Col].Name == "Employee name";)
            {
//              textBox1.text="hello";
//              textBox1.SetBounds(args.X,args.Y,dataGridView1.CurrentCell.Size.Width,dataGridView1.CurrentCell.Size.Height);
//                  textBox1.Show();
//                  DataGridTextBox.TextBox.Controls.Add( textBox1 );
//                textBox1.Text = DataGridView[DataGridView1.CurrentRowIndex , Col].ToString();
//                textBox1.Focus();
            }
            if(Col==3)
            {
                 //placing date time picker here..
            }
        }

thanks in advance.

Posted 30-Mar-11 18:53pm

girish sp

Updated 31-Mar-11 4:31am

Dalek Dave

v3

Add a Solution

Comments

Dalek Dave 31-Mar-11 10:32am

Edited for Grammar and Readability.

girish sp 1-Apr-11 0:45am

thanks dave..

4 solutions

Solution 2

i have come up with this code, working for me..thought of posting it here..it might help some one..any feedback on this code are welcome..

C#

        private DateTimePicker cellDateTimePicker;
        public MainForm()
        {
            //
            // The InitializeComponent() call is required for Windows Forms designer support.
            //
            InitializeComponent();
            this.cellDateTimePicker = new DateTimePicker();
            this.cellDateTimePicker.ValueChanged += new EventHandler(cellDateTimePickerValueChanged);
            this.cellDateTimePicker.Visible = false;
            this.dataGridView1.Controls.Add(cellDateTimePicker);
         
            if (e.ColumnIndex == column index which u want)

            {

                Rectangle tempRect = dataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false);

                cellDateTimePicker.Location = tempRect.Location;

                cellDateTimePicker.Width = tempRect.Width;

                cellDateTimePicker.Visible = true;

            }

void cellDateTimePickerValueChanged(object sender, EventArgs e)
        {
            dataGridView1.CurrentCell.Value = cellDateTimePicker.Value.ToString();//convert the date as per your format
            cellDateTimePicker.Visible = false;
    }

Posted 31-Mar-11 3:05am

girish sp

Updated 31-Mar-11 3:47am

v2

Comments

Toniyo Jackson 31-Mar-11 9:48am

Use the pre tag correctly

sagar.kandikatla 25-Nov-13 3:58am

how can i handle the left right key to change the value of date using key board please help me

girish sp 1-Apr-11 3:11am

sure..

Dalek Dave 31-Mar-11 10:33am

Good Call

girish sp 1-Apr-11 3:10am

thanks

Ngomana FT 20-Oct-17 16:17pm

I tried your code and looks like theres a lil bit of issues im experiencing from this code here. "if (e.ColumnIndex == column index which u want)".

I get this error, "the name 'e' doesn't not exist in the current context'. could you please rectify your mistake.

Solution 3

Solution 2 is excellent. Here is some clarification. This code could be called for CellClick(). CellContentClick(), CellContentDoubleClick(), and CellDoubleClick(). This code is tested and works in VS2012.

C#

private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
    if (e.ColumnIndex == column index which u want)

    {


        Rectangle tempRect = dataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false);

        cellDateTimePicker.Location = tempRect.Location;

        cellDateTimePicker.Width = tempRect.Width;

        cellDateTimePicker.Visible = true;

    }

}

Posted 26-Aug-14 5:46am

pianocomposer

Comments

Shakeeb Sadikeen 7-Sep-15 10:06am

Better use CellBeginEdit Event

Member 10186275 17-Nov-18 14:31pm

celldatetimepicker give me a red underline how can i solve it

Solution 4

Also see this from MSDN:

http://msdn.microsoft.com/en-US/library/7tas5c80(v=vs.110).aspx[^]

Although in the Form1 constructor, it appears that this line

C#

this.Load += new EventHandler(Form1_Load);

Results in the Load event being called twice. Not sure what the purpose of this is supposed to be, but when it is removed the example works fine.

Posted 6-Nov-14 11:48am

CaptainLazer

Comments

Maciej Los 6-Nov-14 17:52pm

It's very old question. The rule is: do not answer so old questions.
Please, delete this answer to avoid down-voting.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sarath Reviuri · Accepted Answer · 2011-03-31T02:29:00

Try the code specified below

C#

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            int myRow = 2;  // we'll place this functionality
            int myCol = 2;  // in the 2nd row and column of the control

            if ((e.RowIndex == myRow) & (e.ColumnIndex == myCol))
            {
                DateTimeForm myDTForm = new DateTimeForm();
                if (myDTForm.ShowDialog()== DialogResult.OK)
                {
                    // put the dialog result into the datagridview cell
                    ((DataGridView)sender)[myCol, myRow].Value = myDTForm.Tag;
                    ((DataGridView)sender).Invalidate(); // to update the grid
                }
            }
        }

I did not test this code. I found it while I was searching for some other query.
If that is not working let me know so that I can try fixing the code.

placing datetimepicker in datagridview

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us