In my system, I generate invoices as PDF for my clients and I need to email them and save them on the database. What is the best approach for achieving that?!
Shall I save the files path in the SQL server 2000 as ( varchar ) and save files in a folder in the server or there is another approach?! is there any recommendation or advice about the procedure to send emails shall i save them first then send them or ...!??
Appreciate your advice!
You can save any file intactly into SQL server, using BLOB columns. What you need to do is only transfer binary data between files and databases, which is easy to accomplish with C# or VB, ect.
FYI, here is a similar post:
http://forums.asp.net/thread/1257206.aspx
No comments:
Post a Comment