Operand type clash: int is incompatible with image

Question

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..

Suraj Kumar · 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 Mathew · Answer

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 Pathan · Answer

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 Kumar · Answer

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.