Jquery datepicker value disappear after a submit button post

Hi,

i believe this question meet you all in good health,

My organisation have this application that save's patient clinic visit history written in VB.NET, i was asked to add some date validation rules to it so i used JQuery Datepicker. All worked fine till when patient record want to be saved, i found out that, the JQuery Datepicker always lost it value on the selected textbox when ever the "Submit button is click" AutopostBack issue.

And storing empty space as Date is invalid.

Any solution is highly appreciated.

Thank you all

<link href="Content/bootstrap.min.css" rel="stylesheet" />
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css"/>
<script src="https://code.jquery.com/jquery-1.12.4.js" type="text/javascript">script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js" type="text/javascript">script>
<script type="text/javascript">
$(function () {
$("#<%=txtPat_disp_date.ClientID%>").datepicker({
dateFormat: "dd-mm-yy",
changeMonth: true,
changeYear: true,
maxDate: '0',
showButtonPanel: true
});
});

Dim sql As String = "Insert into art_visit_adult (enrol_id,"
sql += "visit_date) VALUES(@enrol_id,@visit_date)"
Using d As New SqlConnection(cons.ConnectMe)
d.Open()
Dim cmd As New SqlCommand(sql, d)
cmd.Parameters.AddWithValue("@enrol_id", DbType.String).Value = txtEnrol_id.Text.Trim
cmd.Parameters.AddWithValue("@visit_date", SqlDbType.SmallDateTime).Value = Convert.ToDateTime(txtVisit_date.Text.ToString())
cmd.ExecuteNonQuery()
d.Close()
cmd.Dispose()

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Harshad Kathiriya8y ago
Accepted answer
I think, you need to use this txtPat_disp_date Textbox Id instead of this txtVisit_date id when you are storing the value to database.

cmd.Parameters.AddWithValue("@visit_date", SqlDbType.SmallDateTime).Value = Convert.ToDateTime(txtPat_disp_date.Text.ToString())