有谁知道如何将图片保存到sdf数据库吗?
在vb.net2008中创建了一个本地的sdf数据库,其中有一个字段picture的类型为image。现在要向picture中添加图片,我的代码为:
Dim fs As FileStream
Dim oplg As OpenFileDialog
Dim sqlceconn As SqlCeConnection
Dim sqlcecomm As SqlCeCommand
oplg = New OpenFileDialog
oplg.Filter = "(*.bmp)|*.bmp|(*.jpg)|*.jpg"
oplg.ShowDialog()
fs = New FileStream(oplg.FileName, FileMode.Open, FileAccess.Read)
PictureBox1.Image = Image.FromFile(path)
Dim Data(fs.Length) As Byte
fs.Read(Data, 0, Int(fs.Length))
sqlcecomm = New SqlCeCommand
sqlcecomm.CommandText = "insert into table1(picture) values (@picture)"
Dim prm3 As New SqlCeParameter("@picture", SqlDbType.Image, Int(fs.Length), ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, Data)
sqlcecomm.Parameters.Add(prm3)
sqlcecomm.Connection = sqlceconn
sqlcecomm.ExecuteNonQuery()
fs.Close()
现在一运行就会有“字节数组截断到长度为XXX”的错误。请大家帮帮忙吧....
[解决办法]
没用过,帮顶...
[解决办法]
.sdf保存片?.
[解决办法]
是SDF啊。我也学习。
SqlCeCommand
[解决办法]