String was not recognized as a valid DateTime.

Question

0.00/5 (No votes)

See more:

I'm using a label named lblDateAssoc to display date, I convert this label into datetime datatype inside my blDoc.addDoc. Now the problem is it can't be null, everytime I leave the label blank/null the message error says that the string cannot be recognize as a valid datetime. My goal is to just simply leave the label empty when date is not specified. Thanks for helping.

here's the code that assigns the null value to my label:

C#

String dateT;
                if (lblDateAssoc.Text == "")
                {
                    dateT = " ";
                }
                else
                {
                    dateT = Convert.ToDateTime(lblDateAssoc.Text);
                }

Now here's the code the writes on the database:

VB

blDoc.addDoc(idSY, idUser, idS, txtTitle.Text.ToUpper(),
                       catergoryS,
                       Convert.ToDate(dateT),
                       dateC,
                       idA,
                    purpose,
                     txtAtt.Text,
                     DocStat,
                     randomN);

Posted 30-Aug-13 4:45am

timJosh

Updated 30-Aug-13 4:47am

v2

Add a Solution

Comments

idenizeni 30-Aug-13 17:03pm

The code where you say you are assigning your date to the label is actually pulling the date from the label. Are you trying to read the date from the label and pass it to your database? is this the issue or are you really having an issue setting the label text? If it's the database update... does your database table allow NULLs in this date field? Is it a date type on the database server?

Anand Kumar Prajapati 31-Aug-13 2:13am

modify ur code like this -

string dateT=string.Empty;
if(string.IsNullOrEmpty(lblDateAssoc.Text)==false)
dateT = DateTime.TryParse(lblDateAssoc.Text);

hope this serve your purpose

4 solutions

Solution 3

You can also use IFormatProvider to parse your variable to datetime with the specified format.

Below is the sample code....
The format variable can have any format type like
string sFormat = ""dd/MM/yyyy";

C#

public string GetFormattedDate(string date, string sFormat)
        {
            string fdate = "";
            try
            {
                if (date != "")
                {
                    IFormatProvider f = new CultureInfo(DATECULTURE, false);
                    DateTime d = DateTime.Parse(date, f);
                    fdate = d.ToString(sFormat);
                }
            }
            catch
            {

            }
            return fdate;
        }

Posted 30-Aug-13 19:34pm

Thomas ktg

Solution 5

1. If your database field is datetime and allows null then only you can insert null values but here you inserting blank value. Null and blank spaces are different.So if you want to insert null value in field then it should b null value not blank space.Also use tryparse if you are converting datetime and also check server datetime format.For that convert in proper format also.

Posted 1-Sep-13 18:18pm

sp_suresh

Updated 1-Sep-13 18:44pm

v2

Solution 6

I assume that .addDoc (eventually) wraps a SQL insert/update in which case handing null on to the DB shouldn't cause any problems providing you are allowed to modify the .addDoc method to accept Nullable<Date>. If that's the case then the following might be suitable.

C#

DateTime intermediate;
Nullable<datetime> dt = null;
string userInput = lblDateAssoc.Text;

if (!String.IsNullOrEmpty(userInput) &&
     DateTime.TryParse(userInput, out intermediate)) {

  dt = intermediate;

}

// Hand off to DB.
// Assumes that the DB write method can be rejigged to take a
// Nullable<datetime>
blDoc.addDoc(..., dt, ...);

Posted 2-Sep-13 9:13am

cigwork

Updated 2-Sep-13 9:14am

v2

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)

Nitesh Kejriwal · Accepted Answer · 2013-08-30T04:51:00

Solution 1

To convert a string into DateTime variable, use DateTimme.TryParse() function:

http://msdn.microsoft.com/en-us/library/system.datetime.tryparse.aspx[^]

Posted 30-Aug-13 4:51am

Nitesh Kejriwal

Updated 30-Aug-13 10:20am

v3