When I compile and run this code nothing happens and with no OUTPUT? Nothing happens and doesn't gives any error message?
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"];
byte[] bytes = (byte[])reader["Data"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
Image i = this.Image1;
i.ImageUrl = base64String;
//Image1.ImageUrl = "data:image/png;base64," + base64String;
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/pdf";
Response.Flush();
Response.End();
con.Close();
}
}
}
<asp:DropDownList ID="ddlCountries" AppendDataBoundItems="true" EnableViewState="true" AutoPostBack="True" runat="server" OnSelectedIndexChanged="ddComapanyFilter_SelectedIndexChanged"><asp:ListItem value="0">Please Select PDF Files</asp:ListItem>
</asp:DropDownList>
<hr />
<div>
<asp:Image ID="Image1" runat="server" ImageUrl="" />
