读书人

deleteCommand的sql语句正确吗?解决办

发布时间: 2012-01-12 22:11:58 作者: rapoo

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

读书人网 >C#

热点推荐