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()