2
Reply

Procedure or function getpersonal has too many arguments specified.

kishor choure

kishor choure

Aug 26 2012 12:17 PM
2.4k
This is my Procedure:

create procedure getpersonal  @rid bigint
as
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.

Answers (2)