0

hi
i am working with an application where i have to enter dob in textbox in the format "dd\MM\yyyy".what i have done yet is as below:

 Private Sub txtDOB_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtDOB.LostFocus
        If IsDate(txtDOB.Text) = True Then
            MsgBox("correct date")
        Else
            MsgBox("input correct date")
        End If
    End Sub

Now problem is that when i save this date to the sqlserver it just saved in the wrong format "MM\dd\yyyy".
My computer date format is also dd\MM\yyyy.
i am saving date using this code:

Dim sqlinsert As String
                sqlinsert = "INSERT INTO C_tab(FirstName,dob,phone,email)" & _
                "VALUES( @FirstName,@dob,@phone,@email)"
Dim cmd As New SqlCommand(sqlinsert, con)
cmd.Parameters.Add(New SqlParameter("@FirstName", UCase(txtFirstname.Text)))
cmd.Parameters.Add(New SqlParameter("@dob", txtDOB.Text))
cmd.Parameters.Add(New SqlParameter("@phone", txtcontactno.Text))
cmd.Parameters.Add(New SqlParameter("@email", txtemail.Text))
cmd.ExecuteNonQuery()
cmd.Dispose()

What i want is that user must entered date in correct format which i given and also that date must be save in the sqlserver database in the same format.

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by Reverend Jim
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.