Change record in next image

andreas5 · August 25th, 2010, 01:53 PM

Hello, i have a FormView connected to a EntityDataSource and i have the following code in my Itemtemplate:

Code:

<asp:ImageButton ID="IMG" runat="server"  ImageUrl='<%# Bind("PictureUrl") %>'/>
<asp:ImageButton ID="Prev" runat="server" onclick="Prev_Click" ImageUrl='<%# Bind("PictureUrl") %>' />
<asp:ImageButton ID="Next" runat="server" onclick="Next_Click" ImageUrl='<%# Bind("PictureUrl") %>' />

I obviously want the previous and next image from my database aswell, how would i do that?

I can think of one way, to make a DataControl and a SourceControl for each image but that sounds very innefficient.

When i tried to change the ImageUrl with vb.net in code behind i got errors about not being able to convert from a [system.string] to system.string.

There is probably a thousand ways (:

Imar · August 25th, 2010, 02:49 PM

Can't you select all three records and use a ListView to display all three of them?

Imar

andreas5 · August 25th, 2010, 05:30 PM

Yes i managed to get 3 different pictures after figuring out the Where property syntax again:)

Now the next problem is that they are all the same size, i wish to have 1 large image and 2 thumbnails. Maybe i should just store Next and Previous PictureId's in a related table.

Thanks

Imar · August 26th, 2010, 04:40 AM

If you already query three images, than it shouldn't be too hard to give each image its own size, is it? Just leave out the dimensions in the control template.

How does your current SQL statement look? How are you determining what the next and previous images are? And do you use UNION / are you familiar with the UNION construct in SQL? (That's what I would probably use to get the three images).

Cheers,

Imar

andreas5 · August 27th, 2010, 04:31 PM

I decided to go for 2 controls, one with thumbnails and one with the main image.
Thanks for all your help, i really appreciate it.

Imar · August 28th, 2010, 04:03 AM

Many ways to Rome.... ;-)

Glad you found a solution.

Cheers,

Imar