[Solved] ASP.Net Error: String was not recognized as a valid DateTime

Question

I have a situation where some columns and rows will be empty based on the type of data required for each particular event Some event may not require time or date as the case may be So in some of the columns in my database table there are situations where some rows are empty But when I navigate the page where some information are supposed to display I get an error because of an empty column or rowString was not recognized as a valid DateTimeDescription An unhandled exception occurred dur

Mudassar · Accepted Answer

Your 2nd row data for Timed and Dated column is NullAdd Null checkdatelblText  dsTables0Rows034Dated34  null  ConvertToDateTimedsTables0Rows034Dated34ToLocalTimeToString34MMM d yyyy34  3434timelblText  dsTables0Rows034Timed34  null  dsTables0Rows034Timed34ToString  3434

AjayV · Answer

Hi RichardSaBefore converting to DateTime you need to check weather the column value is null or notIf not null then use convert functionHTMLltaspLabel ID34lblShippedDate34 runat34server34gtltaspLabelgtNamespacesCusing SystemDatausing SystemConfigurationusing SystemDataSqlClientVBNetImports SystemDataImports SystemConfigurationImports SystemDataSqlClientCodeCprotected void PageLoadobject sender EventArgs e    if thisIsPostBack            thisPopulateLabel    private void PopulateLabel    DataTable dt  new DataTable    string conString  ConfigurationManagerConnectionStrings34constr34ConnectionString    using SqlConnection con  new SqlConnectionconString            using SqlCommand cmd  new SqlCommand34SELECT TOP 1 ShippedDate FROM Orders WHERE OrderId  1106034 con                    using SqlDataAdapter sda  new SqlDataAdaptercmd                            sdaFilldt                i

AjayV · Answer

Hi RichardSaYou are passing the value of date as 13Mar23 and you are formatting like ldquoMMM d yyyyrdquo instead you need to formate like ddMMMyy and use DateTimeParseExactRefer below codeHTMLltaspLabel ID34lblDate34 runat34server34gtltaspLabelgtCodeCprotected void PageLoadobject sender EventArgs e    string date  3413Mar2334    lblDateText  DateTimeParseExactdate34ddMMMyy34 CultureInfoInvariantCultureToString

AjayV · Answer

RichardSa saysdatelblText  drDated  DBNullValue  datelblText  drDated  defaultDateTime  stringnull  ConvertToDateTimedrDatedToLocalTimeToStringMMM d yyyy                        timelblText  drtimed  DBNullValue  timelblText  drtimed  defaultDateTime  stringnull  ConvertToDateTimedrtimedToLocalTimeToStringhhmm tt Change above code with below linesif dr34Dated34  DBNullValue  ConvertToDateTimedr34Dated34  defaultDateTime    ConvertToDateTimedr34Dated34ToLocalTimeToString34MMM d yyyy34if dr34timed34  DBNullValue  ConvertToDateTimedr34timed34  defaultDateTime    ConvertToDateTimedr34timed34ToLocalTimeToString34hhmm tt34

[Solved] ASP.Net Error: String was not recognized as a valid DateTime

Company

Explore

Follow us

Contact Us