做数据库关联呀
如:
表"a1"存储记录
关联号(key)
其它字段
表“a2”存储图片
序号(key)
关联号
图片内容
如:
表"a1"存储记录
关联号(key)
其它字段
表“a2”存储图片
序号(key)
关联号
图片内容
解决方案 »
- vb6.0 mscomm控件接收大量数据
- 求教!一个winsock接收数据的问题。
- COMBOBOX控件,可否下拉显示两列,但是选中后,只在TEXT中出现选中一行的第一列?
- 求教数据库问题,高手请进
- vc dll中定义了使用了MFC函数,在VB中调用时总是出现“内存某地址不能为written”。的错误
- 一个文件复制 input 使用的问题 大哥们帮忙 急
- vb winsock多连接问题
- 如何把 recordset 的某列值連成 string , 要求最快速!
- 怎样得到win2000 server上的所有的用户信息呢,比如用户名。
- 今天发奖金了,爽,给大家散分
- 怎么回事
- VB中如何通过.ini文件存取用户设置?
http://expert.csdn.net/Expert/topic/1432/1432192.xml?temp=.7071497
Private Function DatabaseToFile(ByVal DataField As ADODB.Field, ByVal vSaveAs As String, ByVal vFileExpendName As String) As String
Dim fnum As Long, bytesleft As Long, bytes As Long
Dim lSumSize As Long, lNowSize As Long
Dim tmp() As Byte
On Error GoTo ErrHandleDatabaseToFile
If Trim(vSaveAs) = "" Then
DatabaseToFile = GetTempFileName(vFileExpendName)
Else
DatabaseToFile = Trim(vSaveAs)
End If
fnum = FreeFile
Open (DatabaseToFile) For Binary As fnum
bytesleft = DataField.ActualSize
lSumSize = CLng(bytesleft / 8192)
Do While bytesleft
bytes = bytesleft
If bytes > 8192 Then bytes = 8192
tmp = DataField.GetChunk(bytes)
Put #fnum, , tmp
bytesleft = bytesleft - bytes
lNowSize = lNowSize + 1
RaiseEvent TransmitData(lNowSize, lSumSize, False)
Loop
Close #fnum
Exit Function
ErrHandleDatabaseToFile:
DatabaseToFile = ""
Err.Clear
End FunctionPrivate Function FileToDatabase(ByVal vDataField As ADODB.Field, ByVal vFileName As String)
Dim fnum As Long, bytesleft As Long, bytes As Long
Dim lSumSize As Long, lNowSize As Long
Dim tmp() As Byte
On Error GoTo ErrHandleFileToDatabase
fnum = FreeFile
Open vFileName For Binary As fnum
bytesleft = LOF(fnum)
lSumSize = CLng(bytesleft / 8192)
Do While bytesleft
bytes = bytesleft
If bytes > 8192 Then bytes = 8192
ReDim tmp(1 To bytes) As Byte
Get #fnum, , tmp
vDataField.AppendChunk tmp
bytesleft = bytesleft - bytes
lNowSize = lNowSize + 1
DoEvents
RaiseEvent TransmitData(lNowSize, lSumSize, True)
Loop
Close #fnum
Exit Function
ErrHandleFileToDatabase:
Err.Clear
End Function