c# - why does my app complaints about a missing SQL parameter when i already supplied it? -
i have stored procedure takes 18 parameters , 1 parameter annoys me. have passed blob value of type varbinary(max) image. default pass null image. though i've passed parameter , when ran it, has given me following error
procedure or function 'uspsvupdtcourse' expects parameter '@pbookimage', not supplied.
but can see in first image have passed parameter
first image-c# code throw exception
second image- sql store procedure
is there away fix or need further details, stored procedure on going thing, not logic error , else.. : (
in stored procedure check input param looks
@pbookimage varbinary(max) = null
this accept null parameter in sp
Comments
Post a Comment