Create an Image Gallery with FILES in a web directory and names of files in SQL server

[news.microsoft.com]

Hello and first of all thank you for your time.
I am currently developing an ASP.net web page, which has data stored in SQL
Server. It is a web page for a State Agent and my problem is:

I need to create an image gallery (with some kind of slide Next and Previous
picture) of the flat you are interested to see.
The pictures are stored on a directory of the web.
The names of the pictures are stored, also, on a table in SQL which is
FlatPhotos, and of course I have the fields PhotoID, FlatID, on
one-to-multiple basis, as there are around 10 or 14 photos for each flat.

I have already designed the page for the one-only-flat that you are
interested to see, and everything is working fine, except for the picture
gallery.

I have been working and trying to search for info on the web for more than 8
hours now, an I decided to contact you.

The final design is like this

<=Previous Button
Picture 1
Picture 2
Picture 3
Picture 4
Picture 5
Next button =>














Main picture (or the picture you click on in a bigger size)












Text info of the flat


Can you help me with this, please?
Thanks again and sorry for the inconvenience.

Albert Lens

WIN SOLUTIONS SL

 

[Ken Tucker [MVP]]

Hi,

Maybe this will help
http://www.ngallery.org/

Ken
---------------------
Hello and first of all thank you for your time.
I am currently developing an ASP.net web page, which has data stored in SQL
Server. It is a web page for a State Agent and my problem is:

I need to create an image gallery (with some kind of slide Next and Previous
picture) of the flat you are interested to see.
The pictures are stored on a directory of the web.
The names of the pictures are stored, also, on a table in SQL which is
FlatPhotos, and of course I have the fields PhotoID, FlatID, on
one-to-multiple basis, as there are around 10 or 14 photos for each flat.

I have already designed the page for the one-only-flat that you are
interested to see, and everything is working fine, except for the picture
gallery.

I have been working and trying to search for info on the web for more than 8
hours now, an I decided to contact you.

The final design is like this

<=Previous Button
Picture 1
Picture 2
Picture 3
Picture 4
Picture 5
Next button =>














Main picture (or the picture you click on in a bigger size)












Text info of the flat


Can you help me with this, please?
Thanks again and sorry for the inconvenience.

Albert Lens

WIN SOLUTIONS SL

 

[Guest]

I would think you are looking for a datalist. Try using a datalist for the
gallery display. I just finished teaching a class at LSUA and the project
was a photo gal. If you feel you would like the source on it let me know. Its
in VB.