if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestFiles]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TestFiles]
GO
CREATE TABLE [dbo].[TestFiles] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[MyFileName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FileType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[MyFile] [image] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
showfile.aspx.cs 的内容:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Microsoft.Data.Odbc;
namespace WordApplication
{
/// <summary>
/// Summary description for showfile.
/// </summary>
public class showfile : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
string strFileName="myouttest.doc";
string sql="SELECT fileid, filetype,imgSize,imgData FROM t_imgs WHERE fileid = 'testid2'";
Microsoft.Data.Odbc.OdbcConnection conn = new OdbcConnection("dsn=est_back;uid=dba;pwd=;pwd=dbserver");
OdbcCommand cmd = new OdbcCommand(sql, conn);
conn.Open();
OdbcDataReader dr = cmd.ExecuteReader();
if(dr.Read())
{
Response.ContentType = (string)dr["filetype"];
Response.OutputStream.Write((byte[])dr["imgData"], 0,(int)dr["imgSize"]);
Response.End();
}
dr.Close();
conn.Close();