This topic is locked

Creating a button to open a pdf stored in Azure BLOB storage

3/29/2020 2:35:43 PM
ASPRunner.NET General questions
A
alevin16 author

I used ASPrunner.net to create a nice little website that accesses patient records. The data is on Azure, a standard SQL database. I have just started to work with BLOB storage. I created a container and put a pdf file in it.
Here is what I want to do:
I created a field in one of the tables that will hold the url address of that patient's pdf file. Right now I can see the full url but it is not a hyperlink (I do not think SQL has the ability to make a column of hyperlinks? I could be wrong. Right now the column is a simple nvarchar(max))
If I cannot make the field a hyperlink could I have a button at the top, that when the user presses it, whatever patient they are on it will grab that url and go to it?
Thanks

admin 3/29/2020

Hyperlinks point to files on the hard drive, with BLOBs stored in the database it can be tricky.
What you can do is to set both 'View as' and 'Edit as' to File, see what kind of link ASPRunner.NET generates for file download and build the same kind of link manually in your button's code. It should be doable.