'Procedure or function expects paramete

Ritu

6y813.NET

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy6y ago
@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
0
Ritu6y ago
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
0
Sreekanth Reddy6y ago
@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.
+1