Sql Server中Image类型字段在VB.NET中的读写操作

Sql Server中Image类型字段在VB.NET中的读写操作(1)

1.图片文件写入
            Dim tmpImg As image                    
            Dim r As DataRow                         
            Dim ms As New MemoryStream    
            Dim data() As Byte                         

            r = myDataSet.Tables(myTableName).NewRow
            tmpImg = Image.FromFile("c:\xxx.jpg")
            tmpImg.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg)
            tmpImg.Dispose()
            ReDim data(ms.Length)
            ms.Position = 0
            ms.Read(data, 0, System.Convert.ToInt32(ms.Length))

            ...
            ...          
            r("pic") = data
            myDataSet.Tables(myTableName).Rows.Add(r)
            ...

2.图片数据的读出