为过程或函数 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)
);
}
存储过程: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)
);
}
解决方案 »
- 从文本框向access中插入数值问题
- MDI窗体初始化时加载子窗体问题.
- web.config 应用程序设置的文件
- 关于System.NullReferenceException: 未将对象引用设置到对象的实例的问题
- treeview问题
- 为什么程序始终走不到else后面的Response.Redirect~~~郁闷
- 哪位大哥帮我转换一下:VB->C#
- 有关asp.net ajax的问题,高手请进!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- “Request.Form”获取表单中的值
- 怎么把这个编辑器从别人网页上拿下来?
- 如何让table输出成word的时候,让他页面设置默认是横向的,打印也是横向?200分!
- 如何将DataFormatString="{0:C}"显示成¥?
少了这个参数没传……
原来顺序也很重要啊
,谢谢各位了