I am going mad to look else where for the solution. From the web, I know that I must use a pointer which is pointing to a image location so that I can manipulate it. But the problem is how this can be done? I want to retrieve the image from a file location then display it in browser. Can any one give me your suggestion? Any suggestion and opinion is greatly appreciated.

Thanks.

For the image tag set the src attribute to that of the file location.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

i think you use pointer when reading binary from db image field

first you get the pointer for the starting of img field:
SELECT @Pointer=TEXTPTR(ImgSrc) FROM ImgTable

then you read binary data using:
READTEXT empimg.imgsrc @Pointer @Offset @Size HOLDLOCK

Ahmed Ali
Software Developer

Thanks for replying.

I forget one thing where I don't know how to store the image path in sql server. For simplicity, I use enterprise manager to create table. Once I have set the data type to image, what is the next step? What I mean is if I set the data type field to varchar, then I can type anything alphanumeric characters into the table, so how about image data type? Is it type in a location such as this => <C:\folder1\folder2\filename> into the table field?