过程或函数'sp_files'需要参数'@filename'，这是未提供的。 [英] Procedure or function 'sp_files' expects parameter '@filename', which was not supplied.

问题描述

SqlDataReader reader = cmd.ExecuteReader（）;

SqlDataReader reader = cmd.ExecuteReader();

ALTER procedure [dbo].[sp_files] @filename nvarchar(50),@invID int,@filepath nvarchar(max),
@filesize decimal,@fileCreateddt datetime
as
begin
insert into [dbo].[tblFiles](fileName,invID,fileSize,filePath,fileCreatedDt) values(@filename,@invID,@filesize,@filepath,@fileCreateddt)
end

我得到了以上提到了errror ....请帮我解决

I am getting the above mentioned errror....Pls help me out

推荐答案

SP中有一些需要通过代码传递的参数。

这些是参数 -

There are some parameters in the SP that need to be passed via the code.
These are the parameters -

@filename nvarchar(50),
@invID int,
@filepath nvarchar(max),
@filesize decimal,
@fileCreateddt datetime

了解更多关于在SP中传递参数的过程 -

C＃存储过程带参数 [ ^ ]

在ADO.Net中使用参数化的SP [ ^ ]

您需要将参数传递给您的程序



string filename =;

cmd.Parameters.AddWithValue（@ filename，filename ）;

。

。

。

类似于您在程序中使用的所有参数

You need to pass parameters to you procedure

string filename = "";
cmd.Parameters.AddWithValue("@filename", filename);
.
.
.
Similarly for all the parameters you are using in your procedure

ALTER procedure [dbo].[sp_files] 
@filename nvarchar(50),
@invID int,
@filepath nvarchar(max),
@filesize decimal,
@fileCreateddt datetime
as
begin
insert into [dbo].[tblFiles](fileName,invID,fileSize,filePath,fileCreatedDt) values(@filename,@invID,@filesize,@filepath,@fileCreateddt)
end

和C＃代码： -

and C# code:-

private void button1_Click(object sender, EventArgs e) {
  using (SqlConnection con = new SqlConnection(dc.Con)) {
    using (SqlCommand cmd = new SqlCommand("storedprocedure", con)) {
      cmd.CommandType = CommandType.StoredProcedure;

      cmd.Parameters.Add("@filename", SqlDbType.VarChar).Value = txtFirstName.Text;
      cmd.Parameters.Add("@invID", SqlDbType.VarChar).Value = txtLastName.Text;

      con.Open();
      cmd.ExecuteNonQuery();
    }
  }
}

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