Assigning a picture to an Image field in SQL server, using ADO 
Author Message
 Assigning a picture to an Image field in SQL server, using ADO

Can anyone tell me how to Assign a picture to an Image field in SQL Server,
via ADO.

I have used a bound picture box, but this does not seem to work...

Can anyone help??



Mon, 14 Oct 2002 03:00:00 GMT  
 Assigning a picture to an Image field in SQL server, using ADO
Have you tried using the AppendChunk method?  I've always avoided bound
controls, so can't help you there, but AppendChunk and GetChunk should work
to store and retrieve the image from the db.
- Rick


Quote:
> Can anyone tell me how to Assign a picture to an Image field in SQL
Server,
> via ADO.

> I have used a bound picture box, but this does not seem to work...

> Can anyone help??



Mon, 14 Oct 2002 03:00:00 GMT  
 Assigning a picture to an Image field in SQL server, using ADO
i've heard of this 'appendchunk' and 'getchunk" but it is always confusing
to me...can you explain it here in a simple way? thank you for your time to
anyone who would do this.

Pete


Quote:
> Have you tried using the AppendChunk method?  I've always avoided bound
> controls, so can't help you there, but AppendChunk and GetChunk should
work
> to store and retrieve the image from the db.
> - Rick



> > Can anyone tell me how to Assign a picture to an Image field in SQL
> Server,
> > via ADO.

> > I have used a bound picture box, but this does not seem to work...

> > Can anyone help??



Fri, 25 Oct 2002 03:00:00 GMT  
 Assigning a picture to an Image field in SQL server, using ADO
Here is a simple sample using Jet

http://www.concresco.com/code.htm#pictures

--

Andrew Grillage
http://www.concresco.com


Quote:
> i've heard of this 'appendchunk' and 'getchunk" but it is always confusing
> to me...can you explain it here in a simple way? thank you for your time
to
> anyone who would do this.

> Pete



> > Have you tried using the AppendChunk method?  I've always avoided bound
> > controls, so can't help you there, but AppendChunk and GetChunk should
> work
> > to store and retrieve the image from the db.
> > - Rick



> > > Can anyone tell me how to Assign a picture to an Image field in SQL
> > Server,
> > > via ADO.

> > > I have used a bound picture box, but this does not seem to work...

> > > Can anyone help??



Fri, 25 Oct 2002 03:00:00 GMT  
 Assigning a picture to an Image field in SQL server, using ADO
I have a dll that will do it for you. you can download it from
www.chriscrawford.com/dbimage
Let me know if it helps. I have complete examples as well as a vb demo
project that you can download.

Good luck - chris



Quote:
>i've heard of this 'appendchunk' and 'getchunk" but it is always confusing
>to me...can you explain it here in a simple way? thank you for your time to
>anyone who would do this.

>Pete



>> Have you tried using the AppendChunk method?  I've always avoided bound
>> controls, so can't help you there, but AppendChunk and GetChunk should
>work
>> to store and retrieve the image from the db.
>> - Rick



>> > Can anyone tell me how to Assign a picture to an Image field in SQL
>> Server,
>> > via ADO.

>> > I have used a bound picture box, but this does not seem to work...

>> > Can anyone help??



Sat, 26 Oct 2002 03:00:00 GMT  
 Assigning a picture to an Image field in SQL server, using ADO
GetChunk and AppendChunk are routines that get and put data larger than 64k
(page boundary)

so you can transfer data larger than 64K and 64K chunks of data are
transfered,...

Simple yet so Complex :-)

Mike.


Quote:
> i've heard of this 'appendchunk' and 'getchunk" but it is always confusing
> to me...can you explain it here in a simple way? thank you for your time
to
> anyone who would do this.

> Pete



> > Have you tried using the AppendChunk method?  I've always avoided bound
> > controls, so can't help you there, but AppendChunk and GetChunk should
> work
> > to store and retrieve the image from the db.
> > - Rick



> > > Can anyone tell me how to Assign a picture to an Image field in SQL
> > Server,
> > > via ADO.

> > > I have used a bound picture box, but this does not seem to work...

> > > Can anyone help??



Fri, 01 Nov 2002 03:00:00 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. Assigning a picture to an Image field in SQL server, using ADO

2. How to retrieve a bitmap-image from a SQL Server image field using ADO

3. Assigning a picture from an SQL Image field

4. Assigning a picture from an SQL Image field

5. Assigning a picture from an SQL Image field

6. SQL Server - Image Field - ADO.net with XML

7. Store the image in picture box control into the image data type in SQL server

8. display picture in sql server using ADO??

9. How to store images using ADO in SQL Server 2000

10. how to upload image to sql server by using ADO

11. Saving images in a SQL Server DB using ADO

12. Binding an Image control to an Image field in SQL Server

 

 
Powered by phpBB® Forum Software