请教:图片插入sqlserver问题
我在用updatetext时出现参数的申明问题,以下是我的代码:
strSQL="UPDATETEXT tblphoto.Photo @Pointer null 0 @Bytes";
myCommand=mConn.CreateCommand();
myCommand.CommandText=strSQL;
OleDbParameter pointerParm=myCommand.Parameters.Add("@Pointer",OleDbType.Binary,16);
pointerParm.Value=kkk;
OleDbParameter photoParm=myCommand.Parameters.Add("@Bytes",OleDbType.Binary);
while(d>0)
{
d=response.GetResponseStream().Read(buffer,0,4095);
if(d>0)
{
....
photoParm.Value=tmp1;
myCommand.ExecuteNonQuery();
}
}
运行时报错:
必须声明变量@pointer
请各位指教,谢谢!