IOMHouston

Need help on parameterized query

Discussion created by IOMHouston on May 30, 2011
Latest reply on May 30, 2011 by IOMHouston

I am trying to use the parameterized query to get a data set in a OLE DB data adapter. But I always get the following error when it is executed:

 

                   [SQL Parser] [Line 1] Syntax error near '@'

 

 

 

The following is the simplified code:

 

                using (OleDbCommand cmd = new OleDbCommand())

 

                {

 

                        cmd.Connection = connectionObject;

 

                        cmd.CommandText = "SELECT tag FROM PIPOINT..PIPOINT2 WHERE tag LIKE @TagName";

 

                       

 

                        OleDbParameter param = new OleDbParameter("@TagName", OleDbType.VarChar);

 

                        param.Value = "SINUSOID";

 

                        cmd.Parameters.Add(param);

 

                        cmd.ExecuteNonQuery();

 

 

 

                }

 

 

 

What’s wrong with this code?

Outcomes