Procedure or function getpersonal has too many arguments specified.

kishor choure

This is my Procedure:

create procedure getpersonal @rid bigint

begin

if((select count(1) from personaltbl where r_id=@rid)>0 and (select count(1) from feetbl where r_id=@rid)>0)

select p.s_first,p.s_Middle,p.s_last,c.c_name,o.o_cast from personaltbl p inner join coursetbl c on p.r_id= c.r_id inner join otherdttbl o on p.r_id=o.r_id where p.r_id=@rid

end

Following is my code:

public ArrayList getpersonaldt(Int64 rid)

{

ArrayList al = new ArrayList();

try

{

string str = "getpersonal";

scmd.CommandText = str;

scmd.CommandType = CommandType.StoredProcedure;

scmd.Connection = scon;

SqlParameter r_id = new SqlParameter("@rid", rid);

scmd.Parameter.Add(r_id);

if (scon.State == ConnectionState.Closed)

scon.Open();

SqlDataReader ssdr = scmd.ExecuteReader();

for (int i = 0; ssdr.Read(); i++)

{

al[i] = ssdr[i];

}

if (scon.State == ConnectionState.Open)

scon.Close();

}

catch (Exception ex)

{

MessageBox.Show("DataBase Error : " + ex.Message, "Database", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

return al;
}
This code generates error as
Procedure or function getpersonal has too many arguments specified.

2 Replies

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

Vulpes14y ago
Accepted answer
I notice that your SqlCommand object, scmd, is defined outside the getPersonaldt() method.

If you're calling this method more than once, then you'll be adding a further parameter each time which may be causing the error.

If that's the case, the solution would be to either create a new SqlCommand object on each call or, if you don't want to do that for some reason, then clear the Parameters collection before you add the new one:

string str = "getpersonal";
scmd.CommandText = str;
scmd.CommandType = CommandType.StoredProcedure;
scmd.Connection = scon;
scmd.Parameters.Clear();
SqlParameter r_id = new SqlParameter("@rid", rid);
scmd.Parameters.Add(r_id);
0
kishor choure14y ago
Absolutely right answer sir you are genius thank you sir.
0