Avatar of BlakeMcKenna
BlakeMcKennaFlag for United States of America

asked on 

Storing a PDF File as an Image?

I'm saving a PDF file in a SQL Server DB. The column in the Table is defined as varbinary(MAX). I was wondering if the PDF can be stored as an Image DataType? If so, which is more efficient to do? Is there a better way altogether?

If you could provide a code example in VB.Net, I would appreciate it!

Thanks!
Visual Basic.NET

Avatar of undefined
Last Comment
David L. Hansen
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

I usually just store the files location in a regular varchar column. Just be sure to store the full path (the full UNC is of course preferable).
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

Your VB program can then use the path's string value (eg. using the IO namespace...ie. IO.File.Open).
Avatar of BlakeMcKenna
BlakeMcKenna
Flag of United States of America image

ASKER

I already know how to do this. This isn't related to my question.
ASKER CERTIFIED SOLUTION
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
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
Avatar of BlakeMcKenna
BlakeMcKenna
Flag of United States of America image

ASKER

Thanks David...that's more what I was looking for!
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

Glad to help Blake!
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo