DataGridView Column Type Property

Question

DataGridView Column Type Property

Imad Almuzain 21

Hello
On following document show how to define the DataGridView Column Type, and define calendar column,

https://learn.microsoft.com/en-us/dotnet/desktop/winforms/controls/how-to-host-controls-in-windows-forms-datagridview-cells?view=netframeworkdesktop-4.8&redirectedfrom=MSDN#compiling-the-code

Could please help, after that how to show the "CalendarColumn" type to appear in the Column types list of DataGridview column types to choose it where required, as shown on following photo

Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2021-04-14T14:55:13.617+00:00

removed azure tag
Viorel 126.3K Reputation points

2021-04-14T15:23:42.327+00:00

Is it a Forms project that is based on .NET Framework (not Core) and what kind of data source are you using for this grid?

Answer accepted by question author

2 additional answers

Your answer

Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2021-04-14T14:55:13.617+00:00

removed azure tag
Viorel 126.3K Reputation points

2021-04-14T15:23:42.327+00:00

Is it a Forms project that is based on .NET Framework (not Core) and what kind of data source are you using for this grid?

Answer 1

Karen Payne MVP 35,596 Volunteer Moderator

I have a code sample for this in C# but not VB .NET.

See Windows forms DataGridView dates and numeric columns (C#) article and source code for using in C#.

Here is a starter project on GitHub.

Answer 2

Imad Almuzain 21

many thanks karenpayneoregon for reply,

one question only, when I have the CalendarColumn Class added to project,
what else should do to let Calendar Column type appear in the list,?

thanks

Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2021-04-14T17:51:30.57+00:00
The screenshot shows how to add the column

Once added, select the property window for the column, set the DataPropertyName (this is the field name in a DataTable or a property name from a container/class)

Set the DataSource of the DataGridView to the DataTable or List that has the value set in DataPropertyName above.

The above although done in the designer can be done in code while doing this in code has no value per-say.

Lastly, when you say list surely you mean the DataGridView as a list may or may not be the DataSource of the DataGridView and if using a list that means the DataGridView is not sortable and should use a BindingSource linked to a BindingList where the BindingSource becomes the DataSource of the DataGridView.
Imad Almuzain 21 Reputation points

2021-04-14T18:08:48.063+00:00

Hello

This is screen shot,

all column types are there but no "Calendar Column" !!

this what I mean in "list", list of types like textbox, checkbox, combobox ..etc.. but not show the "CalendarColumn" which suppose to be read from the class was added

Its shown in your screen shot but not appear with me..

thanks
Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2021-04-14T18:22:02.767+00:00

After adding the CalendarColumn to the project you then need to build the project before the CalendarColumn will appear in the list of columns. So before build it will not show in the list or in the toolbox, after building it will show in the list and toolbox.
Imad Almuzain 21 Reputation points

2021-04-14T19:11:04.613+00:00

Thanks a lot karenpayneoregon for help..

it was solved by changing the "Target CPU" to "AnyCPU" on Compile tab,,
I was selected 64,

much appreciated

Answer 3

Karen Payne MVP 35,596 Volunteer Moderator

Here is a full code sample, took about 10 minutes to write. To run requires a SQL-Server database (I don't have another database e.g. MS-Access, Oracle, MySql ready)

In the repository run this data script in SSMS (SQL-Server Management Studio)
Build
Run

Share via

DataGridView Column Type Property

2 additional answers

Your answer