Posts: 21
Name: Hesham
Location: Ismailia , EGYPT
|
i try to find out the problem by my self but i cant i hope somebody help me
here my storedprocedure
ALTER PROCEDURE GetEmployee
@EmployeeID Int
AS
SELECT FirstName,LastName,TitleOfCourtesy
FROM Employees WHERE EmployeeID = @EmployeeID
RETURN
am try to excute it and its gives me this message
Running [dbo].[GetEmployee] ( @EmployeeID = <DEFAULT> ).
Procedure or Function 'GetEmployee' expects parameter '@EmployeeID', which was not supplied.
No rows affected.
(0 row(s) returned)
@RETURN_VALUE =
Finished running [dbo].[GetEmployee].
am try to bind a DetailsView by ObjectDatasource from Class incluse the GetEmployee() Method and this method gives me error on the line i declared the variable that hold the data from the stored procedure thats all if you need more explain tell me ok thanks anyway
|