I am having an issue showing images in a Gridview control. It is only displaying the first image it comes to in the database and I am having problems figuring out how get the handler page to differentiate between images.
Here is the set up of the table. It is a many table (VehicleImagesTBL) with ID being a many to one from the Primary table (VehicleTBL):
ID INT
ContentType nvarchar(5)
PictureDescription nvarchar(MAX)
Data varbinary(MAX)
PictureDate datetime
UploadBy nvarchar(50)
RecID int (PK)
I can convert the image data to binary and store it in the table no problems there. So lets say that I have 3 different views of a vehicle with an ID of 99, the table looks something like this:
ID
ContentType
PictureDescription
Data
PictureDate
UploadBy
RecID
99
image/jpg Go to the complete details ...