Very Computer

by **Paul Aspinal** » Fri, 28 Apr 2000 04:00:00

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??

by **Rick** » Fri, 28 Apr 2000 04:00:00

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??

by **Pete** » Tue, 09 May 2000 04:00:00

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??

by **Andrew Grillag** » Tue, 09 May 2000 04:00:00

Here is a simple sample using Jet

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

--

Andrew Grillage
http://www.concresco.com

> 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??

by **Chris Crawfo** » Wed, 10 May 2000 04:00:00

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

>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??

by **Mike Forste** » Tue, 16 May 2000 04:00:00

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.

> 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??

Very Computer

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

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

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

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

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

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

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