I am stuck on a problem where I have a select statment, but the datareader can't get the string If there is no record in the table with the same intCID.
Here IS My Code:
Private Sub testPin(ByVal UserID As Integer, ByVal Password As String)
Try
Dim cmd As New SqlCommand...
That Does Not work. For the reason that sql cannot accept datetime in a string form. I have even tried to create a custome format for the dateTimePicker:
DateTimePicker1.Format = DateTimePickerFormat.Custom
DateTimePicker1.CustomFormat = "mm/dd/yyyy"
cmd.CommandText = "INSERT INTO tblDate...
Hallo
I need help to get values of a DateTimePicker Into the correct format for a SQL field with the datatype set to datetime, because I have to compare two dates later on.
I was told that it is possible, but can't find an answer on the net by searching.
Any help would be hugely appreaciated!
Hallo.
I am bussy with a project that is due in a weeks time. I am using vb. Net 2003 to connect to sql, but a problem have come up which I do not have a solution for.
I need to create a stored procudure that gives me the ability to get the last record in the tabel.
Table name: tblRent...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.