how to store data in sql 2000 having binary datatype?

Question

I am using asp.net as front end and developing intranet mailing system i want to store the files attached in the database can any 1 tell me how to store it?

Answer 1

There is a way to do it. However, this type of data storage can be problematic, you can just store the file link in the database, and strore the images on your server. It's easier to do, won't tie up your database or connection. If you want users to be able to upload files, most asp hosting accounts come with persists upload or you can create your own, screen for the proper file type, perform string manipulation (e.g. remove or replace spaces) and the store the file path to the database instead of the image.