TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
kishor choure
NA
87
46.1k
Procedure or function getpersonal has too many arguments specified.
Aug 26 2012 12:17 PM
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.
Reply
Answers (
2
)
Doubt
read text from image using .net