Saving Image From File To Table In SQLServer

Ini adalah kelanjutan dari Show Image To PictureBox From DataGridView Or DataReader, jadi ceritanya kita akan melakukan insert atau update field image langsung dari file (file di windows explorer). Sebenarnya bukan hanya image/gambar yang bisa di insert atau di update, tetapi SEMUA jenis file (image,document,video,audio, dan lainnya yang saya tidak mungkin sebutkan satu satu, hehehehe). baiklah seperti biasa saya akan contohkan menggunakan database northwind dan sintak nya seperti ini:

Select Image Query :
select * from

openrowset (bulk N'c:\sharingan.png',SINGLE_BLOB)

as IMAGEFILE

Jika perintah itu di-execute maka hasilnya adalah

Jika ingin mencoba file selain image contohnya mp3, silahkan :

select * from

openrowset (bulk N'c:\Music\GunsN'Roses-Don't Cry.mp3',SINGLE_BLOB)

as DJIE_FILE

Insert Image Query :

INSERT INTO Categories (CategoryID,CategoryName,Description,Picture)

SELECT * FROM (select 9 AS CategoryID, 'Sharingan' AS CategoryName,'Test Saving Image' AS Description, bulkcolumn AS Picture from

openrowset (bulk N'c:\sharingan.png',SINGLE_BLOB) as IMAGEFILE

) as DJIE

Update Image Query:
update Categories set Picture=DJIE.bulkcolumn

from (select bulkcolumn from

openrowset (bulk N'c:\sharingan.png',SINGLE_BLOB) as IMAGEFILE

) as DJIE where CategoryID=1

Cukup mudah bukan? jadi sekarang sobat dapat menyimpan File ke Tabel di Database Ms.SQL Server.

Tags:
database, sql server, save image to table, save picture to table, how to insert image to table, sql, insert picture to table, update image in table, delete image/picture, structured query language, direct image to table, data image, data reader, visula basic net, c#, visual studio, example