Procedure or function has too many arguments specified

How to resolve the error above. Your help will be highly appreciated.

My HTML:

class="form-group">
class="input-group">
for="Item2.DocumentName" class="text-danger input-group-addon">CV
for="Item2.DocumentName" type="file" class="form-control" placeholder="Attach CV" name="DocumentName">

conn.Open();
SqlCommand cmd2 = new SqlCommand();
cmd2.CommandType = CommandType.StoredProcedure;
//Save Attachment Data for CV
document.DocURL = "~/Documents/";
cmd2.Parameters.AddWithValue("@UserID", (document.UserID));
cmd2.Parameters.AddWithValue("@DocumentName", (document.DocumentName));
cmd2.Parameters.AddWithValue("@Description", "CV");
cmd2.Parameters.AddWithValue("@DocURL", document.DocURL + document.DocumentName);
//cmd2.ExecuteNonQuery();
//Second Attachment
if(document.DocumentName != document.DocumentNameTwo)
{
document.DocURL = "~/Documents/";
document.DocumentName = document.DocumentNameTwo;
cmd2.Parameters["@UserID"].Value = document.UserID;
cmd2.Parameters["@DocumentName"].Value = document.DocumentName;
cmd2.Parameters["@Description"].Value = "ID Copy";
cmd2.Parameters["@DocURL"].Value = document.DocURL + document.DocumentName;
}
if (document.DocumentName != document.DocumentNameThree) {
document.DocURL = "~/Documents/";
document.DocumentName = document.DocumentNameThree;
cmd2.Parameters["@UserID"].Value = document.UserID;
cmd2.Parameters["@DocumentName"].Value = document.DocumentName;
cmd2.Parameters["@Description"].Value = "ID Copy";
cmd2.Parameters["@DocURL"].Value = document.DocURL + document.DocumentName;
cmd2.ExecuteNonQuery();
conn.Close();
}
else { return "Files Not Saved"; }

It works, Thanks alot bra

I'm not following. Can you please elaborate more on the suggestion

conn.Open();

cmd2.CommandType = CommandType.StoredProcedure;

//Save Attachment Data for CV

document.DocURL = "~/Documents/";

cmd2.Parameters.AddWithValue("@UserID", (document.UserID));

cmd2.Parameters.AddWithValue("@DocumentName", (document.DocumentName));

cmd2.Parameters.AddWithValue("@Description", "CV");

cmd2.Parameters.AddWithValue("@DocURL", document.DocURL + document.DocumentName);

for second attachement if condition become true again your add same parameter

you should add parameter only time if you want to change parameter value

cmd2.Parameters[0].value="somethin" ; //0 for @userid

4 Replies

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

Gowtham Ramar7y ago
Accepted answer
1. conn.Open();
2. SqlCommand cmd2 = new SqlCommand();
3. cmd2.CommandType = CommandType.StoredProcedure;
4. //Save Attachment Data for CV
5. document.DocURL = "~/Documents/";
6. cmd2.Parameters.AddWithValue("@UserID", (document.UserID));
7. cmd2.Parameters.AddWithValue("@DocumentName", (document.DocumentName));
8. cmd2.Parameters.AddWithValue("@Description", "CV");
9. cmd2.Parameters.AddWithValue("@DocURL", document.DocURL + document.DocumentName);
10. //cmd2.ExecuteNonQuery();
11. //Second Attachment
12. if(document.DocumentName != document.DocumentNameTwo)
13. {
14. document.DocURL = "~/Documents/";
15. document.DocumentName = document.DocumentNameTwo;
16. cmd2.Parameters["@UserID"].Value = document.UserID;
17. cmd2.Parameters["@DocumentName"].Value = document.DocumentName;
18. cmd2.Parameters["@Description"].Value = "ID Copy";
19. cmd2.Parameters["@DocURL"].Value = document.DocURL + document.DocumentName;
20. }
21. if (document.DocumentName != document.DocumentNameThree) {
22. document.DocURL = "~/Documents/";
23. document.DocumentName = document.DocumentNameThree;
24. cmd2.Parameters["@UserID"].Value = document.UserID;
25. cmd2.Parameters["@DocumentName"].Value = document.DocumentName;
26. cmd2.Parameters["@Description"].Value = "ID Copy";
27. cmd2.Parameters["@DocURL"].Value = document.DocURL + document.DocumentName;
28. cmd2.ExecuteNonQuery();
29. conn.Close();
30. }
31. else { return "Files Not Saved"; }
Thamsanqa Ngcongwane7y ago
It works, Thanks alot bra
Thamsanqa Ngcongwane7y ago
I'm not following. Can you please elaborate more on the suggestion
Gowtham Ramar7y ago
conn.Open();
cmd2.CommandType = CommandType.StoredProcedure;
//Save Attachment Data for CV
document.DocURL = "~/Documents/";
cmd2.Parameters.AddWithValue("@UserID", (document.UserID));
cmd2.Parameters.AddWithValue("@DocumentName", (document.DocumentName));
cmd2.Parameters.AddWithValue("@Description", "CV");
cmd2.Parameters.AddWithValue("@DocURL", document.DocURL + document.DocumentName);

for second attachement if condition become true again your add same parameter

you should add parameter only time if you want to change parameter value
cmd2.Parameters[0].value="somethin" ; //0 for @userid