c# – Acess SQL查询缺少更多必需参数

SELECT ItemName as Name,ItemPicture as Picture,ItemHeroModif as Assistance,ItemTroopModif as Charisma,HerbCost as Herbs,GemCost as Gems
FROM Item WHERE ItemId = @value0

有了断点,我可以看到我附加了@ value0的值,2.

尽管如此,我收到以下错误：

No value given for one or more required parameters.

我知道这个错误通常是由于错误的SQL语法而产生的.我做了什么有什么不对吗？

编辑：

附件代码：

var madeForCommand = "SELECT ItemName as Name,ItemPicture as [Picture],GemCost as Gems FROM Item WHERE ";
        OleDbCommand command = new OleDbCommand();
        for (int ii = 0; ii < items.Count; ii++)// items is a list of items with IDs I want to get from the query.
        {
            madeForCommand += "ItemId =@value"+ii+" OR ";   
        }
        madeForCommand = madeForCommand.Substring(0,madeForCommand.Length - 4); // making sure I trim the final or; In the case I shown,it's just one item,so there are none at all.

后来：

OleDbCommand forOperations = new OleDbCommand(madeForCommand,_dbConnection); //_dbConnection is the connection to the database,it seems to work pretty well.
for (int ii = 0; ii < items.Count; ii++) 
        {
            string attach = "@value" + ii;
            command.Parameters.AddWithValue(attach,items[ii].ID);
        }

我很确定项目[ii] .ID很好,断点显示它等于2并且附件顺利.

编辑2：
我编写了Krish和Hans建议的代码,我得到以下查询,没有任何附件：SELECT ItemName为[Name],ItemPicture为Picture,ItemHeroModif为Assistance,ItemTroopModif为Charisma,HerbCost为Herbs,GemCost为Gems FROM [项目] WHERE((2)中的ItemID);如果它改变了什么,我仍然会得到同样的错误.

编辑3：
在Access中执行查询要求我给参数“ItemPicture”赋值……奇数; ItemPicture是一个专栏,不是吗？