Procedure or Function 'InsertInfo' expects parameter '@s_name', which was not supplied.

Question

3.33/5 (3 votes)

See more:

I made this simple example of inserting data in DB using procedure but always getting this error

Procedure or Function 'InsertInfo' expects parameter '@s_name', which was not supplied.

Catch is that data is inserted in the table but error is shown!
HTML file:-

XML

<div>
    <asp:Label runat=server>Name</asp:Label>
    <asp:TextBox runat=server ID="txtName"></asp:TextBox><br />
    <asp:Label runat=server>Phone No.</asp:Label>
    <asp:TextBox runat=server ID="txtPhone"></asp:TextBox><br />
    <asp:Label runat=server>Degree in:</asp:Label>
    <asp:TextBox runat=server ID="txtDegree"></asp:TextBox><br />
    <asp:Button runat=server ID="btnSubmit" Text="Submit" onclick="btnSubmit_Click"/>
    <asp:Button runat=server ID="btnEdit" Text="Edit" />
    </div>

Code(.cs):-

publiv void insertData()
{
SqlConnection con = new SqlConnection(str_con);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "InsertInfo";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
string a = Convert.ToString(txtName.Text);
int b = Convert.ToInt32(txtPhone.Text);
string c = txtDegree.Text;
cmd.Parameters.Add("@s_name", SqlDbType.VarChar).Value = a;
cmd.Parameters.Add("@s_phone", SqlDbType.Int).Value = b;
cmd.Parameters.Add("@s_degree", SqlDbType.VarChar).Value = c;
//cmd.Parameters.AddWithValue("@s_name", a);&lt;------tried with these also
//cmd.Parameters.AddWithValue("@s_phone", b);
//cmd.Parameters.AddWithValue("@s_degree", c);
cmd.ExecuteNonQuery();&lt;-------error points here
con.Close();
}

Stored procedure:-

SQL

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[InsertInfo]
(
	@s_name varchar(300),
	@s_phone int,
	@s_degree varchar(300)
)
as
insert into info(s_name,s_phone,s_degree) values(@s_name,@s_phone,@s_degree)
exec InsertInfo

I beg to you, please help me find the error.

Posted 4-Dec-11 23:01pm

07navneet

Updated 12-Mar-21 23:21pm

Eduard Lu

v3

Add a Solution

Comments

sriman.ch 5-Dec-11 5:12am

Have you chekced the values of the corresponding textboxes are not null or empty? Try to debug the code once and see whether you are able to fill the parameters or not ?

07navneet 5-Dec-11 5:25am

The parameters are filled(I am not able to show to you the 'print screen' image at time of debugging) with their corr.values

[no name] 5-Dec-11 20:17pm

EDIT: added "pre" tag

4 solutions

Solution 7

Error -

/2021/Step5.aspxProcedure or function 'usp_studentdetails_insert_Fee_Details' expects parameter '@pdffile', which was not supplied.

Posted 12-Mar-21 23:21pm

Member 15099041

Comments

Richard Deeming 15-Mar-21 9:40am

Your error message is not a "solution" to anyone else's question!

Solution 2

I think not passing the Value @s_name when calling stored Procedure

Here getting Value

string a = Convert.ToString(txtName.Text);

Posted 4-Dec-11 23:21pm

Abhi KA

Comments

07navneet 5-Dec-11 5:32am

???

Abhi KA 5-Dec-11 5:43am

not get the values

Solution 1

This means you are not passing a value to @s_name when you are calling the stored procedure. You need to pass a valid parameter during SP execution.

Regards,
Eduard

Posted 4-Dec-11 23:06pm

Eduard Lu

Comments

07navneet 5-Dec-11 5:25am

If its so simple then how??

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2011-12-04T23:39:00

Solution 3

I got it.. There is no issue in your code. Remove the last line in your stored procedure :dead:

SQL

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[InsertInfo]
(
@s_name varchar(300),
@s_phone int,
@s_degree varchar(300)
)
as
insert into info(s_name,s_phone,s_degree) values(@s_name,@s_phone,@s_degree)
exec InsertInfo----------THIS LINE

Posted 4-Dec-11 23:39pm

thatraja

Comments

sriman.ch 5-Dec-11 5:44am

spot on...5!

07navneet 5-Dec-11 5:56am

!!!!!!!!!! You are really a MVP, sir!
Caught the error in one shot! I was struggling with this type of problem since a month but couldn't find answer! I thought about this answer but I guessed that this is the syntax for procedure.
Thanks a lot!!!

07navneet 5-Dec-11 5:58am

One more help, sir. I am learning ASP.NET by myself but not able to cope up with such problems. What should be the way to learn and master this, so that job will not be a matter for me in 2012?