i want to save my file content in a database table. i am using sql server 2000. when i upload a file along with another control in form i want them save in table .how can i do that?

chandanbhakuni

Read about DTS in Books Online.

don't save it in a table. Save a reference to where the data is to a file path in a table. For exmple if you want to save xyz.jpg. Create a table that has the path, filename and store the file say into /somepath/otherpath/xyz.jpg then put a row in a database with a value of path = 'somepath/otherpath' filename'xyz.jpg'. Storing the content in a database is a foolish waste of database space and causes problems with backups.