 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / April 2008Presenting MOV-files and images from a DB
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. -- Regards Konrad Viltersten -------------------------------- sleep - a substitute for coffee for the poor ambition - lack of sense to be lazy > 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. OK. > Is such data storable in a database at all? Yes, > Or would it be more suitable to create dynamic anchors to a directory > where all the MOV's and GIF's are put? "Suitable" is perhaps the wrong adjective... There are arguments both for and against storing binary files in databases. I tend to avoid doing it, but that's just a personal preference... > 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. http://msdn2.microsoft.com/en-us/library/system.io.path.getfilenamewithoutextens ion.aspx http://msdn2.microsoft.com/en-us/library/system.string.substring.aspx  SignatureMark Rae ASP.NET MVP http://www.markrae.net 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. >> I'd like to build up a HTML-document using a database BUT the tricky part >> is that one [quoted text clipped - 21 lines] > http://msdn2.microsoft.com/en-us/library/system.io.path.getfilenamewithoutextens ion.aspx > http://msdn2.microsoft.com/en-us/library/system.string.substring.aspx 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. -- Peter To be a success, arm yourself with the tools you need and learn how to use them. Site: http://www.eggheadcafe.com http://petesbloggerama.blogspot.com http://ittyurl.net > I'd like to build up a HTML-document using > a database BUT the tricky part is that one [quoted text clipped - 32 lines] > sleep - a substitute for coffee for the poor > ambition - lack of sense to be lazy > 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. -- Regards Konrad Viltersten -------------------------------- sleep - a substitute for coffee for the poor ambition - lack of sense to be lazy > > You might want to look at the VirtualPathProvider class and > > concept. This allows you to serve an ASP.NET web site [quoted text clipped - 6 lines] > 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. >> Thanks for the help. I'd like to get a >> clarification on a part of it, though. [quoted text clipped - 11 lines] > > This will work by default. In that case, this'll be the method i'll use. Why complicate thing? Thanks! -- Regards Konrad Viltersten -------------------------------- sleep - a substitute for coffee for the poor ambition - lack of sense to be lazy
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.