There is a syntax error near 'nvarchar. The scalar variable "@" must be declared.

This is a problem that has plagued me for a day and finally solved it. I hope it can help my friends like me.

Example: String sequence = "insert into tbl_pod (custcode, [vehicle/LTL], transittimelimit, isurgency, bizmode) values (@ custcode, @ [vehicle/LTL], @ transittimelimit, @ isurgency, @ bizmode )";
Sqlparameter [] parm = {
New sqlparameter ("@ custcode", pod. custcode ),
New sqlparameter ("@ [vehicle/LTL]", pod. vehicleltl ),
New sqlparameter ("@ transittimelimit", pod. transittimelimit ),
New sqlparameter ("@ isurgency", pod. isurgency ),
New sqlpara
If (sqlhelper. executenonquery (sqlhelper. connectionstringforsql, commandtype. Text, SQL _insert_pod, parm)> 0) meter ("@ bizmode", pod. bizmode)> 0? True: Fals;

 

I can't see it. @ [vehicle/LTL] does not work. Microsoft vs's mechanism parameter @ [vehicle/LTL] cannot be identified. This is because we operate a lot in the database. A written mistake

 

Change @ [vehicle/LTL] to @ vehicleltl.

Key: The parameter name is custom. Do not add a symbol to the parameter name. Otherwise, you will be killed during maintenance.