How can be store image in database by vb.net

[Daya Shankar]

hi dear all of u.

 

Pls tell me how can be insert a image into database and it's fetch from databse .by vb.net and sql server 2000

as well as vb 6.0

[Cerebrus]

Too lazy to google ?

http://www.google.com/search?q=store+image+sql+server+vb.net

[Andrew Badera]

How? With code.

"varbinary"

"blob"

"Google"

--
--Andy Badera
http://andrew.badera.us/ http://flipbitsnotburgers.blogspot.com/
and...@badera.us
(518) 641-1280
Google me: http://www.google.com/search?q=andrew+badera

[CK]

create procedure addImage(@image varbinary(max))
AS
set nocount off

insert into imagetable
VALUES (@image)

if @@error > 1 print 'there was an error'

return pi
GO

create procedure getImage()
AS
set nocount off

select from imagetable

print image -- glossy or matte?

if @@error > 1 print 'there was an error' -- definitely matte this
time

return pi
GO

i always return pi so that i know it has succeeded properly and not
thrown an error.



/sarcasm
/wit
/retardation