Share photos with your own Photo Gallery

A photo speaks for thousand words. You preserve memories of pleasurable, happy and joyous moments of your life in photos. You also want to share such moments with your friends, relatives and family members. Photo gallery is a natural place where you share your snaps with others. This series of articles will demonstrate how one can build a photo gallery complete with categories, thumbnails and security using ASP.NET 2.0 and SQL Server 2005. In this part we start with database design and few utility classes.


  • Create albums
  • Albums can be public or private
  • Browser based image upload
  • SQL Server 2005 as image store
  • Add title and description to photos
  • Generate thumbnails of photos

System Requirements

  • ASP.NET 2.0
  • SQL Server 2005 Express Edition
  • Visual Studio 2005 or Visual Web Developer Express Edition

Installation Instructions

  • Download the associated ZIP file
  • Unzip in a folder
  • Open Visual Studio 2005
  • Using File - Open Web Site menu option locate the folder where you unzipped the files
  • Customize if required and run

NOTE: The download includes SQL Server 2005 database (see App_Data folder).

Screen Shot

Bipin Joshi is an independent software consultant, trainer, author, and meditation teacher. He has been programming, meditating, and teaching for 25+ years. He conducts instructor-led online training courses in ASP.NET family of technologies for individuals and small groups. He is a published author and has authored or co-authored books for Apress and Wrox press. Having embraced the Yoga way of life he also teaches Ajapa Yoga to interested individuals. To know more about him click here.

Get connected : Facebook  Twitter  LinkedIn  YouTube

Posted On : 08 February 2007

Tags : ASP.NET Data Access ADO.NET Sample Applications Projects