How to remove this error:-Procedure or function 'SP_Duplications' expects parameter '@MA_DOB', which was not supplied.

Question

0.00/5 (No votes)

See more:

Hi,
I am using Stored procedure for display data in gridview. Using the where condition.
My stored procedure is:

ALTER procedure [dbo].[SP_Duplications]
(
@MA_DOB varchar(20)
)
as
begin
select ma.MA_App_Code as Emp_Code,ma.MA_Title,ma.MA_First_Name +' '+ ma.MA_Last_Name as Emp_Name, ma.MA_DOB as Date_Of_Birth, ma.MA_Joining_Date,ma.MA_Expiry_Date, mc.CM_Company_Name from master_applicant as ma
inner join master_company as mc on ma.MA_company_name=mc.CM_ID where MA_DOB=@MA_DOB

end
and my actual code is:

if (rbtncheck.Checked == true)
{
dt.OpenCon();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dt.SqlCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_Duplications";
cmd.ExecuteNonQuery();
GRD_Search_Employee.DataSource = cmd.ExecuteReader();
GRD_Search_Employee.DataBind();
dt.Dispose();

}
It is shows an exception.

Posted 31-Jan-15 1:20am

Member 11221185

Add a Solution

Comments

Member 11221185 31-Jan-15 7:23am

Please help me urgent

Zoltán Zörgő 31-Jan-15 7:25am

For you maybe...

2 solutions

Solution 1

Do you understand what you read? The SP has a parameter defined. You don't supply any parameter when you call it. So, what do you expect?

Use AddWithValue[^] for example.
Add

C#

cmd.Parameters.AddWithValue("@MA_DOB", "xyz");

before calling ExecuteNonQuery().

BTW: ExecuteNonQuery and ExecuteReader after another???

Posted 31-Jan-15 1:29am

Zoltán Zörgő

Updated 31-Jan-15 1:30am

v2

Comments

Member 11221185 31-Jan-15 8:04am

I just want to select data from database & bind it to gridview. so why i need this code:-
cmd.Parameters.AddWithValue("@MA_DOB", "xyz");

Zoltán Zörgő 31-Jan-15 8:27am

Beacuse the procedure is defined to require a parameter. Rewrite the procedure if you do1t need it.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arkadeep De · Accepted Answer · 2015-01-31T02:28:00

Solution 2

As Zoltan Zorgo provided the piece of code, it will resolve your error, but you want to get this value from db then do this

1. delete the @MA_DOB as input.
2. declare @MA_DOB as a normal variable

SQL

Declare @MA_DOB varchar(20)
select @MA_DOB = <column_name> from <table_name> where <search>

write these before your operation and do whatever you want with the value of @MA_DOB

Posted 31-Jan-15 2:28am

Arkadeep De

Updated 2-Feb-15 5:41am

v2

Comments

Member 11221185 1-Feb-15 23:45pm

Thanks My problem has been solved.Thanks For the help.

Arkadeep De 2-Feb-15 0:03am

If your problem has been solved then accept the solution and make this solve.