I have a SQL database that has details of video, jpg and pdf files.
I have web pages that hit my main site with a video file id as part of the URL
The web site should look up the Id of the URL and silently redirect the user to the web site from the database
For example:
www.abc.net.au/id=XYX123
should lookup the SQL database "select FileURL from tblFiles where Id='XYZ123'
and redirect to the FileURL site (it will be a valid URL)
Initially, the FileURL will be a YouTube URL (eg: [login to view URL])
and it should play in a frame without the extra YouTube stuff - just the video file
The web site should be written in ASP and using VB.NET