I want to store my e-books on my intranet that I am developing, the idea is to store the link to the e-book in the DB and store the files in a folder. I have searched the web for similar tutorials but no luck or maybe just not been looking at the right spots. The idea is to manage my e-book let say display them by category , to be able to add ,delete or edit them. Anyway my DB has the following structure:
ID int
Title nvchar
filepath varchar(200)
dateposted date/time
categoryID int
can any one give me a way to go forward. even if it's a side that i need to visit.