如何使用 MySQL 存储和检索图像？

<br>将文件名变暗为 String = txtName.Text ".jpg"<br>将文件大小变暗为 UInt32<p>conn.Close()</p><p>将 mstream 调暗为新System.IO.MemoryStream()<br>PbPicture.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg)<br>Dim arrImage() As Byte = mstream.GetBuffer()</p><p>FileSize = mstream.Length<br>Dim sqlcmd As New MySqlCommand<br>Dim sql As String<br>mstream.Close()</p><p>sql = "插入到[你的表]（图片、文件名、文件大小）</p><pre class="brush:php;toolbar:false">                           VALUES(@File, @FileName, @FileSize)"

conn.Open()
With sqlcmd
    .CommandText = sql
    .Connection = conn
    .Parameters.AddWithValue("@FileName", filename)
    .Parameters.AddWithValue("@FileSize", FileSize)
    .Parameters.AddWithValue("@File", arrImage)

    .ExecuteNonQuery()
End With

MsgBox(ex.Message)

conn.Close()

<br>将适配器调暗为新的 MySqlDataAdapter<br>adapter.SelectCommand = Cmd<p>data = New DataTable</p><p>adapter = New MySqlDataAdapter("从[您的表]中选择图片”， conn)</p><p>commandbuild = New MySqlCommandBuilder(adapter)<br>adapter.Fill(data)</p><p>Dim lb() As Byte = data.Rows(0).Item("图片") <br>调暗lstr如新System.IO.MemoryStream(lb)<br>PbPicture.Image = Image.FromStream(lstr)<br>PbPicture.SizeMode = PictureBoxSizeMode.StretchImage<br>lstr.Close()<br></p>