Am looking to design a web part that will display a link for a user to download a PDF file. This is stored as a BLOB in SQL Server. This web part would be connected to another Sharepoint list where the user selects an item and this web part would display a link to view/download the file(s) if there are any.
Running Sharepoint Foundation 2010. Is there any way to do this? I am a novice at developing anything for Sharepoint (just created my first web part all by myself!) and would appreciate any assistance.