I am trying to create a simple website(ASP) where a list of music titles is available from a SQL Server DataBase.
So far I have it working with Artist Name, Release & Cost. However I wish to add a picture of the artist.
My problem is how to retrieve the pictures from the SQL Server DB?
Do I have to load pictures into Database?
Do I need extra software/tools to do this?
So far I have created a new column in my table called picture and set as type image
e.g. alter table music
add picture (image) null
If I store the pictures in a folder,I presume the path to the image can be stored in the DB.
e.g. Table Music
Artist Name Release Cost Picture
Madonna Say a Prayer 10 Euro ..\images\madonna.jpeg

Is this the way? I have a little experience using ASP + SQL at college level.
Help would be appeciated, or directions to a relevant tutorial!
Thanks
I also plan to have small music downloads available for each release, if any one can point me to helpful sites etc. Thanks!