将图片转成二进制存入数据库,读的时候再转回来,我见过ASP的
formsize=request.totalbytes
formdata=request.binaryread(formsize)
bncrlf=chrB(13) & chrB(10)
divider=leftB(formdata,clng(instrb(formdata,bncrlf))-1)
datastart=instrb(formdata,bncrlf & bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
mydata=midb(formdata,datastart,dataend)'将值转为二进制Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "pic",conn,3,2
rs.addnew
rs("big").appendchunk mydata'添加到数据库
formsize=request.totalbytes
formdata=request.binaryread(formsize)
bncrlf=chrB(13) & chrB(10)
divider=leftB(formdata,clng(instrb(formdata,bncrlf))-1)
datastart=instrb(formdata,bncrlf & bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
mydata=midb(formdata,datastart,dataend)'将值转为二进制Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "pic",conn,3,2
rs.addnew
rs("big").appendchunk mydata'添加到数据库
解决方案 »
- sql语句 怎么读取 accsess
- 如何分出字符里哪些是汉字,哪些是字母,最后留下汉字
- 求个SQL查询语句,谢谢
- 求一sql语句
- 求助,删除一条记录,其余记录号自动排列。
- 如何使 float 类型 为 NULL 的 字段也能更新 ??????????
- 请问怎样管理放在异地服务器上的 SQL Server ?(急!在线等)
- 关于SQL创建文件夹
- 请问SQL Server中的备份设备和备份文件有什么关系和区别?
- MS SQL出现大量"阻塞者"是为什么?
- 分布查詢 急救!!小弟在線等待
- A,B两表结构同,有复合主索引(MB01+MB02),要找出A表中B表未有的数据(以主索引为表达式),应怎样写?,
Dim rs As New ADODB.Recordset
Dim stm As New ADODB.StreamPrivate Sub SavePictureToDB(cn As ADODB.Connection)
On Error GoTo EH
rs.Open "select ImagePath,ImageValue from tbl_Image", cn, adOpenKeyset, adLockOptimistic
CommonDialog1.ShowOpen
Text1.Text = CommonDialog1.FileName
With stm
.Type = adTypeBinary
.Open
.LoadFromFile CommonDialog1.FileName
End With
With rs
.AddNew
.Fields("ImagePath") = Text1.Text
.Fields("ImageValue") = stm.Read
.Update
End With
Set stm = Nothing
rs.Close
Set rs = Nothing
Exit Sub
EH: MsgBox Err.Description, vbInformation, "Error"
End Sub
Private Sub LoadPictureFromDB(cn As ADODB.Connection)
On Error GoTo EH
Dim strTemp As String
strTemp = "c:\temp.tmp" 'temp file
rs.Open "select ImagePath,ImageValue from tbl_image", cn, , , adCmdText
With stm
.Type = adTypeBinary
.Open
.Write rs("ImageValue")
.SaveToFile strTemp, adSaveCreateOverWrite
.Close
End With
Image1.Picture = LoadPicture(strTemp)
Set stm = Nothing
rs.Close
Set rs = Nothing
Exit Sub
EH: MsgBox Err.Description, vbInformation, "Error"
End Sub
是根据纸上的图片数据存在数据库里,然后再绘制成图
有谁做过吗?