I'm trying to send the username to a stored procedure so that I can filter a data pull based on who the visitor is. I'm getting the error
Value of Type 'String' cannot be converted to 'System.Data.SqlClient.SqlParameter'.
Any thoughts on what I'm missing?
Dim parameterUsername As New SqlParameter("@username", SqlDbType.VarChar, 50)
parameterUsername = User.Identity.Name
myCommand.Parameters.Add(parameterUsername)
CREATE PROCEDURE [dbo].[timeOffTrainerGetItemsTrainerView]
(
@_Date datetime,
@_Date_Plus_1 datetime,
@username varchar(50)
)
AS
SELECT dbo.timeOff.timeOffId, dbo.timeOff.trainerId, dbo.timeOff.timeOffStartDate, dbo.timeOff.timeOffEndDate, dbo.timeOff.timeOffStartTime, dbo.timeOff.timeOffEndtime,
dbo.timeOff.timeOffStatusId, ...
Go to the complete details ...