A solution for "Procedure or function has too many arguments specified" when you using SqlDataSource with Stored Procedure

Last post 10-08-2009 2:55 PM by Longrider. 15 replies.

Sort Posts:

  • Re: A solution for "Procedure or function has too many arguments specified" when you using SqlDataSource with Stored Procedure

    10-08-2009, 2:55 PM
    • Member
      2 point Member
    • Longrider
    • Member since 10-08-2009, 2:49 PM
    • Posts 1

    It appears that the SQLDataSource (at least in the case of the Delete command and I assume the Update command as well) will include in its auto-generated parameters list, all of the columns which comprise the primary key value for the table -- regardless of whether they are defined in or needed by your SP. Make sure that your SP contains parameters for all of the primary key fields in your database table.

Page 2 of 2 (16 items) < Previous 1 2