过程或函数期望不提供的参数' [英] Procedure or function expects parameter ' which is not supplied

问题描述

页面加载事件调用像loaddata（）这样的一个方法我写这段代码使用（SqlConnection Sqlcon = new SqlConnection（strCon））
{
using（SqlCommand cmd = new）

  SqlCommand（））
 {
 Sqlcon.Open（）; 
 cmd.Connection = Sqlcon; 
 
 cmd.CommandType = CommandType.StoredProcedure; 
 cmd.CommandText =SP_Marketing; 
 //cmd.Parameters.Add(new SqlParameter（@ Sno，（object）?? null.Value））; 
 cmd.Parameters.Add（new SqlParameter（@ pvchAction，SqlDbType.VarChar，50））; 
 cmd.Parameters [@ pvchAction]。Value =select; 
 cmd.Parameters.Add（@ pIntErrDescOut，SqlDbType.Int）.Direction = ParameterDirection.Output; 
 
 SqlAda = new SqlDataAdapter（cmd）; 
 ds = new DataSet（）; 
 SqlAda.Fill（ds）; 
 GridViewSample.DataSource = ds; 
 GridViewSample.DataBind（）; 
 
 
 $ / code> 

在sqlada中找到存储过程记录过程或函数期望不提供参数@dateemailed，而不是提供



  ALTER PROCEDURE SP_Marketing 
（
 @ Sno int = 0，
 @DateEmailed datetime，
 @DateResponded datetime，
 @EmailRep varchar（100）= null，
 @Type varchar（100）= null，
 @Country varchar（100）= null，
 @State varchar（100）= null，
 @NameoftheCompany varchar（100）= null，
 @website varchar（100）= null，
 @FirstName varchar（100）= null，
 @LastName varchar（100）= null，
 @Title varchar（100）= null，
 @Email varchar（100）= null ，
 @Telephone varchar（100）= null，
 @Capabilities varchar（100）= null，
 @Focus varchar（100）= null，
 @pvchCreatedBy varchar（100） = null，
 @pvchActio varchar（50）= null，
 @pIntErrDescOut int输出
）
 AS 
 BEGIN 
 
 if（@ pvchAction ='select'）
 begin 
 SELECT sno，Dateemailed，daterespond，emailrep，[type]，country，[state]，nameofthecompany，website，Firstname，Lastname，Title，email，telephone，
 capabilities，Focus FROM Emailmarketing WHERE active = 1 
 end 
 
 $ b $ else if（@ pvchAction ='insert'）
 begin 
 INSERT INTO EmailMarketing（DateEmailed，DateResponded，EmailRep， [类型]，
国家，[州]，公司名称，网站，名，姓，标题，电子邮件，电话，功能，焦点，Createdby，CreatedDt，活动）VALUES（@ DateEmailed，@ DateResponded，@ EmailRep，@类型，
 @ Country，@ State，@ NameoftheCompany，@ website，@ FirstName，@ LastName，@ Title，@ Email，@ Telephone，@ Capabilities，@ Focus，@ pvchCreatedBy，GETDATE（），1）; 
 
 end 
 else if（@ pvchAction ='update'）
 begin 
 UPDATE EmailMarketing SET DateEmailed = @ DateEmailed，DateResponded = @ DateResponded，EmailRep = @ EmailRep， [类型] = @类型，国家= @国家，[国家] = @国家，NameoftheCompany = @ NameoftheCompany，网站= @网站，名字= @名字，姓氏= @姓氏，标题= @名称，电子邮件= @电子邮件，电话= @ Telephone，Capabilities = @ Capabilities，Focus = @ Focus，updatedby = @ pvchCreatedBy，UpdatedDt = GETDATE（）
 WHERE Sno = @ Sno; 
 end 
 else if（@ pvchAction ='delete'）
 begin 
 UPDATE EmailMarketing SET Active = @ pvchAction WHERE Sno = @ Sno; 
 end 
 
（@@ ERROR<> 0）
 BEGIN 
 SET @pIntErrDescOut = 1 
 END 
 ELSE 
 BEGIN 
 SET @pIntErrDescOut = 0 
 END 
 
 
 
 END 
  




解决方案

以下参数在您的存储过程中没有默认值：

  @DateEmailed datetime，
 @DateResponded datetime，
  



<所以你总是需要在代码中提供这些值：



  cmd.Parameters.Add（new SqlParameter（@ DateEmailed ，SqlDbType.DateTime））; 
 cmd.Parameters [@ DateEmailed]。Value = DateTime.Now; //在这里提供你的值
 cmd.Parameters.Add（new SqlParameter（@ DateResponded，SqlDbType.DateTime））; 
 cmd.Parameters [@ DateResponded]。Value = DateTime.Now; //在这里提供你的价值
  




hello friends i face one issue for load the data to grid view.

the page load event call the one method like loaddata() inside i write the code this

  using (SqlConnection Sqlcon = new SqlConnection(strCon))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                Sqlcon.Open();
                cmd.Connection = Sqlcon;

                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "SP_Marketing";
                //cmd.Parameters.Add(new SqlParameter("@Sno", (object) ?? null.Value));
                cmd.Parameters.Add(new SqlParameter("@pvchAction", SqlDbType.VarChar,50));
                cmd.Parameters["@pvchAction"].Value = "select";
                cmd.Parameters.Add("@pIntErrDescOut", SqlDbType.Int).Direction = ParameterDirection.Output;

                SqlAda = new SqlDataAdapter(cmd);
                ds = new DataSet();
                SqlAda.Fill(ds);
                GridViewSample.DataSource = ds;
                GridViewSample.DataBind();
            }
        }

the find the store procedure records in sqlada caught error like"Procedure or function expects parameter @dateemailed which is not supplied"

ALTER PROCEDURE SP_Marketing          
(            
 @Sno   int  =0,            
 @DateEmailed datetime,            
 @DateResponded datetime,            
 @EmailRep  varchar(100)=null,    
 @Type   varchar(100)=null,    
 @Country  varchar(100)=null,    
 @State  varchar(100)=null,    
 @NameoftheCompany varchar(100)=null,    
 @website  varchar(100)=null,    
 @FirstName  varchar(100)=null,    
 @LastName  varchar(100)=null,    
 @Title   varchar(100)=null,    
 @Email   varchar(100)=null,    
 @Telephone  varchar(100)=null,    
 @Capabilities varchar(100)=null,    
 @Focus   varchar(100)=null,    
 @pvchCreatedBy  varchar(100)=null,            
 @pvchAction   varchar(50)=null,            
 @pIntErrDescOut  int output    
)            
AS            
 BEGIN            

   if(@pvchAction='select')         
    begin    
     SELECT sno,Dateemailed,dateresponded,emailrep,[type],country,[state],     , nameofthecompany,website,Firstname,Lastname,Title,email,telephone,
capabilities,  Focus FROM Emailmarketing  WHERE active=1  
  end


else if(@pvchAction='insert')    
  begin    
  INSERT INTO EmailMarketing(DateEmailed,DateResponded,EmailRep,[Type],    
  Country,[State],NameoftheCompany,website,FirstName,LastName,Title,Email,Telephone,Capabilities,Focus,Createdby,CreatedDt,Active)VALUES(@DateEmailed,@DateResponded,@EmailRep,@Type,    
  @Country,@State,@NameoftheCompany,@website,@FirstName,@LastName,@Title,@Email,@Telephone,@Capabilities,@Focus,@pvchCreatedBy,GETDATE(),1);    

  end    
  else if(@pvchAction='update')    
  begin    
  UPDATE EmailMarketing SET DateEmailed=@DateEmailed,DateResponded=@DateResponded,EmailRep=@EmailRep,[Type]=@Type,Country=@Country,[State]=@State,NameoftheCompany=@NameoftheCompany,website=@website,FirstName=@FirstName,LastName=@LastName,Title=@Title,Email=@Email,Telephone=@Telephone,Capabilities=@Capabilities,Focus=@Focus,Updatedby=@pvchCreatedBy,UpdatedDt=GETDATE()    
  WHERE Sno=@Sno;    
  end    
  else if(@pvchAction='delete')    
  begin    
  UPDATE   EmailMarketing SET Active=@pvchAction WHERE Sno=@Sno;    
  end    

    IF (@@ERROR <> 0)             
   BEGIN             
  SET @pIntErrDescOut = 1            
   END            
  ELSE            
   BEGIN            
  SET @pIntErrDescOut = 0            
   END     



END

解决方案

The following parameters don't have default values in your stored proc:

@DateEmailed datetime,            
@DateResponded datetime, 

So you always need to provide those values in the code:

cmd.Parameters.Add(new SqlParameter("@DateEmailed", SqlDbType.DateTime));
cmd.Parameters["@DateEmailed"].Value = DateTime.Now; // Provide your value here
cmd.Parameters.Add(new SqlParameter("@DateResponded", SqlDbType.DateTime));
cmd.Parameters["@DateResponded"].Value = DateTime.Now; // Provide your value here

这篇关于过程或函数期望不提供的参数'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！