Date Input textbox dd/MM/yyyy

If you allow users to enter date via a text box control, then you have to constantly worry about the validity of date value and format that they enter. The format that you gave: "19/10/1977" is not recognized as valid date in .net, let alone passing it to the sql. See the example below:

Imports System
Imports System.Globalization
				
Public Module Module1
	Public Sub Main()
		
		Dim datestring AS string = "19/10/1977"
		Dim dt AS Date    
		If Date.TryParse(datestring, dt)
			Console.WriteLine("date string is valid")
		Else
			Console.WriteLine("date string is NOT valid")
		End If
		
	End Sub
	
End Module

The TryParse method will try to converts the specified string representation of a date and time to its DateTime equivalent, and returns a value that indicates whether the conversion succeeded. In your case, it failed. If you change the datestring to "1977/10/19", then it works. But do you have to go to all these troubles?
My advice is use a Calendar control provided by ASP.NET which will automatic return a valid date value that the user picks and can be inserted directly into any sql parameter without fuss. Refer: asp.net_calender[^]

hello... see here simple example

DateTime now = DateTime.Now;
                 string rnow = "dd/MM/yyyy";// here you can set date formats
                 var rvar = (now.ToString(rnow));

use maskededit extender

this control won't allow the user to change the format

<asp:textbox id="txtbox" runat="server" cssclass="textbox" width="150px" xmlns:asp="#unknown"></asp:textbox> <asp:calendarextender xmlns:asp="#unknown">
                    ID="CalendarExtender1" Format="dd/MM/yyyy" TargetControlID="txtbox" runat="server">
                </asp:calendarextender>
                <asp:maskededitextender id="MaskedEditExtender2" targetcontrolid="txtbox" masktype="Date" mask="99/99/9999" runat="server" xmlns:asp="#unknown">
                </asp:maskededitextender>

buddie you dnt have to do this if you want to see that your code is proper then just write

Public Class WebForm1
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
        TextBox1.Text = Calendar1.SelectedDate
    End Sub
End Class

this code is for just checking whether you are getting correct date or not.
then on some Submit(button) event save value in database
or directly you can save date in database by using GetDate() function in insert query where data will be inserted into database without manually taking date from user.

Default format of the DateTime is MM/dd/yyyy.

You are providing input in the dd/MM/yyyy.

So before converting into the datetime you should convert the user input date time format to the MM/dd/yyyy and then you should typecast.

string date = "21/10/1977";
string[] dates = date.Split('/');

DateTime dtt = DateTime.Parse(string.Format("{0}/{1}/{2}", dates[1], dates[0], dates[2]));

Thanks

here is the sample code while designing the text box with date control and format:

Try like this it may help you

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="CC1" %>

<asp:TextBox ID="TXTValidFrom" Enabled="false" runat="server" CssClass="HtmlTxt"   onblur="javascript:checkdate('TXTValidFrom');"Width="170px" TabIndex="33"></asp:TextBox>
 <asp:ImageButton runat="Server" ID="ImageButton3" ImageUrl="~/AppImages/calbtn.gif"
AlternateText="Click to show calendar" Height="16px" Width="16px" TabIndex="33" />
<CC1:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="TXTValidFrom"
PopupButtonID="ImageButton3" Format="dd/mm/yyyy">
</CC1:CalendarExtender>

Script for check date:

function checkdate(sender) {
    var datevalue = document.getElementById(sender).value.trim();
    if (datevalue != '') {
        if (datevalue.length == 6) {
            var today = new Date();
            var todayYear = today.getFullYear();
            var i, j, Day = '', Month = '', Year = '', AYear = '';

            for (j = 0; j < String(todayYear).length; j++) {
                if (j == 0 || j == 1) {
                    AYear = AYear + String(todayYear).charAt(j);
                }
            }
            for (i = 0; i < datevalue.length; i++) {
                if (i == 0 || i == 1) {
                    Day = Day + datevalue.charAt(i);
                }
                if (i == 2 || i == 3) {
                    Month = Month + datevalue.charAt(i);
                }
                if (i == 4 || i == 5) {
                    Year = Year + datevalue.charAt(i);
                }
            }
            datevalue = Day + "/" + Month + "/" + AYear + Year;
            document.getElementById(sender).value = datevalue;
        }
        if (datevalue.indexOf('/') > -1 && (datevalue.length > 6 && datevalue.length == 10)) {
            if (!isDate(datevalue)) {
                document.getElementById(sender).focus();
                document.getElementById(sender).select();

            }
        }
        else {
            alert("The date format should be : ddmmyy Or dd/mm/yyyy");
            document.getElementById(sender).focus();
            document.getElementById(sender).select();
            return false;
        }
    }
}