how to put a file into a sql image field 
Author Message
 how to put a file into a sql image field
Hi,

What is the method for storing a file on my hard disk(say c:\samplefile.doc)
into an image SQL 2000 field, using VB.net

I figure somehow I have to get the file into a string(?) in my vb.net
somehow, and then just do an insert statement into the table.

is that basiclly the correct way ?



Sat, 22 Oct 2005 14:46:14 GMT  
 how to put a file into a sql image field

Hi,

What is the method for storing a file on my hard disk(say c:\samplefile.doc)
into an image SQL 2000 field, using VB.net

I figure somehow I have to get the file into a string(?) in my vb.net
somehow, and then just do an insert statement into the table.

is that basiclly the correct way ?

See if the following helps:

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;316887


Microsoft MVP (Visual Basic)



Sat, 22 Oct 2005 22:51:15 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How to put a image from a image box into an access file

2. How to put a image from a image box into an access file

3. How to convert an image field from SQL sever to a file

4. extracting sql image field to file

5. Saving BMP files in SQL Server image fields

6. How to convert an image field from SQL sever to a file

7. How save JPG file in SQL Server image or binary field

8. How to save JPG files in SQL Server image field

9. Fill in Image controls from SQL image fields

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

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

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

 

 
Powered by phpBB® Forum Software