what is wrong in this simple procedure ?

ahmed fahd

DELETE FROM Attendance_Table
WHERE
(Day_Dat = getdate())

it gives me error of

Procedure procedure_name has no parameters and arguments were supplied.

5 Replies

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

Akkiraju Ivaturi13y ago
Accepted answer
Can you provide complete stored procedure? I can see only a query to delete records but the error speaks about the procedure.

By the way the error says that you have created a stored procedure called procedure_name which does not accept any parameters. But you were trying to pass parameters to the stored procedure which it cannot handle and so giving the error.
0
ahmed fahd13y ago
i solved it by saying command.parameters.clear () this made the command delete any parameter it hold from some where :) thanks juys
0
Jignesh Trivedi13y ago
hi,

i have try following code C# with SQL server. it working fine for me.

SqlConnection con = new SqlConnection("Data Source=.\SQLExpress;user id=sa;password=tiger1!;Initial Catalog=TempDBforTest;MultipleActiveResultSets=True");
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Attendance_Table_Delete";
command.Connection = con;
con.Open();
int res = command.ExecuteNonQuery();
con.Close();

CREATE PROCEDURE dbo.Attendance_Table_Delete
as
DELETE FROM Attendance_Table WHERE (Day_Dat =convert(date, GETDATE()))
hope this will help you.
0
ahmed fahd13y ago
this is the procedure ALTER PROCEDURE dbo.Attendance_Table_Delete as DELETE FROM Attendance_Table WHERE (Day_Dat =getdate()) and this is the method Function delete_al7door(ByVal b As clsal7door) As Boolean command.CommandType = CommandType.StoredProcedure command.CommandText = "Attendance_Table_Delete" command.Connection = con con.Close() con.Open() command.ExecuteNonQuery() con.Close() Return True End Function
0
Jignesh Trivedi13y ago
hi,

I think this error is due to mismatch between Parameter of SP and Pass parameter to call SP from Code.
Also Check direction of SP parameter. whether parameter is define input/output ect.

yes agree with Akkiraju,
please share you SP .
0