日期:2014-05-19  浏览次数:21177 次

deleteCommand的sql语句正确吗?

"delete     from   users   where   ID=@ID "
deleteCustomerComm.Parameters.Add( "@job_id ",SqlDbType.SmallInt,2, "job_id ");
deleteCommand的sql语句正确吗?

------解决方案--------------------
deleteCustomerComm.Parameters.Add( "@job_id ",SqlDbType.SmallInt,2).Value = "job_id ";
------解决方案--------------------
"delete from users where ID=@ID " //这是 @ID
deleteCustomerComm.Parameters.Add( "@job_id ",SqlDbType.SmallInt,2, "job_id ");
//这里变成 "@job_id "了?
------解决方案--------------------
deleteCustomerComm.Parameters.Add( "@id ",SqlDbType.SmallInt,2).Value = "job_id ";