C # windows forms sort date format text datagridview

Question

0.00/5 (No votes)

See more:

Hello,
I am on demoralized!
I switched to Sqlite with my windows forms c #, great.
Finally, knowing that there is no date format, I opted for text in dd / MM / yyyy format.
The concern now is that my Datagridview is not sorting the dates correctly.
There are a lot of topics on the web, but I can't ...

I need a little help please to find an answer….

Is it possible to sort a column by code:

dd, then MM, then YYYY ignoring the slash (/)

C#

private void Datagridview1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {
           
                if (e.ColumnIndex == Datagridview1.Columns[1].Index)
                {
                     // ici le code
                }

        }

thank you,

What I have tried:

I changed the REAL, INTEGER, TEXT, NUMERIC formats but nothing helps.

Even with this example I don't understand ..

sortablebindinglist.zip.

Posted 8-Mar-20 4:58am

LSB71

Updated 8-Mar-20 8:26am

v2

Add a Solution

2 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)

Richard MacCutchan · Answer 1 · 2020-03-08T07:20:00

Solution 2

Use the SQLite Query Language: Date And Time Functions[^] to convert your strings, and pass proper DateTime vaues to the DataGridView.

Posted 8-Mar-20 7:20am

Richard MacCutchan

Comments

LSB71 8-Mar-20 14:34pm

Hello,
Thank you,
Indeed it works in the yyyy-MM-dd format and not in the dd / MM / yyyy format.
So with the code below it works ...
and I modify in Datagriview like this:
Datagridview1.Columns [1] .DefaultCellStyle.Format = "dd / MM / yyyy";
and it's great!
Hide Copy Code
if (e.ColumnIndex == Datagridview1.Columns[1].Index)
{
if (e.Value != null)
{

e.Value = DateTime.Parse(e.Value.ToString()).ToUniversalTime();

}
}

OriginalGriff · Answer 2 · 2020-03-08T05:10:00

At a guess, you are storing your dates wrong.
If you store dates as DATE or DATETIME in your DB, then they will get "fetched" into the DGV as .NET DateTime values - and those will sort correctly at all times, regardless of the format in which they are displayed to the user.

But ... if you store them in a VARCHAR or NVARCHAR field, then they will be imported as strings and string comparisons are different: they are always resolved by the first different character between the two strings being compared - no other data is involved at all.

So check your DB, and change your table design to store data in the most appropriate format - numbers in numeric fields, dates and times in DATE or DATETIME columns. Fix your DB input code to validate date based data and pass it to the DB via a parameterised query as a DateTime value.
And then it'll all just work.