[asp.net] Error:Must declare the scalar variable "@".

[pansy]

the problem is here

 

 public static List GetClientByStaffId(string STAFF_CL)
       {
           List clients = new List();
           SqlCommand selectCmd = new SqlCommand("select * from TRS_LUT_CLIENT C, TRS_TASKS T where C.CLIENT_ID = T.CLIENT_ID and  T.STAFF_CL = @ STAFF_CL");
           selectCmd.Parameters.Add("STAFF_CL", SqlDbType.NVarChar).Value = STAFF_CL;
           
           DataTable dt = DBManager.ExecuteQuery(selectCmd);
           foreach (DataRow row in dt.Rows)
           {
               clients.Add(new TRS_LUT_CLIENTS(int.Parse(dt.Rows[0]["CLIENT_ID"].ToString()), dt.Rows[0]["CLIENT_NAME"].ToString(), dt.Rows[0]["CLIENT_ADDRESS"].ToString(), dt.Rows[0]["CLIENT_DESCRIPTION"].ToString()));
           }
           return clients;
       }

 

i can't c it at all !! i thought that it may be the parameters.add . but what exactly i don't know !!

Edited September 30, 2013 by pansy

[caffrey]

It wouldn't be the space here would it ?

 

@ STAFF_CL should be @STAFF_CL ? or no @ at all, been a while since I did sql and I did it all with stored procs too.

Edited September 30, 2013 by caffrey

[pansy]

i solved by removing the cmd.parameters.add to addvalue and it's works

Thank you