Here's the scenario:

I have a datagrid with the following columns:

CustID, OrderID, ProductID, FileName

The FileName column is a Hyperlink Column

The "File" is stored as a BLOB in SQL Server

Preferred solution:
Clicking on a Filename in the datagrid fires a stored procedure that is then sent all the ID column values, which looks up the BLOB to download.

...this opens a "Would you like to Download?" (Or something) messagebox on the client's browser.

What I don't know:
1. How to send values CustID, OrderID, ProductID to the stored procedure after click event

2. How to start a download on the client's browser.

This is the final step in my project and I am totally stuck. Help me! ;)

Best Regards,

Ray Sotkiewicz

To Download The File
save the file from db to server (Blob modules are in msdn help) as file and get the server path and add it to the link "FileName"

Ahmed Ali
Software Developer