Procedure or function 'BindSectionByTeacher' expects parameter '@SchoolId', which was not supplied.

Question

0.00/5 (No votes)

See more:

I have a query and i am trying to bind class inside a dropdown but it showing the following error...

"Procedure or function 'BindSectionByTeacher' expects parameter '@SchoolId', which was not supplied."

I Understand the error but i think i have supplied the SchoolId ....Below is my query....

SQL

ALTER PROCEDURE [dbo].[BindClassByTeacher]
@TeacherId int,
@SchoolId int
AS
BEGIN
    select T.AllowtedClass,T.ClassId from TeacherAllowtedClass T
    inner join SchoolMaster S
    on S.School_ID=T.School_ID
    where  T.School_ID=@SchoolId and T.Teacher_ID=@TeacherId
    Order by T.ClassId
END

and my backend coding is...

DbConnection bind = new DbConnection();
            bind.BindDropdownlist_para(ddlclass, "[BindClassByTeacher]", "AllowtedClass", "ClassId", "@SchoolId", Session["School"].ToString(),
                "@TeacherId", Session["teacherid"].ToString());

Allowted Class ClassId
   11th   	2
   Nursery	4
   10th	        8

Please try to help me...thanx....

Posted 5-Jun-14 1:07am

Md.Ashraf Ali

Updated 5-Jun-14 1:13am

v4

Add a Solution

Comments

Saral S Stalin 6-Jun-14 4:35am

Please post code for BindDropdownlist_para

2 solutions

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)

Ajith K Gatty · Answer 1 · 2014-06-05T01:15:00

Solution 1

Hi Ashraf,

In your stored procedure input parameters are of type integer. And in code behind you are using string values.

I think that is why you are getting error. Check that once.

Posted 5-Jun-14 1:15am

Ajith K Gatty

Comments

Md.Ashraf Ali 5-Jun-14 7:23am

Hi Ajith,

this is my session value....
int SchoolId = Convert.ToInt16(dr["School_ID"]);
Session["SchoolId"] = SchoolId;
This is in interger i dunno what to do....could u write something for me...

Naz_Firdouse · Answer 2 · 2014-06-05T01:22:00

Solution 2

Convert the string to int in the below code

Use Convert.ToInt32(Session["School"]) instead of Session["School"].ToString()

Posted 5-Jun-14 1:22am

Naz_Firdouse

Comments

Md.Ashraf Ali 5-Jun-14 7:26am

Hi NAZ
this is my session value....
int SchoolId = Convert.ToInt16(dr["School_ID"]);
Session["SchoolId"] = SchoolId;
This is in interger i dunno what to do....could u write something for me...

Naz_Firdouse 5-Jun-14 8:45am

though you are storing int vaules in the session , while getting the values from session, you need to case the values as per the required datatype...
so you need to convert the session value to int while passing it to stored procedure...
because your SP expects an integer not a string...

Naz_Firdouse 5-Jun-14 8:46am

further have a look at the answer provided at
http://forums.asp.net/t/1406866.aspx?Storing+integers+using+Session+variable[^]