存储过程错误，因为过程或函数'insertvalue'需要参数'@ename'，这是未提供的。 [英] Store Procedure error as Procedure or function 'insertvalue' expects parameter '@ename', which was not supplied.

问题描述

嗨frnds我在存储过程中插入值但是经常出现错误

Hi frnds am inserting values in stored procedure but often am getting error as

Procedure or function 'insertvalue' expects parameter '@ename', which was not supplied.

我的表格字段是

My Table Fields are

eid	int	Unchecked  //Primary Key is Ser
ename	varchar(50)	Checked
gender	varchar(50)	Checked
dept	varchar(50)	Checked
adress	varchar(50)	Checked
age	varchar(50)	Checked
uname	varchar(50)	Unchecked
pswd	varchar(50)	Checked
cntctno	varchar(50)	Checked
		Unchecked

我存储的程序代码

My stored Procedure Code

CREATE PROCEDURE dbo.insertvalue
@eid int output,
@ename varchar(50),
@gender varchar(50),
@dept varchar(50),
@adress  varchar(50),
@age  varchar(50),
@uname  varchar(50),
@pswd  varchar(50),
@cntctno  varchar(50),
@IdentitY int OUTPUT
AS
BEGIN
Insert sample (ename,gender,dept,adress,age,uname,pswd,cntctno)
Values
(@ename,@gender,@dept,@adress,@age,@uname,@pswd,@cntctno)
END
SELECT @eid  = @@IDENTITY;

我的C＃代码为

My C# Code as

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conect"].ConnectionString);

        con.Open();
        SqlCommand cmd = new SqlCommand("insertvalue", con);
        cmd.CommandType = CommandType.StoredProcedure;
        try
        {
            cmd.Parameters.Add("@empname", SqlDbType.VarChar).Value= objBELUserDetails.empname;
            cmd.Parameters.AddWithValue("@genderd", SqlDbType.VarChar).Value=objBELUserDetails.genderd;
            cmd.Parameters.AddWithValue("@deptmnt", SqlDbType.VarChar).Value = objBELUserDetails.deptmnt;
            cmd.Parameters.AddWithValue("@adressdetail", SqlDbType.VarChar).Value = objBELUserDetails.adressdetail;
            cmd.Parameters.AddWithValue("@ages", SqlDbType.VarChar).Value = objBELUserDetails.ages;
            cmd.Parameters.AddWithValue("@usrname", SqlDbType.VarChar).Value = objBELUserDetails.usrname;
            cmd.Parameters.AddWithValue("@paswd", SqlDbType.VarChar).Value = objBELUserDetails.paswd;
            cmd.Parameters.AddWithValue("@contctno", SqlDbType.VarChar).Value = objBELUserDetails.contctno;
            cmd.Parameters.Add("@ERROR", SqlDbType.Char, 500);
            cmd.ExecuteNonQuery();
            string strMessage = (string)cmd.Parameters["@ERROR"].Value;
            con.Close();
            return strMessage;
        }
        catch (Exception error)
        {
            throw error;
        }
        finally
        {
            cmd.Dispose();
            con.Close();
        }

请帮助我更新店铺程序



谢谢..

pls Help me am newer to Store Procedure

Thank You..

推荐答案

尝试更改参数名称：

Try changing the parameter name:

cmd.Parameters.Add("@empname", SqlDbType.VarChar).Value= objBELUserDetails.empname;

要

To

cmd.Parameters.Add("@ename", SqlDbType.VarChar).Value= objBELUserDetails.empname;

匹配SP ......

To match the SP...

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