功能或程序也可以指定参数？ [英] funcion or procedure has too may arguments specified?

问题描述

 dao.ExecCommand（dao.CreateCommand（DBProcedures.WorkOrder.USP_UPDATE_BUSINESS_EMAILADDRESS，
  new  CSqlDbParameterCollection 
 { 
 {  BusinessId，business.BusinessID}，
 {  EmailAddress，business.EmailAddress}，
 {   ModifiedBy，business.WorkOrderDetails.FilerID}，
 {  ModifiedDate，DateTime.Now}，
 {  CreatedBy，business.WorkOrderDetails.FilerID}，
 {  CreatedDate,DateTime.Now} 
 
}））; 

和程序是

 创建 程序 [CORP]。[USP_UPDATE_BUSINESS_EMAILADDRESS] 
  @ BusinessId  int =  null ，
  @ EmailAddress   varchar （ 50 ）=  null  
 作为 
 开始 
 更新 Corp.Business  set  EmailAddress =  @ EmailAddress  其中 BusinessId =  @ BusinessId  
 结束 

解决方案

嗯。

查看你的代码？

你的SP定义有两个参数：

  @ BusinessId  int =  null ，
  @ EmailAddress   varchar （ 50 ）=  null  

但是你试图传递它六：

 {  BusinessId，business.BusinessID}，
 {  EmailAddress，business.EmailAddress}，
 {  ModifiedBy，business .WorkOrderDetails.FilerID}，
 {  ModifiedDate，DateTime.Now}，
 {  CreatedBy，business.WorkOrderDetails .FilerID}，
 {  CreatedDate，DateTime.Now} 
 

我怀疑你拨错了SP ...

dao.ExecCommand(dao.CreateCommand(DBProcedures.WorkOrder.USP_UPDATE_BUSINESS_EMAILADDRESS,
                  new CSqlDbParameterCollection
                   {
                       {"BusinessId",business.BusinessID},
                       {"EmailAddress",business.EmailAddress},
                       {"ModifiedBy",business.WorkOrderDetails.FilerID},
                       {"ModifiedDate",DateTime.Now},
                       {"CreatedBy",business.WorkOrderDetails.FilerID},
                       {"CreatedDate",DateTime.Now}

                   }));

and procedure is

Create Procedure [CORP].[USP_UPDATE_BUSINESS_EMAILADDRESS]
@BusinessId int= null,
@EmailAddress varchar(50)= null
As
Begin
Update Corp.Business set EmailAddress = @EmailAddress Where BusinessId = @BusinessId
End

解决方案

Um.
Look at your code?
Your SP definition has two parameters:

@BusinessId int= null,
@EmailAddress varchar(50)= null

But you are trying to pass it six:

{"BusinessId",business.BusinessID},
{"EmailAddress",business.EmailAddress},
{"ModifiedBy",business.WorkOrderDetails.FilerID},
{"ModifiedDate",DateTime.Now},
{"CreatedBy",business.WorkOrderDetails.FilerID},
{"CreatedDate",DateTime.Now}

I suspect you are calling the wrong SP...

这篇关于功能或程序也可以指定参数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！