C# stored procedure error db parameter expected

Question

I have a stored procedure which inserts data from a web form to a table in my database.

During the execution an error popped up such as "Procedure or function 'getpopteam' expects parameter '@tname', which was not supplied", but when I entered into the my table in the db, all the values inserted in the web form is present in the db.

I executed it again and above mentioned error popped up again and all the values are successfully inserted into the database. I don't know what the problem is.

I'm using Visual Studio 2012 and SQL Server 2008

datacon();

con.Open();

SqlCommand cmd = new SqlCommand("getpopteam", con);

cmd.Parameters.Add(new SqlParameter("tname", txtteamname.Text));
cmd.Parameters.Add(new SqlParameter("usermail", txtemails.Text));
cmd.Parameters.Add(new SqlParameter("userpwd", txtpasswords.Text));
cmd.Parameters.Add(new SqlParameter("usercountry", countrydd.SelectedValue));
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();

con.Close();

Unless you can provide some details we can't help. All you have said is "my code has an error". I assume you have a procedure or function called "getpopteam" and it has some parameters. I suspect you are not passing it a value for @tname. — Sean Lange
– Sean Lange, Commented Aug 13, 2014 at 14:24
It wants a parameter called @tname, not one called tname. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Aug 13, 2014 at 14:36

amadbear · Accepted Answer · 2014-08-13 14:52:46Z

1

Instead of typing string value of "tname", try prepending with the "@" symbol instead like this...

cmd.Parameters.Add(new SqlParameter("@tname", txtteamname.Text))

Hope this helps.

answered Aug 13, 2014 at 14:52

amadbear

966 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# stored procedure error db parameter expected

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related