江湖告急请各位帮助!

[tinghuyang]

如何在SqlServer中存取图片!

[Dugu_Niu]

请参考
http://www.csdn.net/Develop/article/15%5C15001.shtm

[panyee]

http://www.tongyi.net/main.asp?menu=2&title=%CD%F8%C2%E7%B1%E0%B3%CC

[canyqf]

保存图片字段为Image类型
图片字段名为bmp

dim bmp as drawing.bitmap '图片
dim ds as data.dataset '数据集
dim da as data.sqlclient.sqldataadapter '适配器
......

存：
dim ms as new io.memorystream()
bmp.save(ms,bmp.rawformat)
dim byts as byte()=ms.toarray()
dim dr as data.datarow=ds.tables(0).newrow()
dr.beginedit()
dr.item("bmp")=byts
dr.endedit
da.update(ds)
ms.close()

取:
da.fill(ds)
dim byts as byte()=ds.table(0).rows(0).item("bmp")
dim ms as new io.memorystream(byts)
bmp=drawing.image.fromimage(ms)
ms.close()

[canyqf]

da.update(ds)
之前漏了
ds.tables(0).rows.add(dr)

[canyqf]

还有
bmp=drawing.image.fromimage(ms)这句写错了。。。
应该是
bmp=drawing.image.fromstream(ms)

[cnhgj]

http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=6404