How to change the date time format of datagridview1 please help

Question

0.00/5 (No votes)

See more:

I want to change the date time format of datagridview1 but is it not work please help me

change date time format no 6 to No 11 column format is

VB

dd/MMM/yyyy hh:mm:ss tt"

My Code is

VB

Private Sub loadfiles_1()
        Dim dt As New DataTable
        dt.Columns.Add("Name")
        dt.Columns.Add("Full Name")
        dt.Columns.Add("Parent")
        dt.Columns.Add("Exists")
        dt.Columns.Add("Root")
        dt.Columns.Add("Extension")
        dt.Columns.Add("Creation Time")
        dt.Columns.Add("Creation Time Utc")
        dt.Columns.Add("LastAccess Time")
        dt.Columns.Add("LastAccess Time Utc")
        dt.Columns.Add("Last Write Time")
        dt.Columns.Add("Last WriteTime Utc")
        dt.Columns.Add("Attributes")
        dt.Columns.Add("Length")
        dt.Columns.Add("IsReadOnly")

        'Try
        '  Dim directory = Label3.Text
        Dim dirinfo As New DirectoryInfo(Label3.Text)

        Try
            Dim files As System.IO.FileInfo() = Nothing
            For Each directory In dirinfo.GetDirectories()
                Try
                    If (directory.Attributes <> FileAttributes.System) Then

                        files = directory.GetFiles("*", SearchOption.AllDirectories)

                    End If

                    For Each File In files
                        Dim dr As DataRow = dt.NewRow()
                        dr(0) = File.Name
                        dr(1) = File.FullName
                        dr(2) = File.DirectoryName
                        dr(3) = File.Exists
                        dr(4) = File.Directory
                        dr(5) = File.Extension
                        dr(6) = File.CreationTime
                        dr(7) = File.CreationTimeUtc
                        dr(8) = File.LastAccessTime
                        dr(9) = File.LastAccessTimeUtc
                        dr(10) = File.LastWriteTime
                        dr(11) = File.LastWriteTimeUtc
                        dr(12) = File.Attributes
                        dr(13) = File.Length
                        dr(14) = File.IsReadOnly
                        dt.Rows.Add(dr)
                    Next
                Catch ex As Exception
                End Try
            Next
        Catch ex As UnauthorizedAccessException
        End Try
        DataGridView1.DataSource = dt
    End Sub

What I have tried:

VB

DataGridView1.Columns(6).DefaultCellStyle.Format = "dd/MMM/yyyy hh:mm:ss"

Posted 15-May-22 6:25am

Jayanta Modak

Updated 15-May-22 22:25pm

v2

Add a Solution

Comments

Richard MacCutchan 16-May-22 3:55am

"but is it not work please help me"
How can we help if you do not explain what the problem is? Saying, "it is not working", tells us nothing.

Jayanta Modak 16-May-22 6:54am

thanks sir for reply actually the problem is i want to fix the date time format "dd/MMM/yyyy hh:mm:ss"
but when I try my tried code nothing do change

Richard MacCutchan 16-May-22 6:58am

Try what Richard Deeming suggests below.

Jayanta Modak 16-May-22 7:53am

thanks sir

1 solution

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)

Richard Deeming · Accepted Answer · 2022-05-15T22:25:00

DataColumnCollection.Add Method (System.Data) | Microsoft Docs[^]:
By default, the DataType for the new column is string.

Specify the correct data-type for the columns when you add them:

VB.NET

Dim dt As New DataTable
dt.Columns.Add("Name", GetType(String))
dt.Columns.Add("Full Name", GetType(String))
dt.Columns.Add("Parent", GetType(String))
dt.Columns.Add("Exists", GetType(Boolean))
dt.Columns.Add("Root", GetType(String))
dt.Columns.Add("Extension", GetType(String))
dt.Columns.Add("Creation Time", GetType(DateTime))
dt.Columns.Add("Creation Time Utc", GetType(DateTime))
dt.Columns.Add("LastAccess Time", GetType(DateTime))
dt.Columns.Add("LastAccess Time Utc", GetType(DateTime))
dt.Columns.Add("Last Write Time", GetType(DateTime))
dt.Columns.Add("Last WriteTime Utc", GetType(DateTime))
dt.Columns.Add("Attributes", GetType(System.IO.FileAttributes))
dt.Columns.Add("Length", GetType(Long))
dt.Columns.Add("IsReadOnly", GetType(Boolean))

Your format string should then work as expected.