Attachments In SQL Server

neo · January 2, 2020, 2:35am

I have a table with a field named Attachment which is a varbinary(max) type field which stores an attachment such as a PDF
When I attach field in a form the existing attachment does not appear.

I can only store new attachments in field.

How do I get the existing attachments to appear in Angular app?

enchev · January 2, 2020, 3:29am

You want to preview the PDF content? Check this:

You can wrap everything in a custom component for example:

neo · January 4, 2020, 1:40pm

Enchev

In the screenshot attached I expected that there would be a preview object that I can click to open the 20190107_140119.jpg file that is stored in SQL Server database in another window.

I need to be able to do this so that application is backward compatible with PDFs, JPEGs that have been stored previously in database.

radzen1

enchev · January 6, 2020, 2:11pm

This is not possible with FileInput component used by the Form. The component can work with base64 encoded strings only.

mcanavar · February 25, 2020, 5:52am

HI ,
I have a base64 encoded pdf , will this work with this component ?
Any plans on including a component for base64 stored files ( all kind of file types not only images).

enchev · February 25, 2020, 7:29am

FileInput component can work with any base64 encoded string file content including pdf.

mcanavar · February 25, 2020, 8:27am

Uploading pdf seems not to work?

enchev · February 25, 2020, 8:38am

mcanavar · February 25, 2020, 8:54am

I’m using angular , any difference?

enchev · February 25, 2020, 8:57am

Ah, sorry! Here is the Angular version: https://angular.radzen.com/file-input