How to change date format in datagridview column which has datetimepicker in it

Question

0.00/5 (No votes)

See more:

Hi,

I have a datagridview in vb.net windows application.

I have datetimepicker in one of the column. (Courtesy Microsoft)

How do I change the date format to dd/MM/yyyy ( Default is MM/dd/yyyy)

Normally to change the format we do as below
datagridview1.Columns(0).DefaultCellStyle.Format = "dd/MM/yyyy" which I have done

But as I have datetimepicker in the datagrid column it seems it is not applying the style.

An early help is highly appreciated.

Cheers
Anand

Posted 3-Sep-12 1:29am

Anand Rangaraju

Updated 3-Sep-12 18:01pm

_Amy

v3

Add a Solution

3 solutions

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)

Rakesh_Sharma23 · Answer 1 · 2014-06-04T21:17:00

Solution 4

This can help

Dim xRowCount As Integer = 0
Do Until xRowCount = xDataGrid.RowCount
xDataGrid.Rows(xRowCount).Cells(2).Style.Format = Format("dd-MMM-yyyy")
xRowCount = xRowCount + 1
Loop

Posted 4-Jun-14 21:17pm

Rakesh_Sharma23

BheemG · Answer 2 · 2012-09-03T17:56:00

Hi Anand,

For Datetimepicker date format. refer
http://stackoverflow.com/questions/10589877/format-datetimepicker-in-datagridview-column

http://social.msdn.microsoft.com/forums/en-US/winformsdatacontrols/thread/bb5ef524-b2ba-4420-82ac-230d156695aa[^]

For gridview date column dateformat
Their are two ways you can do that

1 You can write a Function on the code behind page like
Public Function ReturnOnlyDate(TDate As String) As String
Try
If TDate.Length = 19 Then ' 12/30/1899 00:00:13
Return (TDate.Remove(10, 9))
End If
Catch ex As Exception
Return Nothing
End Try
Return Nothing
End Function
and you should convert the date field in the gridview to Template field. and in the source page you change the bound field like this

<asp:templatefield headertext="Date" xmlns:asp="#unknown">

<asp:label id="Label2" runat="server" text="<%# ReturnOnlyDate(Eval("TDate"))%>">

<asp:label id="Label2" runat="server" text="<%# ReturnOnlyDate(Eval("TDate")))%>">

2. You can DIrectly convert the field to Template field and in the source page your can do like this.

<asp:templatefield headertext="Date" xmlns:asp="#unknown">

<asp:label id="Label2" runat="server" text="<%# Bind("TDate", "{0:MM/dd/yyyy}") %>">

<asp:label id="Label2" runat="server" text="<%# Bind("TDate", "{0:MM/dd/yyyy}") %>">

This could help.

Sandeep Mewara · Answer 3 · 2012-09-03T02:34:00

Solution 1

DateTimePickers too can have date formats defined. Not sure which one you are using but it should have one of the property to specify the date format. Look for it and set as per need.

For MS datepicker: MSDN: DateTimePicker.CustomFormat Property [^]
Refer: MSDN: DateTimePicker Class[^]

Posted 3-Sep-12 2:34am

Sandeep Mewara

Comments

Anand Rangaraju 3-Sep-12 9:33am

Hi Sandeep,

First of all, thanks for the reply.

I could change the display format by setting in the following piece of code.
But the problem is the format is getting changed to MM/dd/yyyy again after the date selected.

Any idea how to keep the format in datagridview column after the date selection?

Public Sub New()
Me.Format = DateTimePickerFormat.Short
Me.CustomFormat = "dd/MM/yyyy"
Me.Format = DateTimePickerFormat.Custom
End Sub
This code is found in the below link.
http://msdn.microsoft.com/en-us/library/7tas5c80.aspx

Anand.

Sandeep Mewara 3-Sep-12 12:38pm

For datetimepicker, use controls custom format and for datagridview use the column format value.

Anand Rangaraju 3-Sep-12 12:54pm

Hi Sandeep,

I have already tried that as below

datagridview1.Columns(0).DefaultCellStyle.Format = "dd/MM/yyyy"

It didn't have any effect.

Please tell me if this is not the way you said.

Anand