public System.Drawing.Image ByteArrayToImage(byte[] byteArray)
{
MemoryStream img = new MemoryStream(byteArray);
System.Drawing.Image returnImage = System.Drawing.Image.FromStream(img);
return returnImage;
}
protected void ddComapanyFilter_SelectedIndexChanged(object sender, EventArgs e)
{
string id = ddlCountries.SelectedItem.Value;
string constr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM RetPDF WHERE id = @id",con);
cmd.Parameters.AddWithValue("@id", id);
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] bytes = (byte[])reader["Data"];
Image1.ImageUrl = ByteArrayToImage(bytes).ToString();
con.Close();
}
}
}
}