Presenting MOV-files and images from a DB

  • Thread starter Thread starter K Viltersten
  • Start date Start date
K

K Viltersten

I'd like to build up a HTML-document using
a database BUT the tricky part is that one
of the elements is a MOV-file. The other
three, four are GIF-files.

Is such data storable in a database at
all? Or would it be more suitable to
create dynamic anchors to a directory
where all the MOV's and GIF's are put?

I'm imaging that when a request like:
http://localhost/fileID_A3DF.aspx
is issued, the document created will be
something like:

<other stuff>
<img src="A3DF.gif>
<embed src = "A3DF.mov" height = 135
width = 155></embed>
<other stuff>

I'm assuming that a part of the file name,
namely "fileID_A3DF.aspx", can easily be
extracted and its four last characters
used as an in-parameter, i.e. "A3DF" in a
call to a database.

Please comment if you can suggest any
improvements to that approach.
 
If you feel you must store the object in the database, you can set up a http
handler which will stream the data back to the HTML page, this is fairly
easy to do.
 
You might want to look at the VirtualPathProvider class and
concept. This allows you to serve an ASP.NET web site
from a database, or even from a ZIP file.

Thanks for the help. I'd like to get a clarification on a part of
it, though. Which of the following two approaches would be
more suitable, would you say?

1. To distract the key for DB from the file name.
http://localhost/fileID_A3DF.aspx

or

2. To get the key as an explicit argument.
http://localhost/fileID.aspx?key=A3DF

Please advise.
 
Thanks for the help. I'd like to get a clarification on a part of
it, though. Which of the following two approaches would be
more suitable, would you say?

1. To distract the key for DB from the file name.
   http://localhost/fileID_A3DF.aspx

Here you would need to implement an URL rewriting technique
http://www.google.com/search?hl=en&q=asp.net+URL+rewrite
2. To get the key as an explicit argument.
   http://localhost/fileID.aspx?key=A3DF

This will work by default.
 
Back
Top