vb.net 中如何将图片保存到SQL数据库

2025-02-27 01:18:36

推荐回答（3个）

回答（1）：

#Region "二进制文件的存储函数" Public Function BinaryToFile(ByRef TableRowColItem As Object, ByVal FileName As String) As Boolean Dim data As Byte() = TableRowColItem
Dim myfilestream As New System.IO.FileStream(FileName, IO.FileMode.Create)
myfilestream.Write(data, 0, data.Length)
myfilestream.Close()
Return True
End Function Public Function BinaryToImage(ByRef TableRowColItem As Object, ByRef image As Image) As Boolean Dim data As Byte() = TableRowColItem Dim imgStream As New System.IO.MemoryStream '(data)
imgStream.Write(data, 0, data.Length)
image = System.Drawing.Image.FromStream(imgStream)
imgStream.Close()
imgStream.Dispose() Return True
End Function
Public Function BinaryFromFile(ByVal FileName As String, ByRef TableRowColItem As Object) As Boolean Using myfilestream As New FileStream(FileName, FileMode.Open, FileAccess.Read)
Dim data() As Byte
ReDim data(myfilestream.Length - 1)
myfilestream.Read(data, 0, myfilestream.Length)
myfilestream.Close()
TableRowColItem = data End Using
Return True
End Function Public Function BinaryFromImage(ByRef Image As Image, ByRef TableRowColItem As Object) As Boolean
Dim imgStream As New MemoryStream
Dim b As New Bitmap(Image) b.Save(imgStream, System.Drawing.Imaging.ImageFormat.Jpeg) Dim data As Byte() = imgStream.GetBuffer
TableRowColItem = data
data = TableRowColItem
imgStream.Close()
imgStream.Dispose() Return True
End Function Public Function BinaryFromImage(ByVal Image As Image, ByRef TableRowColItem As Object, ByVal imgFormat As System.Drawing.Imaging.ImageFormat) As Boolean
Dim imgStream As New MemoryStream
'Image.Save(imgStream, imgFormat)
'Dim b As New Bitmap(Image)
'b.Save("c:\a.bmp", imgFormat)
'b.Save("c:\a.bmp", imgFormat) Dim data As Byte() = imgStream.GetBuffer TableRowColItem = data
data = TableRowColItem
imgStream.Close()
Return True
End Function

#End Region

回答（2）：

分两步1.把文件上传到你的项目里2.把文件名记录到数据库，使用时调用数据库里的图片名再加图片的路径找到图片就行了

回答（3）：

都是只保存路径的，把图片放到一个专用的文件夹下，读取的时候，从路径得图片

最新问答

小米6 怎么禁用卡1或卡2

现在戴尔是不是在找高中毕业生当戴尔实习员？最近空间好多卖戴尔电脑的

跪求松下NV-GS78摄影机的驱动程序

这种发型叫什么发型啊，要怎么和剪发师说

晚上失眠睡不着，头疼的厉害，有没有缓解失眠的方法呢？

那些是发物

"为了一切学生，为了学生的一切，一切为了学生。”这三个“一切”分别有什么含义？

脸上和身上长类似于痘痘的脓包

男人到底怎么样对待自己的感情 ?

怎么设置金立手机视频打开方式？