Must declare the scalar variable "@user_code" in parameterized query

Question

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    Dim ds As DataSet = New DataSet()
    Dim param As SqlParameter = New SqlParameter("@user_code", SqlDbType.Char, 4)
    param.Value = "0016"
    Const sqlstr As String = "select sectors.sector_code,sector_name   from user_sectors inner join sectors on user_sectors.sector_code = sectors.sector_code  where user_code = @user_code  and sectors.sector_code not in ('z')"

    Dim da As SqlDataAdapter = New SqlDataAdapter(sqlstr, _con)
    da.Fill(ds)
    ddl.DataValueField = "sector_code"
    ddl.DataTextField = "sector_name"
    ddl.DataSource = ds.Tables(0)
    ddl.DataBind()

End Sub

Essesntially, you declare an SqlParameter but you don't do anything with it. Your need to add it to an SqlCommand. Or just use EF or some other ORM. — Jodrell
– Jodrell, Commented Oct 4, 2012 at 8:23

Pranay Rana · Accepted Answer · 2012-10-04 08:05:39Z

2

Code for adding parameter to dataadapter

    SqlConnection conn = new SqlConnection("Data 
             Source=localhost;Database=Northwind;Integrated Security=SSPI");
  SqlCommand command = new SqlCommand("GetProducts", conn);
  command.CommandType = CommandType.StoredProcedure;
  command.Parameters.Add("@CategoryID", SqlDbType.Int).Value = 1;
  SqlDataAdapter adapter = new SqlDataAdapter(command);
  DataSet ds = new DataSet();
  adapter.Fill(ds, "Products");

add parameter to you data adapter object like this

da.Parameters.Add(param)

this is missing in your code

MSDN : Using Parameters with a DataAdapter

edited Oct 4, 2012 at 8:05

answered Oct 4, 2012 at 6:51

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

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

2 Comments

Aditya Pratap Singh Over a year ago

cannot resolve symbol Parameter. my problem still not solved.

Pranay Rana Over a year ago

@AdityaPratapSingh - check the msdn link where you can find example how to add parameter to the dataadapter....

Collectives™ on Stack Overflow

Must declare the scalar variable "@user_code" in parameterized query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related