I am using VS 2012 asp.net web project and VB.net as programming language.
I have on my form a `textbox` field that its `textmode` property is set to `Date` (Datepicker).
<asp:TextBox ID="DobTxt" Text='<%# Bind("DobTxt", "{0:yyyy-MM-DD}")%>' TextMode="Date" runat="server" style="margin-left: 0px" Width="246px"></asp:TextBox>
when I run the following code I can't retrieve the date saved in the record,
Protected Sub Srch_Click(sender As Object, e As EventArgs) Handles Srch.Click
Dim ARTSQLCON As SqlConnection = New SqlConnection("Data Source=EMBRYOLOGIST;Initial Catalog=ARTSQL;Integrated Security=True")
Try
ARTSQLCON.Open()
If Not Len(FilenumSrc.Text) = 0 Then
Dim sqlread = New SqlCommand
sqlread.CommandText = "SELECT Filenum, DOB FROM TblReg WHERE Filenum = " & FilenumSrc.Text
sqlread.Co ...
Go to the complete details ...