查询ACCESS数据库时提示少一个参数

[zhuyike]

错误内容：System.Data.OleDb.OleDbException: 至少一个参数没有被指定值。
我把“select * from [connection] where [IID]=1”，到ACCESS中查询时，每次都要输入一个IID，蛮怪的，明明在语句中已经说明了IID=1。

            OleDbConnection acccon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("./bfjDb/bfj.mdb").ToString());
            string selectcmd = "select * from [connection] where [IID]=1";
            OleDbCommand acccomm = new OleDbCommand(selectcmd, acccon);
            acccon.Open();
            OleDbDataReader dr = acccomm.ExecuteReader();
            if(dr.Read())
            {
                FCKeditor1.Value = dr["I_content"].ToString();
            }
            dr.Close();
            acccon.Close();

[milo4210]

先去吃饭，回来看看，看表面好像没什么错误

[scy251147]

貌似没有什么问题，你的IID是不是自动编号~~

[一起学习前端吧]

你用参数吧：
OleDbConnection acccon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("./bfjDb/bfj.mdb").ToString());
string selectcmd = "select * from [connection] where [IID]=?";
OleDbCommand acccomm = new OleDbCommand(selectcmd, acccon);
acccomm.Parameters.Add(new OleDbParameter("@p1",OleDbType.Integer));
acccomm.Parameters[0].Value = 1;
acccon.Open();
OleDbDataReader dr = acccomm.ExecuteReader();
if(dr.Read())
{
FCKeditor1.Value = dr["I_content"].ToString();
}
dr.Close();
acccon.Close();