1protected void Page_Load(object sender,EventArgs e)
 2...{ /**////创建链接 
 3SqlConnection myConnection = new SqlConnection(
 4ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
 5/**////定义SQL语句 
 6string cmdText = "SELECT * FROM PictureTab WHERE PictureID='1'";
 7/**////创建Command 
 8SqlCommand myCommand = new SqlCommand(cmdText,myConnection);
 9/**////定义DataReader 
10SqlDataReader dr = null;
11try
12...{ /**////打开链接 
13myConnection.Open();
14/**////读取数据 
15dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
16}
17catch(SqlException ex)
18...{ /**////抛出异常 
19throw new Exception(ex.Message,ex);
20}
21/**////定义保存数据的字节数组 
22byte[] Data = null;
23while(dr.Read())
24...{ /**////读取数据 
25Data = (byte[])dr["Data"];
26Response.ContentType = dr["Type"].ToString();
27}
28dr.Close();
29//显示图片数据 
30this.EnableViewState = false;
31/**////输出文件头 
32Response.AppendHeader("Content-Length",Data.Length.ToString());
33/**////输出文件的数据 
34Response.BinaryWrite(Data);
35/**////结束输出 
36Response.End();
37}