bungpeng Posted May 26, 2003 Posted May 26, 2003 May I know how do I save the file (image, excel file...) to SQL server? Where can I find those info? Thank you. Quote
*Gurus* Derek Stone Posted May 26, 2003 *Gurus* Posted May 26, 2003 You can create a column of type "image", which can store binary data in sizes ranging from 0 bytes to 2 gigabytes. This isn't standard practice however, since it can bloat the database quite quickly. Instead, store the files in a directory. Quote Posting Guidelines
bungpeng Posted May 26, 2003 Author Posted May 26, 2003 I know there is a data type call "image", but how do it convert my image file to binary format and insert into database? any example or references? TQ Quote
Moderators Robby Posted May 26, 2003 Moderators Posted May 26, 2003 I would follow Derek's advice and store the files in a directory, if you insist on storig them in the DB then this may help... It get the image from the user (it's for ASP.NET) http://www.xtremedotnettalk.com/showthread.php?s=&threadid=69196&highlight=image Quote Visit...Bassic Software
bungpeng Posted May 27, 2003 Author Posted May 27, 2003 TQ, this is what I want. May I know why you comment 'This isn't standard practice'? In what sense? Quote
Moderators Robby Posted May 27, 2003 Moderators Posted May 27, 2003 The answer lies in the rest of Derek's sentence, "...since it can bloat the database quite quickly" Quote Visit...Bassic Software
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.