Pls Help me--------------
I use ASP(C#.NET) and oracle.
When i retrive image from database .it display error message...
System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.
my code in the show button is.pls anybody help me ,how to retrive and display the image
protected void btnshow_Click(object sender, EventArgs e)
{
DataTable dt = ds.Tables[0];
MemoryStream stream = new MemoryStream();
foreach (DataRow dr in dt.Rows)
{ if (dr[0].ToString() == drpeno.SelectedItem.ToString())
{
byte[] blob = (byte[])dr[1];
stream.Write(blob,0,blob.Length);
Bitmap bitm = new Bitmap(stream);
Response.ContentType = "image/jpeg";
bitm.Save(Response.OutputStream,ImageFormat.Jpeg);
Label1.Text = dr[0].ToString();
// pcimage.ImageUrl = "~/showimage.ashx?id=" + id;
}
}
}