hiI used the below codeltdiv id34divmo134 runat34server34 Visible39ltEval34Dateconfirm34ToString 3434 false true gt39gt ltaspLabel ID34Lbldate34 runat34server34 Text39lttoPersianNumbermiladitoshamsiEval34Dateconfirm34ToStringgt39 CssClass34datereq334gtltaspLabelgtltdivgtltdiv id34divmo234 runat34server34 Visible39ltEval34Dateconfirm34To

nedash saysltaspLabel IDLbldate runatserver TextlttoPersianNumbermiladitoshamsiEvalDateconfirmToStringgt CssClassdatereq3gtltaspLabelgtRemove ToString from the Eval and pass only objectThen in code behind check the object parameter is null or not and return value as per your need using the IsDBNull method of Convert classHTMLltdiv id34divmo134 runat34server34 visible39ltEval34Dateconfirm34ToString 3434 false true gt39gt ltaspLabel ID34Lbldate34 runat34server34 Text39lttoPersianNumbermiladitoshamsiEval34Dateconfirm34gt39 CssClass34datereq334gtltaspLabelgtltdivgtCodepublic string miladitoshamsiobject miladi1 if ConvertIsDBNullmiladi1 DateTime miladi ConvertToDateTimemiladi1 SystemGlobalizationPersianCalendar shamsi new SystemGlobalizationPersianCalendar return stringF

[Solved] ASP.Net Error: String was not recognized as a valid DateTime when database column value is NULL

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Jun 14, 2022 08:47 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 2412
Sample Code: Download

hi,

I used the below code:

<div id="divmo1" runat="server" Visible='<%#Eval("Date_confirm").ToString() == "" ?false : true %>'>
    <asp:Label ID="Lbldate" runat="server" Text='<%#toPersianNumber(miladitoshamsi(Eval("Date_confirm").ToString()))%>' CssClass="datereq3"></asp:Label>
</div>
<div id="divmo2" runat="server" Visible='<%#Eval("Date_confirm").ToString() == "" ?true : false %>'>
    <asp:Label ID="Lbldasht" runat="server" Text='--' CssClass="datereq3"></asp:Label>
</div>

I want when in Date_confirm column in the database be the date it will show Lbldate and if there isn't any date I mean if in Date_confirm column be NULL value it will show lbldasht

but here when in Date_confirm column be NULL value the below error occurs:

String was not recognized as a valid DateTime.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: String was not recognized as a valid DateTime. Source Error:

Line 47:         public string miladitoshamsi(object miladi1)
Line 48:         {
Line 49:             DateTime miladi = Convert.ToDateTime(miladi1);
Line 50:             System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
Line 51:             return string.Format("{0}/{1}/{2}", shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi));

what should I do to solve this problem?

Best regards

Neda

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 5

Reply
ANSWER
User: dharmendr
Replied: on Jun 15, 2022 01:55 AM
Modified: on Jun 16, 2022 02:24 AM
Report

nedash says:

<asp:Label ID="Lbldate" runat="server" Text='<%#toPersianNumber(miladitoshamsi(Eval("Date_confirm").ToString()))%>' CssClass="datereq3"></asp:Label>

Remove ToString() from the Eval and pass only object.

Then in code behind check the object parameter is null or not and return value as per your need using the IsDBNull method of Convert class.

HTML

<div id="divmo1" runat="server" visible='<%#Eval("Date_confirm").ToString() == "" ?false : true %>'>
    <asp:Label ID="Lbldate" runat="server" Text='<%#toPersianNumber(miladitoshamsi(Eval("Date_confirm")))%>' CssClass="datereq3"></asp:Label>
</div>

Code

public string miladitoshamsi(object miladi1)
{
    if (!Convert.IsDBNull(miladi1))
    {
        DateTime miladi = Convert.ToDateTime(miladi1);
        System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
        return string.Format("{0}/{1}/{2}", shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi));
    }
    else
    {
        return string.Empty;
    }
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

[Solved] ASP.Net Error: String was not recognized as a valid DateTime when database column value is NULL

String was not recognized as a valid DateTime.

Company

Explore

Follow us

Contact Us