update the record into database using store procedure

Question

Procedure or function 'Updatedata' expects parameter '@Id', which was not supplied

Packiaraj Santhiyagu · Answer

Hi Kashif, I think you forgot to pass @Id parameter. You can change your parameter as optional. Your procedure handle unpassed parameters also. How to make parameters as optional in storedprocedures? I will take one scenario to explain to avoid this type of error in Storedprocedure. I have one table named employee to maintain employee detail. I write only one procedure to do CURD operations. Scenarios: In insert, the record do not need to pass Identity(Auto) value. In update, do not need to pass all values of table, only pass modified values. In select, only primary key is enough to get particular value. Find below Storeprocedure to achieve this scenario. create proc usp_employee ( @flag char (5)= null , @id int = null , @empname varchar = null ) as begin if(@flag= 'in' ) begin insert into your_tableanme(s_Name) values (@empname) end if(@flag== 'sel' ) begin select * from your_tablename where id=@id; end end

Yogesh Ghorpade · Answer

Please Check Your Store Procedure Parameter And Your Methods Parameter Or Share Your SP Code And Method

Rafnas T P · Answer

hi, I think you have forgot to pass parameter @id value to procedure Updatedata, thats why you are getting this error

update the record into database using store procedure

Answers (3)