Wrox Programmer Forums
|
BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5
This is the forum to discuss the Wrox book Beginning Visual Basic 2005 Databases by Thearon Willis; ISBN: 9780764588945
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 14th, 2009, 08:29 AM
Registered User
 
Join Date: Jan 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default insert images into database

Hello Mr.Thearon,

First, Thanks for the thorough explanation.

I encounter a problem with inserting image into database.
I define a DataColumn in the dataset with byte data type "BL Component" & image data type in SP "Data Access Component"
I convert the image to array of bytes and pass it to a dataset.
Code:
       'objDataColumn = New DataColumn("Photo", Type.GetType("System.Byte"))
        'objDataTable.Columns.Add(objDataColumn)
The problem is "cannot convert from byte() to byte"

Hope you can help

Ahmed
 
Old June 23rd, 2009, 06:45 AM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

Ahmed,

Go to the Wrox web site and download the code for Visual Basic 2005 Instant Results. I wrote an entire application that does nothing but manages images in a SQL Server database. Perhaps that code can guide you in the right direction.

Let me know if there are any further questions or problems.

Thearon





Similar Threads
Thread Thread Starter Forum Replies Last Post
Load Images from and Save Images to a Database cyndie VB.NET 2 August 17th, 2008 06:42 AM
How to insert/get images to/from a database in c#? tal C# 2005 2 April 17th, 2007 03:04 PM
How to insert images to MySQL (BLOB) wkm1925 ASP.NET 2.0 Professional 0 November 19th, 2006 06:29 AM
Insert Gif Images onto a Access form? sampow Access 4 April 1st, 2004 10:32 AM
Insert images into rtfText ric Beginning VB 6 1 February 19th, 2004 05:18 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.