Want to Show dates in dataGridView Columns.

Accepted answer

Hi

You can use this code

dataGrid.Columns[2].DefaultCellStyle.Format = "MM/dd/yyyy hh:mm:ss tt";

0

Hi

if you have data in your database(Sql Server Means) using Query restricted like this then you can achive

following this Query

Select convert(NVARCHAR(12),GETDATE(),100) --Jun 21 2018

Select convert(NVARCHAR(12),GETDATE(),101) --06/21/2018

Select convert(NVARCHAR(12),GETDATE(),106) --21 Jun 2018

Select convert(NVARCHAR(12),GETDATE(),111) --2018/06/21

0

I want to show date/Callender in gridview like below example.

0