从数据库加载图像 [英] LOADING IMAGE FROM DATABASE

问题描述

代码是从表STAFFPICS加载图像并且在

THE CODE IS TO LOAD IMAGE FROM TABLE "STAFFPICS" AND IS GIVING PROBLEM AT"

PictureBox1.Image = Image.FromStream(stmSTAFF_PICS)

PICS）PICS）SAYING INVALID时出现问题PARAMETER.HELP ME OUT

PICS)PICS)" SAYING INVALID PARAMETER.HELP ME OUT

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
       Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Users\BELLCONSULT\Documents\COUNCILS.mdb"
       Dim cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(strConnection)
       cn.Open()

       Dim dd As New OleDb.OleDbCommand("select STAFF_PICS from STAFFPICS where F_NO =" & Val(TextBox2.Text), cn)
       Dim dr As OleDb.OleDbDataReader = dd.ExecuteReader()
       dr.Read()
       If dr.HasRows Then
           Dim byteSTAFF_PICS(dr.GetBytes(0, 0, Nothing, 0, Integer.MaxValue) - 1) As Byte
           dr.GetBytes(0, 0, byteSTAFF_PICS, 0, byteSTAFF_PICS.Length)
           Dim stmSTAFF_PICS As New IO.MemoryStream(byteSTAFF_PICS)
           PictureBox1.Image = Image.FromStream(stmSTAFF_PICS)

       End If
       dr.Close()

   End Sub

推荐答案

通常情况下，这意味着你保存错误：

为什么我会得到参数无效。我从数据库中读取图像时出现异常？ [ ^ ]

Normally, this means you saved it wrong:
Why do I get a "Parameter is not valid." exception when I read an image from my database?[^]

这篇关于从数据库加载图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！