tags:

views:

551

answers:

2
Q: 

Fileupload to varbinary FileStream Field ASP.net

Hello

I want to upload files from fileupload control and save them as varbinary Filestream in the database.

First of all, does this make sense? Would you recommend this?

Then, how does it work? I want to be able to upload Imagefiles as well as .doc and .xls.

so when i have uploaded a .xls, how would i save it to the Database(i'm going to use Linq2Entities).

Thanks for help

+2  A: 

Sure that makes sense. This link goes through that method.

http://www.kodyaz.com/articles/file-upload-and-save-to-sql-server.aspx

Albert  2010-02-08 14:24:41
Thank you, thats what i needed.I just saved a .doc into the database. How can i output it?with Response.contentype it should work somehow, but im not sure how.
k0ni  2010-02-08 14:40:29
And how would i save a file with LinqToEntities?when i try to save it i get an error telling me:Unable to update the EntitySet 'tbl_Files' because it has a DefiningQuery and no <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation.
k0ni  2010-02-08 15:04:44
A: 

I suggest save file on disc and filename (additional data like size, mimetype, etc) in database.

dario-g  2010-02-08 14:35:14

related questions

Backup SQL Schema Only?
Sql to query a dbs scheme
Timer-based event triggers
Sql query, count and group by
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting
How do I use T-SQL Group By
What all do I need to escape when sending a (My)SQL query?
Split String in SQL
Datatable vs Dataset
ASP.NET MVC "CRUD" Database Sample
Convert HashBytes to VarChar
Best Book for a new Database Developer
What is the best way to avoid SQL injection attacks?
What language do you use for Postgresql triggers and stored procedures?
What is the best way to handle multiple permission types?
How do I index a database field
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Is there a version control system for database structure changes?
How to export data from SQL Server 2005 to MySQL
ASP.NET Site Maps
Decoding T-SQL CAST in C#/VB.net
Flat File Databases in PHP