Procedure or function 'sp_SqlImage' expects parameter '@ID', which was not supplied.

Question

0.00/5 (No votes)

See more:

, +

Hello

Plz help me with this.

Procedure or function 'sp_SqlImage' expects parameter '@ID', which was not supplied.

I have declared the parameter ID in Sql procedure also created in table.

But i get this error plz help

My code is

C#

public partial class TableAdd : System.Web.UI.Page
    {
        DataSet ds = new DataSet();

        SqlConnection con;
        SqlCommand cmd = new SqlCommand();
        SqlParameter sp1 = new SqlParameter();
        SqlParameter sp2 = new SqlParameter();
        SqlParameter sp3 = new SqlParameter();
        SqlParameter sp4 = new SqlParameter();
        SqlParameter sp5 = new SqlParameter();
        SqlParameter sp6 = new SqlParameter(); 
   }

----------------------------------------------------------
This is the add button on the page.:

C#

protected void Button1_Click(object sender, EventArgs e)
       {
           con = new SqlConnection("server=203.199.15.181; database= commonlogin;uid=sa;pwd=nirwan612");
           //cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value =Convert.ToInt32( txtID.Text);
           cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = txtName.Text;
           cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = txtDesc.Text;
           cmd.Parameters.Add("@Image", SqlDbType.Binary).Value = txtImage.Text;
           cmd.Parameters.Add("@Active", SqlDbType.VarChar).Value = txtActive.Text;
           cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = txtCreatedBy.Text;
           cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = txtCreDate.Text;
           cmd=new SqlCommand ("sp_SqlImage", con);
           cmd.CommandType =CommandType.StoredProcedure;



           con.Open();
           cmd.ExecuteNonQuery ();
           con.Close();
       }

------------------------------------------------

Posted 12-Jun-12 19:36pm

Nikil0012

Updated 12-Jun-12 19:41pm

tanweer

v2

Add a Solution

Comments

amolpatil2243 13-Jun-12 1:43am

Your @ID parameter is commented, remove comment

tanweer 13-Jun-12 1:44am

hi, remove comment from this line and test:
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value =Convert.ToInt32( txtID.Text);

Nischal Bhatt 13-Jun-12 1:47am

Hi! I would check the application code and see what value i'm setting @Image to. I suspect it is null and therein lies the problem.

Nikil0012 13-Jun-12 1:47am

I have tried that already, but same error, plz help

tanweer 13-Jun-12 1:53am

you have used the datatype of the parameter SqlDbType.BigInt, check it in the procedure is it the same there??

Nikil0012 13-Jun-12 2:04am

Ya it is same in the procedure.

Code 89 13-Jun-12 1:59am

run the code and see wat value u getttin for txtid..

Rahul Rajat Singh 13-Jun-12 2:18am

Why are you doing a new on cmd again after giving it all parameters? see my answer for my idea on what all could be wrong here.

2 solutions

Solution 1

You have commented out this line:

C#

//cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value =Convert.ToInt32( txtID.Text);

Uncomment it and set the correct value. Error tells that Stored Procedure does have ID as one of the parameter defined and you need to pass it along with others from your code.

Posted 12-Jun-12 19:43pm

Sandeep Mewara

Comments

Nikil0012 13-Jun-12 1:47am

I have tried that already, but doesn't work, plz help

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)

Rahul Rajat Singh · Accepted Answer · 2012-06-12T20:15:00

0. your stored procedure expects a parameter called @id.
1. you have a line commented which perhaps is needed to supply the @ID parameter.
2.

your class contains this

C#

SqlCommand cmd = new SqlCommand();

then on button click

C#

con = new SqlConnection("server=203.199.15.181; database= commonlogin;uid=sa;pwd=nirwan612");
           //cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value =Convert.ToInt32( txtID.Text); <----Uncommenting this probably should work, also see one comment below in same code block
           cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = txtName.Text;
           cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = txtDesc.Text;
           cmd.Parameters.Add("@Image", SqlDbType.Binary).Value = txtImage.Text;
           cmd.Parameters.Add("@Active", SqlDbType.VarChar).Value = txtActive.Text;
           cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = txtCreatedBy.Text;
           cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = txtCreDate.Text;
           cmd=new SqlCommand ("sp_SqlImage", con); //<----------WHAT and WHY THIS?
           cmd.CommandType =CommandType.StoredProcedure;

Why are you doiing a new on command after adding so many parameters to it. instead you should do

C#

cmd.Connection = con;
cmd.CommandText = "sp_SqlImage";