<%Set Upload=Server.createobject("Persits.Upload.1") Count=Upload.Save("e:\aspupload") on error resume next set FileObj=Upload.Files("FileUpload") SQL="insert into upLoadFile (Title,FileName,Content) values ('"&FileObj.Path&"','"&FileObj.Path&"',?)" response.write SQL FileObj.ToDatabase "DSN=FileUpload;UID=sa;",SQL if Err<>0 then Response.write "Error Saving the file:"&Err.Description else FileObj.delete response.write "Success!" end if %>
从数据库中读取文件内容并发送给客户端浏览器
从数据库中读取内容在发送给浏览器之前,首先必须让浏览器知道内容的数据类型,这通过向客户端发送ContentType描述实现。为简单起见,这里假设发送的内容是Word文档,并且显示最新插入的记录。源文件如下: 客户端源文件为uploadToDB.htm(同上一部分的客户端文件)。 服务器端源文件(readFile.asp): <%Response.Expires = 0 response.buffer=true%> <%response.clear Response.ContentType = "application/msword" set conn=server.createobject("adodb.connection") conn.open "DSN=FileUpload;UID=sa;" set rs1=conn.execute("select maxid=max(id) from uploadFile") SQL="select * from uploadFile where id="&rs1("maxid") set rs=conn.execute(SQL) Response.BinaryWrite rs("Content") rs.close rs1.close conn.close Response.End %>