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.