110,538
社区成员
发帖
与我相关
我的任务
分享sqlDataAdapter.SelectCommand中的参数问题
我在SelectCommand中建立了两个参数，在用以下两条语句后 SelectComman.CommandText中的@Param1和@Param1还是没有改变。
sqlDataAdapter1.SelectCommand.Parameters["@Param1"].Value = strkey；
sqlDataAdapter1.SelectCommand.Parameters["@Param2"].Value = strkey;
还是：SELECT msg_id, post_date, poster, email, subject, body, type, forum_subject_id
FROM
forum WHERE (subject LIKE ‘@Param1’) OR (body LIKE ‘@Param2’)
请问这是怎么会事？
sqlDataAdapter1.SelectCommand.Parameters["@Param1"].Value = strkey；
sqlDataAdapter1.SelectCommand.Parameters["@Param2"].Value = strkey;
还是：SELECT msg_id, post_date, poster, email, subject, body, type, forum_subject_id
FROM
forum WHERE (subject LIKE ‘@Param1’) OR (body LIKE ‘@Param2’)
请问这是怎么会事？
...全文
请发表友善的回复…
发表回复
Knight94 2003-04-28
- 打赏
- 举报
当然不对了，sql语句中写参数的时候，不用加“'”，把你的语句改成如下就行了。
SELECT msg_id, post_date, poster, email, subject, body, type, forum_subject_id
FROM forum WHERE (subject LIKE @Param1) OR (body LIKE @Param2)
SELECT msg_id, post_date, poster, email, subject, body, type, forum_subject_id
FROM forum WHERE (subject LIKE @Param1) OR (body LIKE @Param2)
