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;
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..