如何将文件存取到SQL数据库 比如.txt .asp .rmf 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 '网上搜来转的'原贴地址 http://space.itpub.net/15453304/viewspace-466110'添加时用rs.AddNew()然后将文件的二进制数据赋值给数据库表中的二进制字段。'读取时用ADODB.Stream,这个我也没用过。Dim mstream As ADODB.StreamPrivate Sub Command1_Click()TxtSQL = "select * from aaa"Set Mrc = ExeSQL(TxtSQL, MsgTxt, "sql")Mrc.AddNewMrc.Fields("i_fname") = "001.jpg"Set mstream = New ADODB.Streammstream.Type = adTypeBinarymstream.Openmstream.LoadFromFile "Q:\像片\001.jpg"Mrc.Fields("i_file").Value = mstream.ReadMrc.UpdateSet Mrc = Nothingset mstream=nothingEnd SubPrivate Sub Command2_Click()TxtSQL = "select * from aaa"Set Mrc = ExeSQL(TxtSQL, MsgTxt, "sql")Mrc.Fields("i_fname") = "001.jpg"Set mstream = New ADODB.Streammstream.Type = adTypeBinarymstream.Openmstream.Write Mrc.Fields("i_file")mstream.SaveToFile "Q:\像片\00a1.jpg", adSaveCreateOverWriteSet Mrc = Nothingset mstream=nothingEnd Sub 如何通过hwnd获取控件 请问Rs.close 和set Rs=Nothing的区别 关于文件路径的问题 关于VB把数据插入SQL表的简单问题!急!急!急! 请教DATA REPORT 打印多页内容如何实现 关于如何插入flash动画的问题? 一个有趣的编程题大家帮忙做做看 每一个有一个等级, 是怎么算出来的? 关于ftp传输的问题 VB如何打开外部连接 紧急求助,控件注册不上怎么回事? 请各位老师帮忙看看存在的错误,谢谢
'原贴地址 http://space.itpub.net/15453304/viewspace-466110
'添加时用rs.AddNew()然后将文件的二进制数据赋值给数据库表中的二进制字段。
'读取时用ADODB.Stream,这个我也没用过。Dim mstream As ADODB.Stream
Private Sub Command1_Click()
TxtSQL = "select * from aaa"
Set Mrc = ExeSQL(TxtSQL, MsgTxt, "sql")
Mrc.AddNew
Mrc.Fields("i_fname") = "001.jpg"
Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.LoadFromFile "Q:\像片\001.jpg"
Mrc.Fields("i_file").Value = mstream.Read
Mrc.Update
Set Mrc = Nothingset mstream=nothing
End SubPrivate Sub Command2_Click()
TxtSQL = "select * from aaa"
Set Mrc = ExeSQL(TxtSQL, MsgTxt, "sql")
Mrc.Fields("i_fname") = "001.jpg"
Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.Write Mrc.Fields("i_file")
mstream.SaveToFile "Q:\像片\00a1.jpg", adSaveCreateOverWrite
Set Mrc = Nothingset mstream=nothing
End Sub