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.3k
sqldatabase error : procedure or function has too many parameters specified.
Aug 24 2012 2:47 PM
This is the store procedure I have written
alter procedure
getFees
@rid bigint,@rem bigint out
as
begin
Select @rem=(feetbl.f_total-Sum(feedetailstbl.fd_paid)) From FeeTbl inner join FeeDetailsTbl On feetbl.f_Id = feedetailstbl.f_Id and feetbl.r_id=@rid group
by feetbl.f_id,feetbl.f_total
--print @rem
end
This is my code in c# window
public Int64
getRemFees
(Int64 r_id)
{
Int64 fee = 0;
try
{
string str = "getRemFees";
scmd.CommandText = str;
scmd.CommandType = CommandType.StoredProcedure;
scmd.Connection = scon;
SqlParameter rid = new SqlParameter("@rid", r_id);
SqlParameter re = new SqlParameter("@rem", SqlDbType.BigInt);
scmd.Parameters.Add(rid);
scmd.Parameters.Add(re);
scmd.Parameters["@rem"].Direction = ParameterDirection.Output;
if (scon.State == ConnectionState.Closed)
scon.Open();
sdr= scmd.ExecuteReader();
if (sdr.Read())
fee = Convert.ToInt64(scmd.Parameters["@rem"].Value);
if (scon.State == ConnectionState.Open)
scon.Close();
}
catch (Exception ex)
{
MessageBox.Show("DataBase Error : " + ex.Message, "Database", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return fee;
}
When I run above program then It gives me Error :
procedure or function getFees has too many arguments specified.
Reply
Answers (
2
)
Here's my problem I'd like to run dos command in C #. net. DOS command lazicsasalaki.exe Fajl1.ekt ...
C# application use in Server2003 ?