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 ";