请大家帮忙看看这段代码,有什么错的!!急急,在线等
private int StoreImage()
{
int result=-1;
string strSql="INSERT INTO IMAGE(NAME,IMAGE) VALUES(@NAME,@IMAGE)";
System.Data.Odbc.OdbcParameter pName=new System.Data.Odbc.OdbcParameter("@NAME",System.Data.Odbc.OdbcType.Text);
System.Data.Odbc.OdbcParameter pImage=new System.Data.Odbc.OdbcParameter("@IMAGE",System.Data.Odbc.OdbcType.Image);
pName.Value=picDialog.FileName;
System.IO.MemoryStream stream=new System.IO.MemoryStream();
pic.Image.Save(stream,pic.Image.RawFormat);
stream.Position = 0;
byte[] img=new byte[stream.Length];
stream.Read(img,0,(int)stream.Length);
pImage.Value=img;
accessCommand.Parameters.Add(pName);
accessCommand.Parameters.Add(pImage);
accessCommand.CommandText=strSql;
try
{
if(accessCommand.ExecuteNonQuery()==1)
{
strSql="SELECT MAX(ID) AS MAX FROM IMAGE";
accessCommand.CommandText=strSql;
System.Data.Odbc.OdbcDataReader accessRead=accessCommand.ExecuteReader();
accessRead.Read();
result=(int)accessRead["MAX"];
accessRead.Close();
}
else
result=-1;
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
return result;
}
if(accessCommand.ExecuteNonQuery()==1)这一句有错,
错误: "ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 2。"
100分啊!