locked
Photo album RRS feed

  • Question

  • User2140025385 posted

    Hi,

    I'm trying to create an album gallery, which works this way:

    First, i have the album photos with description on each album under the photo, with a pager. ( that was done)

    Second, when you click on a certain album, you see all photos related to this album only. 

    I am using ACCESS DB. i just cant figure it out how to connect those data correctly, and how clicking an album will take me to the photos related only to it.

    I would appreciate any help or samples for such a thing.

    Thanks,

    Basil



    Tuesday, June 1, 2010 8:27 AM

Answers

  • User-1618234021 posted

    Hi

    What I posted was a sample code. Just wanted to show you how it will work. Ofcourse you will fire a query and bind all the album records with some control. That control will produce the output like I posted.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 1, 2010 9:26 AM

All replies

  • User241050104 posted

    r u storing images in database?

    if yes then can u pls provide ur databse related details?


    Tuesday, June 1, 2010 8:42 AM
  • User-1618234021 posted

    hi

    you have to make the photo albums links in such a way that when the use clicks on any of them you pass the album id (for example) to photos page. i.e

    <a href='photo.aspx?albumid=1'>First Album Image</a>

    <a href='photo.aspx?albumid=2'>Second Album Image</a>

    so on...

    Then on photo.aspx page load you can get the querystring parameter albumid and fire a query like :

    "select * from photo where albumid=" & Request.QueryString("albumid")

    Run the query, fetch the data and show it properly.



    Tuesday, June 1, 2010 8:48 AM
  • User2140025385 posted

    i'm using access db. im not sure about the structure of the database, but i would appreciate ur help.

    those are the fields ive created

    albumdesc
    albumphoto
    albumtype
    albumyear

    galleryphoto
    photodesc


    Each album contains description, photo, type and year. Inside that album there is only photo and description.

    Tuesday, June 1, 2010 8:52 AM
  • User2140025385 posted

    adeelehsan,

    Shukran for your reply.

    The problem is that the albums are added by some admin, so the number of albums is not known.

    Tuesday, June 1, 2010 9:06 AM
  • User-1618234021 posted

    Hi

    What I posted was a sample code. Just wanted to show you how it will work. Ofcourse you will fire a query and bind all the album records with some control. That control will produce the output like I posted.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 1, 2010 9:26 AM