为过程或函数 PRO_AddProduct 指定了过多的参数
存储过程:set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[PRO_AddProduct]
@S_sort int,
@S_sort2 int,
@S_title nvarchar(50),
@S_title_color nvarchar(50),
@S_price money,
@S_space nvarchar(50),
@S_Pic nvarchar(50),
@S_link nvarchar(200),
@S_content ntext,
@S_tu int,
@S_addtime datetimeAS
Begin
Insert into S_product (
S_sort,
S_sort2,
S_title,
S_title_color,
S_price,
S_space,
S_pic,
S_link,
S_content,
S_tu,
S_addtime) 
values (
@S_sort,
@S_sort2,
@S_title,
@S_title_color,
@S_price,
@S_space,
@S_Pic,
@S_link,
@S_content,
@S_tu,
@s_addtime)
End
调用代码:
        //添加产品
        /// <summary>
        /// 添加产品数据
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public int AddProduct(Model.S_product getproduct,string sql)
        {        return (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, sql,  new SqlParameter("@S_title",getproduct.Sttile),
        new SqlParameter("@S_title_color",getproduct.Sttile),
        new SqlParameter("@S_sort",getproduct.Ssort),
        new SqlParameter("@S_sort2",getproduct.Ssort2),
        new SqlParameter("@S_price",getproduct.Sprice),
        new SqlParameter("@S_space",getproduct.Sspace),
        new SqlParameter("@S_pic",getproduct.Spic),
        new SqlParameter("@S_link",getproduct.Slink),
        new SqlParameter("@S_content",getproduct.Scontent),
        new SqlParameter("@S_tu",getproduct.Stu),
        new SqlParameter("@S_addtime",getproduct.Saddtime)
            );
        }