MySQL表如何导入图片,如何将图像插入到SQL Server数据库表中

I have created a new SQL Server local database with a table called drink.

I use Microsoft Visual Studio 2008.

Inside the table I defined the following columns:

id [int], kind [varchar], year [datatime], image [image]

I would like to insert images into the image column but I don't know how to do.

I need this column, because I want to display all data in DataGridView using VB.NET

Thanks for help!

解决方案

This worked for me...

Imports System.Data.Sql

Imports System.IO

Imports System.drawing

Module Module1

Private Const _ConnectString As String = "your connection string here"

Sub Main()

Dim MyImage As Image = Image.FromFile("RandomImage.jpg")

Dim Id As Long = 1

SaveDrinkImage(MyImage, Id)

End Sub

Sub SaveDrinkImage(MyImage As Image, Id As Long)

Dim ImageBytes(0) As Byte

Using mStream As New MemoryStream()

MyImage.Save(mStream, MyImage.RawFormat)

ImageBytes = mStream.ToArray()

End Using

Dim adoConnect = New SqlClient.SqlConnection(_ConnectString)

Dim adoCommand = New SqlClient.SqlCommand("UPDATE [drink] SET [image]=@MyNewImage WHERE [id]=@id", adoConnect)

With adoCommand.Parameters.Add("@MyNewImage", SqlDbType.Image)

.Value = ImageBytes

.Size = ImageBytes.Length

End With

With adoCommand.Parameters.Add("@id", SqlDbType.BigInt)

.Value = Id

End With

adoConnect.Open()

adoCommand.ExecuteNonQuery()

adoConnect.close()

End Sub

End Module