c# - Must declare the scalar variable "@userid" -

c# - Must declare the scalar variable "@userid" -

i getting:

must declare scalar variable "@userid".

on

if (httpcontext.current.items["albumid"] != null) { page.databind(); ddlalbum.items.findbyvalue(httpcontext.current.items["albumid"].tostring()).selected = true; }

i believe has with:

<asp:sqldatasource id="sqldatasource1" runat="server" connectionstring="<%$ connectionstrings:sliitcomdbconnectionstring %>" selectcommand="select [albumid], [albumname] [album] (userid=@userid) "> <selectparameters> <asp:querystringparameter defaultvalue="1" name="albumid" querystringfield="albumid" type="int32" /> </selectparameters> </asp:sqldatasource>

in sql query utilize @userid var, not declared!

select [albumid], [albumname] [album] (userid=@userid)

there great info problem http://msdn.microsoft.com/en-us/library/z72eefad%28v=vs.100%29.aspx

c# asp.net sql-server-2008