ASP.net对SQL server数据库里取image类型怎么取

Q： 对SQL   server数据库里取image类型怎么取???  

A：把aspx的html元素去掉，然后页面中调用以下函数。这个页面返回的就是图片

private   void  DownloadImage( string  FileID)
         ... {
             using  (System.Data.SqlClient.SqlConnection conn  =   new  System.Data.SqlClient.SqlConnection())
             ... {
                conn.ConnectionString  =   " ..... " ;
                conn.Open();

                 using (System.Data.SqlClient.SqlCommand command = conn.CreateCommand())
                 ... {

                    command.CommandText = string .Format( " select ImageSize,Image from tablexxx where id='{0}' " , FileID);

                    System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader();

                     try
                     ... {
                         if (reader.Read())
                         ... {
                    
                             int  size = reader.GetInt32( 0 );
                             byte [] buffer = new   byte [size];

                            reader.GetBytes( 1 , 0 ,buffer, 0 ,size);

                             this .Response.BinaryWrite(buffer);
                        }
                    }
                     catch (Exception  ex)
                     ... {
                         this .Response.Write(ex.Message);
                    }
                     finally
                     ... {
                        reader.Close();
                    }
                }
                conn.Close();
            }
        }