I have a code that want to call 2 stored procedures with a sqlcommand; I'm used :
string sqlcmds = "EXEC ShowDetailsSp;EXEC ShowBannersSp;";
cmd = new SqlCommand(sqlcmds, sqlcon);
each stord procedure has a parameter :
@Number is for ShowDetailsSp and @Code is for ShowBannersSp, but when I run my page give error :
Procedure or function 'ShowDetailsSp' expects parameter '@Number', which was not supplied.
View Complete Post