有一个数据库,里面有一张表,有三个字段编号姓名简历,如果简历字段是OLE字段。在窗体上添加编号、姓名两个文本框。还有一个OLE控件为简历。两个命令按钮为添加与保存。
用data控件连接此数据库。将字段与data控件绑定。
下面的过程可否写成这样?sub 添加_click
data1.recordset.addnew
end sub
Private Sub 保存_Click()
Dim fn As Integer
fn = FreeFile
Open App.Path & "\wj.tmp" For Binary As fn
OLE1.FileNumber = fn
OLE1.Action = 11
Seek fn, 1
Call file_to_field(fn)
Close fn
Kill App.Path & "\wj.tmp"
Data1.Recordset.Update
MsgBox "保存完毕"
End SubSub file_to_field(fn1 As Integer)
Const blocksize = 20
Dim blocknum As Integer
Dim over As Long
Dim sz As String
blocknum = (LOF(fn1) - Seek(fn1) + 1) \ blocksize
over = (LOF(fn1) - Seek(fn1) + 1) Mod blocksize
sz = Space$(blocksize)
For i = 1 To blocknum
Get fn1, , sz
Data1.Recordset.Fields("resume").AppendChunk (sz)
Next i
sz = Space$(over)
Data1.Recordset.Fields("resume").AppendChunk (sz)
End Sub
用data控件连接此数据库。将字段与data控件绑定。
下面的过程可否写成这样?sub 添加_click
data1.recordset.addnew
end sub
Private Sub 保存_Click()
Dim fn As Integer
fn = FreeFile
Open App.Path & "\wj.tmp" For Binary As fn
OLE1.FileNumber = fn
OLE1.Action = 11
Seek fn, 1
Call file_to_field(fn)
Close fn
Kill App.Path & "\wj.tmp"
Data1.Recordset.Update
MsgBox "保存完毕"
End SubSub file_to_field(fn1 As Integer)
Const blocksize = 20
Dim blocknum As Integer
Dim over As Long
Dim sz As String
blocknum = (LOF(fn1) - Seek(fn1) + 1) \ blocksize
over = (LOF(fn1) - Seek(fn1) + 1) Mod blocksize
sz = Space$(blocksize)
For i = 1 To blocknum
Get fn1, , sz
Data1.Recordset.Fields("resume").AppendChunk (sz)
Next i
sz = Space$(over)
Data1.Recordset.Fields("resume").AppendChunk (sz)
End Sub
解决方案 »
- 很难的问题:文件记录集操作
- 因为mshflexgrid控件要求满足行数必须比固定行大1这个条件,可是当一行数据也没有时,我想只显示表头,不显示一个空行,如何可以实现呢?
- 没有自己的服务器,有没有办法从网络上获得一个准确的日期?
- 求教高手:关于托盘程序,如何不让出现多个相同的托盘图标??
- mshflexgrid控件如何每行加入checkbox
- 求助:解决程序运行后,单击某个菜单项时为何会莫名其妙地退出程序?
- 怎么用HScrollBar控件来控制窗体的透明度,或用其它控件??
- ~~~~~~~~~555,救命啊,如何识别出Range对象里面具有不同样式信息的子元素
- Cool,手机轰炸机!绝对正点!
- 如何将Common control header 建立在Listbox或Textbox上?
- vb群6537626 才57个人. 大家加啊.不是我创的,是上面的网友
- 哪里可以下载Vb5.0简体中文的版的帮助文件,要以前那种"hlp"文件格式的,不要Msdn那种
能否将sz改为字节数组
sz()as byte
然后将sz = Space$(blocksize)替换为redim sz(blocksize)
sz = Space$(over)替换为redim sz(over)