I have a table with image datatype and I wana insert an image in the image field, for example

insert into dbo.Products(ProductID, ProductName, ProductPrice, ProductImage)
valeus(144, '8 Gig Lenovo memory Stick', 250.00, 'Image from C:Drive or where ever the image residing')

Thanx in advance

Recommended Answers

All 5 Replies

What programming language you're using? If VB.NEt, you may try Daniweb's site search. I've answered the same or at least very similar question few times. A pretty good search phrase is "image SQL Server VB.NET" (without quotes).

Im not using VB.Net or any other language but SQL Server 2000, I need to write an insert statement im quiry builder in SQL which will be inserting an image and other records in my table, Im sure there is a way to do that, I just dont wana write a code in C# neither in VB to do that, I Wana insert in straight to SQL then I can retrieve it later from SQL using C#

Oh thanx that was very helpful

how to insert image in sql ?!!!!
the link is not work

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.