How to convert SqlDbType datetime to string in VB

413 Views Asked by At

I want to display the date column into a textbox that a stored procedure returns. The error displays the column name. Thank you for your help!

SQL stored procedure:

SELECT MAX(NrTimesUpdated) AS NrTimesUpdated,   
       CONVERT(varchar(20),MAX(DateModified),101) AS DateEntered
FROM   Credentials
WHERE ID = @ID
END

VB code:

Dim cmd As New SqlClient.SqlCommand
cmd = New SqlCommand("get_credentials", cn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = lblID.Text
Dim rdr = cmd.ExecuteReader
If rdr.Read Then
   lblDate.Text = rdr("DateEntered").ToString().Trim()
End If
rdr.Close()
0

There are 0 best solutions below