'Procedure or function expects paramete

Question

i want to store the values in database from asp.net website i have 2 table 1. Company which have c_id and c_email columns 2. CompanyUserLogin which have c_id, c_email, password, security_ques, secure_pass columns i want generate password or c_id which is stored in second table along with c_id and c_email from first table. now i have create procedure in which insert query is created. but when application is run it throws exception "System.Exception: 'Procedure or function 'InsertPassCustomer' expects parameter '@password', which was not supplied.'" i have attached file please check.

Sreekanth Reddy · Answer

@Ritu Gupta Firstly Please provide your procedure. So that it would be easy to us to find the solution to your problem. Any how for this exception the problem is : Pass another parameter @password While calling the stored procedure. Ex : your procedure name is "LoginProcedure" having two parameters "@userid" and "@password" Case 1)While calling : EXEC LoginProcedure 'username','password' Executes without exception Case 2)If you give : EXEC LoginProcedure 'username' Executes with exception as likely provieds which you got( "System.Exception: 'Procedure or function ' LoginProcedure ' expects parameter '@password', which was not supplied.'" ). Mark as answer, If it helps. Thank you.

Sreekanth Reddy · Answer

@Ritu Gupta One solution can be as like default parameters setting to nulls as like below : USE [DATABASE.MDF] GO /****** Object: StoredProcedure [dbo].[InsertPassCustomer] Script Date: 17-03-2020 14:30:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[InsertPassCustomer] @c_id varchar(100) = null , @c_email varchar(max) = null , @password VARCHAR(100) = null , @secureq varchar(100) = null , @securep varchar(100) = null AS BEGIN INSERT INTO CompanyUserLogin ( [c_id], [c_email], [password], [secure_ques], [secure_pass] ) values(@c_id, @c_email, @password, @secureq, @securep) END

Ritu · Answer

i have attached all files USE [DATABASE.MDF] GO /****** Object: StoredProcedure [dbo].[InsertPassCustomer] Script Date: 17-03-2020 14:30:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[InsertPassCustomer] @c_id varchar(100), @c_email varchar(max), @password VARCHAR(100), @secureq varchar(100), @securep varchar(100) AS BEGIN INSERT INTO CompanyUserLogin ( [c_id], [c_email], [password], [secure_ques], [secure_pass] ) values(@c_id, @c_email, @password, @secureq, @securep) END