I have a datagridview thats binded to a data source.   I have a column that is a DateTime and I'd like to use a DateTime picker to display the date and also give the user an easy way to select a new date when they add new items.

I'm using VB.net 2005

I've found lots of examples of doing this in C# but not for VB

cheers,
NateZilla77

Something like this should get you started:

http://www.mindfiresolutions.com/DateTime-Picker-Cell-in-DataGridView-317.php

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Hi NateZilla,

 

Do you mean the DataGridViewDateTimePickerColumn used in databinding mode?

 

I have tested the sample given by DeborahK, it works great. You can copy all the code into a cs file and use CalendarColumn this way.

Public Class Form1

    Private dtSource As DataTable = New DataTable()

 

    Public Sub New ()

        InitializeComponent()

 

        dtSource.Columns.Add("DateTimeCol" , GetType (String ))

        dtSource.Rows.Add(System.DateTime.Today.ToShortDateString())

 

        Dim calColumn As CalendarColumn = New CalendarColumn()

        calColumn.DataPropertyName = "DateTimeCol"

        DataGridView1.Columns.Add(calColumn)

 

        DataGridView1.DataSource = dtSource

    End Sub

End Class

 

Thank for DeborahK’s sharing. Hope this helps you NateZilla. If you have anything unclear, please feel free to tell me.

 

Sincerely,

Kira Qian

Send us any feedback you have about the help from MSFT at fbmsdn[At]microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework!

OK, I see what I have to do and I can get the calendar to show up in the datagrid, now my problem is the datagrid data source. I added the code from deborah into a class. I then added the code from Kira Qian into my form1 and everything cleared up. I just need to sort out the datasource I have the datagrid already binded to a table adapter from my dataset.xsd. Should I not do this?

Hi NateZilla,

> I just need to sort out the datasource I have the datagrid already binded to a table adapter from my dataset.xsd.

Do you mean you have set the DataSource property of DataGridView in the VS PropertyGrid? If so I think the only thing you need to do is set the DataPropertyName property to the column name of that date time column. If you have any difficulty about it, please post some code to let us know your project clearly.

Sincerely,
Kira Qian
Send us any feedback you have about the help from MSFT at fbmsdn[At]microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework!