Saving images in a database

Please let other users know how useful this tip is by rating it below. Do you have a tip or code of your own you'd like to share? Submit it here.

It's fairly easy to save an image in the database using .NET OleDB library. For simplicity, I have used MS Access database with two fields:

...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT .NET Framework database programming best practices Windows 7 for developers Microsoft's Oslo modeling platform, the M language and .NET Using the Visual Studio 2005 DataSet Designer to build a data access layer Windows Developments: Product news February 2008 Oracle updates data access components for Visual Studio 2008 Reporting tool now supports Word 2007 and VS 2008 Windows Developments: Product news, January 2008 Choose the right .NET data provider, optimize application performance Windows Developments: Product news, December 2007 The fallacy of the data layer -- or, a new architectural model for software designs Visual Basic and Visual Basic .NET Compose XML more quickly using Visual Basic 9 Virtualization keeps Legacy Apps alive VB 9 Anonymous Types help create flexible objects Visual Studio Team System Add-ins: Conchango Scrum for Team System and Scrum Dashboard Book Excerpt: Sams Teach Yourself Visual Basic 2008 in 24 Hours -- Complete Starter Kit Check out CodePlex for a ton of interesting .NET projects Book excerpt: Murach's VB 2008 Book excerpt: Printing in Visual Basic 2005 Visual Basic 2008 and closures WinForms development using SQL Server 2005 and Visual Basic 2005

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

FieldName Type
Pic OLE Object
FileSize Text

The following code establishes a database connection and inserts a file in the "Pic" field.

Save the file as SaveImage.vb.

Compile the file as: vbc SaveImage.vb /r:system.data.dll /r:system.dll. A file will be inserted in the database each time you execute SaveImage.exe.

Rate this Tip To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.