Cannot Convet Sql Image To Byte[]

I have followed many examples found on this site, but still get an invalid cast execption when I attempt to run code below. the exception is thrown when I try to convert the sql image to a byte[] in the download section of the code.








//


// sqlUploadImage


//


this.sqlUploadImage.CommandText = "INSERT INTO Image_Table (Description, Type, Lenth, DocName) VALUES (@Description," +


" @Type, @Length, @DocName)";


this.sqlUploadImage.Connection = this.sqlConnection2;


this.sqlUploadImage.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Description", System.Data.SqlDbType.VarChar, 50, "Description"));


this.sqlUploadImage.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Type", System.Data.SqlDbType.VarChar, 50, "Type"));


this.sqlUploadImage.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Length", System.Data.SqlDbType.Int, 4, "Lenth"));


this.sqlUploadImage.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DocName", System.Data.SqlDbType.VarChar, 50, "DocName"));


this.sqlUploadImage.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Image", System.Data.SqlDbType.Image, 16, "ImgField"));


this.Button2.Click += new System.EventHandler(this.Button2_Click);


//


// sqlDownLoadImage


//


this.sqlDownLoadImage.CommandText = "SELECT Image_Table.* FROM Image_Table";


this.sqlDownLoadImage.Connection = this.sqlConnection2;





//upload file


private void Button1_Click(object sender, System.EventArgs e)


{


//Get the filename of the pdf file to be uploaded.


string strFilename = File1.PostedFile.FileName.Substring(File1.PostedFile.FileName.LastIndexOf("\") +1);





//Get the file type


string strFileType = File1.PostedFile.ContentType;





//Get the file size


int intImageSize = File1.PostedFile.ContentLength;





// Reads the Image


Stream ImageStream = File1.PostedFile.InputStream;





byte[] ImageContent = new byte[intImageSize + 1];


int intStatus = 0;


intStatus = ImageStream.Read(ImageContent, 0, intImageSize);





//Response.Write(strFilename.ToString());


//Response.Write("<br>Image Type: " + strFileType.ToString());


//Response.Write("<br>Image Size: "+intImageSize.ToString());





this.sqlUploadImage.Parameters["@Description"].Value = strFilename;


this.sqlUploadImage.Parameters["@Type"].Value = strFileType;


this.sqlUploadImage.Parameters["@Length"].Value = intImageSize;


this.sqlUploadImage.Parameters["@DocName"].Value = "TestPDF";


this.sqlUploadImage.Parameters["@Image"].Value = ImageContent;





try


{


this.sqlConnection2.Open();


this.sqlUploadImage.ExecuteNonQuery();





this.Label2.Text = "File Uploaded Successfully";


this.Button2.Visible = true;


}


catch(SqlException ex)


{


Response.Write(ex.ToString());


}


finally


{


this.sqlConnection2.Close();


}


}








//download file


private void Button2_Click(object sender, System.EventArgs e)


{


try


{


this.sqlConnection2.Open();


SqlDataReader r = this.sqlDownLoadImage.ExecuteReader(CommandBehavior.CloseConnection);








if(r.Read())


{





Response.ContentType = r["Type"].ToString();


byte[] image = (byte[])r["ImgField"];


Response.BinaryWrite(image);


}


}


catch(SqlException ex)


{


Response.Write(ex.ToString());


}


finally


{


this.sqlConnection2.Close();


}


}