第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定
已解決430363個(gè)問(wèn)題,去搜搜看,總會(huì)有你想問(wèn)的

將圖像存儲(chǔ)到數(shù)據(jù)庫(kù)Blob;從數(shù)據(jù)庫(kù)檢索到Picturebox

將圖像存儲(chǔ)到數(shù)據(jù)庫(kù)Blob;從數(shù)據(jù)庫(kù)檢索到Picturebox

偶然的你 2019-12-06 14:42:59
您好,我在較早之前發(fā)布了此內(nèi)容,并獲得了一些幫助,但仍然沒(méi)有有效的解決方案。由于最后的問(wèn)與答,我確定我的“保存到數(shù)據(jù)庫(kù)”代碼以及“檢索到圖片”代碼有問(wèn)題。即使我手動(dòng)將圖片保存在數(shù)據(jù)庫(kù)中,它也不會(huì)恢復(fù)。這是我從網(wǎng)絡(luò)上的3或4個(gè)示例中修補(bǔ)而成的代碼。理想情況下,如果有人擁有一些已知的良好代碼,并且可以指導(dǎo)我這樣做,那將是最好的。    Dim filename As String = txtName.Text + ".jpg"    Dim FileSize As UInt32    Dim ImageStream As System.IO.MemoryStream    ImageStream = New System.IO.MemoryStream    PbPicture.Image.Save(ImageStream, System.Drawing.Imaging.ImageFormat.Jpeg)    ReDim rawdata(CInt(ImageStream.Length - 1))    ImageStream.Position = 0    ImageStream.Read(rawdata, 0, CInt(ImageStream.Length))    FileSize = ImageStream.Length    Dim query As String = ("insert into actors (actor_pic, filename, filesize) VALUES    (?File, ?FileName, ?FileSize)")    cmd = New MySqlCommand(query, conn)    cmd.Parameters.AddWithValue("?FileName", filename)    cmd.Parameters.AddWithValue("?FileSize", FileSize)    cmd.Parameters.AddWithValue("?File", rawData)    cmd.ExecuteNonQuery()    MessageBox.Show("File Inserted into database successfully!", _    "Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk)![在此處輸入圖片描述] [1]' * **使用以下代碼接收到圖片框:  Private Sub GetPicture()    'This retrieves the pictures from a mysql DB and buffers the rawdata into a memorystream     Dim FileSize As UInt32    Dim rawData() As Byte    Dim conn As New MySqlConnection(connStr)    conn.Open()    conn.ChangeDatabase("psdb")    Dim cmd As New MySqlCommand("SELECT actor_pic, filesize, filename FROM actors WHERE actor_name = ?autoid", conn)    Cmd.Parameters.AddWithValue("?autoid", Actor1Box.Text)    Reader = cmd.ExecuteReader    Reader.Read()    'data is in memory     FileSize = Reader.GetUInt32(Reader.GetOrdinal("filesize"))    rawData = New Byte(FileSize) {}    'get the bytes and filesize     Reader.GetBytes(Reader.GetOrdinal("actor_pic"), 0, rawData, 0, FileSize)    Dim ad As New System.IO.MemoryStream(100000)    ' Dim bm As New Bitmap    ad.Write(rawData, 0, FileSize)
查看完整描述

3 回答

  • 3 回答
  • 0 關(guān)注
  • 636 瀏覽
慕課專欄
更多

添加回答

舉報(bào)

0/150
提交
取消
微信客服

購(gòu)課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)