How to insert images in a SQLServer table?

[Guest]

Is there a way of insert or update images (*.gif or *.jpg) in a image field
of a SQLServer table without using code?
Some sort of small application can do that? by supplying the filename maybe?

Thanks in advance...

 

[Ashish Das]

http://support.microsoft.com/kb/309158/EN-US/

link above will give you a good idea about how blob works. as a programmer
you will in every case use code to access sql server.

 

[Guest]

You could also insert a text field in sqlServer table, containing the names
of the image files, and then use this field to open the images stored in a
selected folder.

Hope this helps.

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi

It's very easy, just create a field of type Image , then in the C# code
declare the parameter as Binary and set its value to a byte array containing
the image

Tell me if you need the code


cheers,

 

[Guest]

Ok people thank u all, i´ve found a tool named textcopy that do what i was
looking for, with this tool i can insert images into table fields of image
type.
u can finf it in ms sqlserver\mssql\binn