Embedding Images in SQL Database
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
Hi I need help on how to embed or save an image and not the path of the image in a SQL2000 at 600dpi and retrieve it at the same 600dpi to display.
Dim Adapter As New OleDb.OleDbDataAdapter(lSql, ConnectionString) Dim CommandBuilder As New OleDb.OleDbCommandBuilder(Adapter) Dim memstImg As New MemoryStream picturebox.Image.Save(memstImg, picturebox.Image.RawFormat) Adapter.Fill(dataset, "image_bank") Datarow = dsImg.Tables("image_bank").NewRow() Datarow.Item("image_file") = memstImg.GetBuffer() dataset.Tables("image_bank").Rows.Add(lRow) Adapter.Update(dataset, "image_bank") raj