Image files

[Guest]

Hi

This is supposed to a SQL Server question but we did not get any response after posting it on that Newsgroup so would like to try to get some help from here

We are developing a .NET ASP front end and SQL Server back end web app. We like to save some image files and some other type of files with some pre-edited formats into database.

1. In the database table, shall we use "image" data type for the images files and "binary" data type for other files
2. How shall we load all these files into database tables

Not very familiar with SQL Server. Any info and advice will be highly appreciated

j

 

[Guest]

This MSDN How To Article covers this task

http://support.microsoft.com/default.aspx?scid=kb;EN-US;30804

Mike McIntyre [MVP Visual Basic]