存图片的问题,求救:
***********************************************
下面是源代码:错误信息:{"必须声明变量 '@pic_id'。" }
///********************************为什么啊??*************
public string insertPic(string pic_id,byte[] imagedata)
{
olecon.Close();
olecon.Open();
string sql="insert into pic(applycode_pic,imgData) values(@pic_id,@imagedata)";
OleDbCommand olecmd=new OleDbCommand(sql,olecon);
//pic_id
OleDbParameter olparmpic_id=new OleDbParameter("@pic_id",OleDbType.VarChar);
olparmpic_id.Value=pic_id;
olecmd.Parameters.Add(olparmpic_id);
//picdata
OleDbParameter olparmdata=new OleDbParameter("@imagedata",OleDbType.Binary);
olparmdata.Value=imagedata;
olecmd.Parameters.Add(olparmdata);
try
{
int numRowsAffected = olecmd.ExecuteNonQuery();
olecon.Close();
return "OK";
}
catch(Exception ex)
{
return ex.ToString();
}
}