Please help date I am trying to pass is 15032022txtDOBText DateTimeParseRDR2Item34Dbirth34ToString34ddMMyyyy34it flags this error Se

Hi makumbiPlease use CultureInfo class which represents a specific culture or a specific language in a specific countryregion in date and time formattingPlease refer below sampleHTMLlttablegt lttrgt lttdgtDateTime1 lttdgt lttdgtltaspTextBox ID34txtDateTime134 runat34server34 gtlttdgt lttrgt lttrgt lttdgtDateTime2 lttdgt lttdgtltaspTextBox ID34txtDateTime234 runat34server34 gtlttdgt lttrgtlttablegtNamespacesCusing SystemGlobalizationVBNetImports SystemGlobalizationCodeCprotected void PageLoadobject sender EventArgs e DateTime dt1 DateTimeParseExact342406198534 34ddMMyyyy34 CultureInfoInvariantCulture DateTime dt2 DateTimeParse342401199234 new CultureInfo34enGB34 txtDateTime1Text dt1ToString txtDateTime2Text dt2ToStringVBNetProtected Sub PageLoadByVal

Convert dd/MM/yyyy DateFormat String to DateTime using DateTime.Parse in C# and VB.Net

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on Mar 14, 2022 10:51 PM
Forum: ASP.Net Basics
Answer: 1
Views: 6817
Sample Code: Download

Please help date I am trying to pass is 15/03/2022

txtDOB.Text = DateTime.Parse(RDR2.Item("Dbirth").ToString("dd/MM/yyyy"))

it flags this error

Server Error in '/' Application.

Input string was not in a correct format. 
  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: Input string was not in a correct format.

Source Error: 

Line 21:      ddlclass.SelectedItem.Text = RDR2.Item("class").ToString
Line 22:      ' txtDOB.Text = RDR2.Item("Dbirth").ToString
Line 23:      txtDOB.Text = DateTime.Parse(RDR2.Item("Dbirth").ToString("dd/MM/yyyy"))
Line 24:      txtYear.Text = RDR2.Item("yeara").ToString
Line 25:      ddlclass0.SelectedItem.Text = RDR2.Item("category").ToString
  

Source File:  C:\Users\Makumbi\source\repos\INTERVIEWSVB\INTERVIEWSVB\Forms\EditRegistration.aspx.vb    Line:  23 

Stack Trace: 

[FormatException: Input string was not in a correct format.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +224
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +92

[InvalidCastException: Conversion from string "dd/MM/yyyy" to type 'Integer' is not valid.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +248
   INTERVIEWSVB.EditRegistration.Page_Load(Object sender, EventArgs e) in C:\Users\Makumbi\source\repos\INTERVIEWSVB\INTERVIEWSVB\Forms\EditRegistration.aspx.vb:23
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693 


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4465.0

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

arjunv

0 2

Reply
ANSWER
User: arjunv
Replied: on Mar 15, 2022 05:05 AM
Modified: on Jun 13, 2022 10:16 AM
Report

Hi makumbi,

Please use CultureInfo class, which represents a specific culture or a specific language in a specific country/region in date and time formatting.

Please refer below sample.

HTML

<table>
    <tr>
        <td>DateTime1 :</td>
        <td><asp:TextBox ID="txtDateTime1" runat="server" /></td>
    </tr>
    <tr>
        <td>DateTime2 :</td>
        <td><asp:TextBox ID="txtDateTime2" runat="server" /></td>
    </tr>
</table>

Namespaces

using System.Globalization;

VB.Net

Imports System.Globalization

Code

protected void Page_Load(object sender, EventArgs e)
{
    DateTime dt1 = DateTime.ParseExact("24/06/1985", "dd/MM/yyyy", CultureInfo.InvariantCulture);
    DateTime dt2 = DateTime.Parse("24/01/1992", new CultureInfo("en-GB"));
    txtDateTime1.Text = dt1.ToString();
    txtDateTime2.Text = dt2.ToString();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim dt1 As DateTime = DateTime.ParseExact("24/06/1985", "dd/MM/yyyy", CultureInfo.InvariantCulture)
    Dim dt2 As DateTime = DateTime.Parse("24/01/1992", New CultureInfo("en-GB"))
    txtDateTime1.Text = dt1.ToString()
    txtDateTime2.Text = dt2.ToString()
End Sub

Screenshot

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

Convert dd/MM/yyyy DateFormat String to DateTime using DateTime.Parse in C# and VB.Net

Company

Explore

Follow us

Contact Us