Avatar of sharris_glascol
Flag for United States of America asked on

Import pdf stored inside of sql into datagridview

Trying to import a pdf file that is stored in a sql database.  I want to import this into a data grid view, but be able to filter the data grid view based on a text box inside of the page.

Avatar of undefined
Last Comment
Arana (G.P.)

8/22/2022 - Mon
Pavel Celba

How is the PDF stored in SQL database? In a varchar or varbinary column? As a file stream? What should the textbox filter out?  The PDF name, the text inside PDF, or something else? What SQL backend engine are you using? What frontend language are you planning for this task?

As you see the specification is very vague so first of all you have to answer/decide about the platforms used. Then create a short prototype w/o filtering and then you may think about the filtering. If you decide about the platform then search Internet which is full of code samples. Simply ask for e.g. "Download PDF to C# from SQL Server code sample" etc.
David Johnson, CD

a pdf is great for viewing but not for using the data inside of it since a pdf is simply a replacment for a piece of paper. You need some way of selecting an area and then using optical character recognition to get the data from that area and put it into machine readable format 

One such solution is  https://docparser.com/features

Arana (G.P.)

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck