Web Forms :: Making A ShowImage Page - Pulling The Image From A SQL Table

The Response.BinaryWrite( does not like what I am giving it.

I am making a ShowImage page pulling the image from a SQL table.

Here is where I am at the moment:

protected void Page_Load(object sender, EventArgs e)
{
string myConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection objConnection = new SqlConnection(myConnection);
objConnection.Open();
SqlCommand objCommand = new SqlCommand("SELECT TOP (1) NEWID() AS row,ImageID, ImageName, ImageType, ImageData FROM ImageTable Order by Row", objConnection);
objCommand.CommandType = CommandType.Text;
SqlDataReader objReader = objCommand.ExecuteReader();
if (objReader.Read() == true)
{
Response.ContentType = objReader["ImageType"].ToString();
Response.BinaryWrite(objReader["ImageData"]);
}
// RotateImage.ImageUrl = (string)objReader["url"];
// RotateImage.ImageUrl = (string)objReader["ImageData"];
// Response.ContentType = objReader["MIMEType"].ToString();
// Response.BinaryWrite(objReader["ImageData"]);
objReader.Close();
objConnection.Close();
}