Please solve the error Must declare the scalar variable "@Role".

Question

0.00/5 (No votes)

See more:

con.Open();

using (SqlCommand comm = new SqlCommand("select [Add] from Role1 where Role_Name=@Role and Pages=@Pages ", con))
{ // 2. define parameters used in command object
SqlParameter para = new SqlParameter();
para.ParameterName = "@Role"; para.Value = Session["Role"];
para.ParameterName = "@Pages"; para.Value = "Checkin";// 3. add new parameter to command object
comm.Parameters.Add(para); // // Read in the SELECT results. //
SqlDataReader reade = comm.ExecuteReader();
while (reade.Read())
{ Session["Add"] = Convert.ToString(reade["Add"]); }
// Button Add = (Button)PreviousPage.FindControl("Button2");
if (Session["Add"].ToString() == "Y")
{
Button2.Visible = true;
}
else
{
Button2.Visible = false;
}
con.Close();
}

Posted 17-Apr-14 1:03am

Member 10578683

Add a Solution

Comments

[no name] 17-Apr-14 7:10am

The error is telling you exactly what the problem is. You did not add a parameter named @Role to the parameter collection.

2 solutions

Solution 2

You are creating one single SqlParameter variable and try to use it to define two parameters.
That cannot work.
Your code should better look like:

C#

con.Open();
using (SqlCommand comm = new SqlCommand("select [Add] from Role1 where Role_Name=@Role and Pages=@Pages", con))
{
  // 2. define parameters used in command object
  comm.Parameters.AddWithValue("@Role", Session["Role"]);
  comm.Parameters.AddWithValue("@Pages", "Checkin");
  SqlDataReader reade = comm.ExecuteReader();
  while (reade.Read())
  {
    Session["Add"] = Convert.ToString(reade["Add"]);
  }
  // Button Add = (Button)PreviousPage.FindControl("Button2");
  Button2.Visible = (Session["Add"].Equals("Y", StringComparison.InvariantCultureIgnoreCase));
}
con.Close();

Hope this helps. Good luck.

Posted 17-Apr-14 1:17am

phil.o

v2

Comments

Member 10578683 17-Apr-14 7:57am

Button2.Visible = (Session["Add"].Equals("Y", StringComparison.InvariantCultureIgnoreCase));
thi line showing error

phil.o 17-Apr-14 8:07am

Which error?

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 · 2014-04-17T01:18:00

Do write your code properly. You didn't pass the pass value for @Role.

C#

SqlParameter para = null;

//Pass @Role parameter
para = new SqlParameter();
para.ParameterName = "@Role"; 
para.Value = Session["Role"];
comm.Parameters.Add(para);

//Pass @Pages parameter
para = new SqlParameter();
para.ParameterName = "@Pages"; 
para.Value = "Checkin";
comm.Parameters.Add(para);