Accept All Kind of Datetime in Windows Application

Question

0.00/5 (No votes)

See more:

Hi,

i'm Working in Windows Application. I'm Developing Simple Notification System based c#.net with datetime concept. this project working in my system. i need validate datetime as dd/MM/yyyy while validate in client system error occur as string not recognized as a valid datetime. becoz client system have system formatted : dd MMMM yyyy

let me know how to accept all kind of datetime format in my project..

Used Code

C#

public bool DateValidation(string stringDateValue)
        {
            bool A = false;
            try
            {
                CultureInfo CultureInfoDateCulture = new CultureInfo("fr-FR");
                DateTime d = DateTime.ParseExact(stringDateValue, "dd/MM/yyyy", CultureInfoDateCulture);
                A = true;
            }
            catch
            {
               
                        A = false;
            }
        

            return A;
        }

Posted 25-Jul-14 20:34pm

Brinda Arumugam

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)

OriginalGriff · Answer 1 · 2014-07-25T20:41:00

Solution 1

Don't assume any format: just use the current format and that should be what the user entered (since that's what he likes to use):

C#

public bool DateValidation(string stringDateValue)
    {
    DateTime d;
    return DateTime.TryParse(stringDateValue, out d);
    }

Or better still, use a DateTimePicker and you don't need to validate it as a valid DateTime as the user can't enter a "bad" one.

Posted 25-Jul-14 20:41pm

OriginalGriff

Comments

Brinda Arumugam 26-Jul-14 2:50am

thanks for reply ...
but i want to validate date in datagridview cell.so we should tell to client whats the format or any other solution for datagridview datetime cell ?

OriginalGriff 26-Jul-14 2:57am

Depends on *where* the data came from: the source should be a DateTime value (i.e. the DataTable or whatever you used as the source should have a DateTime column) in which case it is already valid, and just needs presenting in the current users preferred format - which happens automatically.

The problem only occurs when the data source is not a DateTime: if for example a database has date information stored as a string. In that case, you are in real trouble: you don;t know what format the data was entered in when it was stored so you can't validate it as a valid date now.

For example, if the string is "31/2/16" is that 16th Feb 2031, or 16th Feb 1931, or 31st Feb 2016? Only the last is invalid as a DateTime!

So, where does the data come from?

Brinda Arumugam 26-Jul-14 3:55am

Date come from datagridview cell

this s my code
<pre lang="c#">
if (e.ColumnIndex == 1)
{
if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == DBNull.Value || dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].FormattedValue.Equals(""))
{ }
else
{
String cleanedString = System.Text.RegularExpressions.Regex.Replace(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(), @"\s+", " ");
dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = cleanedString.Trim();

if (T.DateValidation(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()) == false)
{
MessageBox.Show("Invalid Date Format!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "";
}
}
}
</pre>

When i get date from datagridview cell that time only this error occur...

OriginalGriff 26-Jul-14 4:13am

No, I meant where did the datagridview cell get the data from in the first place - it's probably too late buy the time it's in the DGV!

Brinda Arumugam · Answer 2 · 2014-12-22T19:55:00

Solution 2

C#

DateTime d = DateTime.ParseExact(stringDateValue,  new string[] { "dd/MM/yyyy", "MM/dd/yyyy", "dd MMMM yyyy" }, CultureInfoDateCulture, DateTimeStyles.None);

Posted 22-Dec-14 19:55pm

Brinda Arumugam