Sending a image to SQL Server 6.5 
Author Message
 Sending a image to SQL Server 6.5
Hi,

early i have sent a msg asking how to send a picture to SQL Server... i
figured out how to do it, i did it with AppendChunk and GetChunk....

but now i have a problem:

doing this i can only send and retrive the image to the disk, i can't see it
throught a ImageBox bounded to the image field. I read something on the SQL
Help File about "0x" caracter at the beggining of the image contents.....

resuming,,, i only want to save and read the image with a picturebox bounded
to the image field in SQL Server.

Thnaks
R Sousa



Fri, 05 Oct 2001 03:00:00 GMT  
 Sending a image to SQL Server 6.5
First of all when you see '0x' preceding some numbers all that means is
that the following number is in hexadecimal format.  To display an image
in an imagebox you have to download it to disk using .GetChunk then open
it using LoadPicture().
Quote:
-----Original Message-----

Hi,

early i have sent a msg asking how to send a picture to SQL Server... i
figured out how to do it, i did it with AppendChunk and GetChunk....

but now i have a problem:

doing this i can only send and retrive the image to the disk, i can't
see it
throught a ImageBox bounded to the image field. I read something on the
SQL
Help File about "0x" caracter at the beggining of the image
contents.....

resuming,,, i only want to save and read the image with a picturebox
bounded
to the image field in SQL Server.

Thnaks
R Sousa



Fri, 05 Oct 2001 03:00:00 GMT  
 Sending a image to SQL Server 6.5

Ok,

but i have tryed to use the picturebox bounded to the database and then use
the Edit event on the MSRDC, load the picture from the file to the control
and then use the Update to update it. This way i can see the image correctly
when i'm using the MSRDC. Can't i use other method to insert the image and
being able to see it with MSRDC or other Data Control?

Thnx
R Sousa


Quote:
> First of all when you see '0x' preceding some numbers all that means is
> that the following number is in hexadecimal format.  To display an image
> in an imagebox you have to download it to disk using .GetChunk then open
> it using LoadPicture().

> -----Original Message-----
> Hi,

> early i have sent a msg asking how to send a picture to SQL Server... i
> figured out how to do it, i did it with AppendChunk and GetChunk....

> but now i have a problem:

> doing this i can only send and retrive the image to the disk, i can't
> see it
> throught a ImageBox bounded to the image field. I read something on the
> SQL
> Help File about "0x" caracter at the beggining of the image
> contents.....

> resuming,,, i only want to save and read the image with a picturebox
> bounded
> to the image field in SQL Server.

> Thnaks
> R Sousa



Sat, 06 Oct 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Poor SQL Server 6.5 performance with Image Datatype

2. images in SQL server 6.5

3. Image Files in SQL Server 6.5

4. image fields in SQL Server 6.5, how to..?

5. Storing and Retrieving Images in SQL Server 6.5

6. sending null back to sql server 6.5

7. New Transact-SQL Debugger for Microsoft SQL Server 6.5/7.0

8. Import text file in SQL Server 6.5 via SQL in Visual Basic

9. SQL Debugger for Microsoft SQL Server 7.0 and 6.5

10. Import text file in SQL Server 6.5 via SQL in Visual Basic

11. Send Update Statement to SQl 6.5

12. Read/Write Images to SQL 6.5 from VB component

 

 
Powered by phpBB® Forum Software