这个应该跟读一般的二进制文件没有什么区别。读出来之后设置一下Response.ContentType属性应该就可以了。给个取图片的例子你:
Dim connstr As String = "Integrated Security=SSPI;
Initial Catalog=Northwind;Data Source=SERVER\netsdk"
Dim cnn As New SqlConnection(connstr)
Dim cmd As New SqlCommand
("select * from images where id="
& Request.QueryString("id"), cnn)
cnn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader()
dr.Read()
Dim bindata() As Byte = dr.GetValue(1)
Response.BinaryWrite(bindata)
Dim connstr As String = "Integrated Security=SSPI;
Initial Catalog=Northwind;Data Source=SERVER\netsdk"
Dim cnn As New SqlConnection(connstr)
Dim cmd As New SqlCommand
("select * from images where id="
& Request.QueryString("id"), cnn)
cnn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader()
dr.Read()
Dim bindata() As Byte = dr.GetValue(1)
Response.BinaryWrite(bindata)
设置为
application/msword这样就可以实现用户下载不知道有没有方法实现,网页上编辑,然后提交到数据库保存