vb.net中将图片存入SQL Server 2000并能读出来使用

前端之家收集整理的这篇文章主要介绍了vb.net中将图片存入SQL Server 2000并能读出来使用前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

数据库中建一个Img表,其中包含一个Img字段,类型为Image或Binary

'将Bytes存入数据库
Dim Stream As New IO.MemoryStream
PictureBox1.Image.Save(Stream,System.Drawing.Imaging.ImageFormat.Bmp)
Stream.Flush()
Dim Bytes As Byte() = Stream.ToArray
Dim sql As String = "insert into Img values (@bytes) "
Dim command As New sqlClient.sqlCommand(sql,Connection)
command.Parameters.Add("@bytes",sqlDBType.Binary).Value = Bytes
command.ExecuteNonQuery


'读取
Dim Command As New sqlClient.sqlCommand(sql,Connection)
Dim Reader As sqlClient.sqlDataReader = Command.ExecuteReader()
Dim Bytes as Byte()=Reader.Item("Img")
Dim mStream As New IO.MemoryStream
mStream.Write(Bytes,Bytes.Length)
mStream.Flush()
Dim Img As New Bitmap(mStream)
PictureBox1.Image = Img

猜你在找的VB相关文章