Operand type clash: int is incompatible with image

Reylin Mathew

8y1.6k.NET

this is my sql query :

select isnull(Photo,0) as photo from Std_Photo where Id=123

and the error is this:

Operand type clash: int is incompatible with image

in column field is Photo, and that datatype is image. so how can solve this problem?

plz help...

thnkx in adv..

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted answer
Write your select query as below. Some modification are needed to check the row count and value of photo.
SqlDataAdapter tmppq = new SqlDataAdapter(" select isnull(photo,'') as photo from Photo where Id='"+Id+"' ", SqlCon);
Then you need to check it as below
if(tmpds.Rows.Count ==1 && Convert.ToString(tmpds[0]["photo"]) !="")
{
//Your logic here.
}
else
{
//Your logic here.
}
Reylin Mathew8y ago
thanxfaisal and suraj....

i need this query used for(select isnull(Photo,0) as photo from Photo where Id=123)

codebehind. so

public DataTable GetPhoto(string Id)

{

DataTable tmpds = new DataTable();

GetConnect();

SqlDataAdapter tmppq = new SqlDataAdapter(" select photo from Photo where Id='"+Id+"' ", SqlCon);

tmppq.Fill(tmpds);

GetClosed();

return tmpds;

}

first of all condition check with id corresponding values empty or not.that case their no value in that field.(their is no value fill datatable

)
Faisal Pathan8y ago
try this

SELECT colPhoto = CASE WHEN Photo IS NULL THEN 'null'
ELSE CONVERT(xml,(CONVERT(varbinary(max),Photo))) END FROM
Std_Photo where Id=123
Suraj Kumar8y ago
Hello Reylin,
You can't insert integer value in null column. So, 0 is giving that error because the image and integer are not compatible with each other. Alternatively you can write your query as below for casting null value.
select isnull(Photo,'0') as photo from Std_Photo where Id=123
or
select isnull(Photo,' ') as photo from Std_Photo where Id=123
or
select isnull(Photo,'null') as photo from Std_Photo where Id=123
In all cases the data will not come in select output. You can control it in program by checking number of record and empty value.