Display binary image without using generic http handler

Question

I have to display student name and image on my web page while selecting student id from the drop down list. The image is stored in var binary format on db. How can I retrieve the image and display on image box. The given below code is only shows the student first name and last name. How can I display the image without using http generic handler page? Please help me.

Code:

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataSet1TableAdapters.TextBoxTableTableAdapter tx;
        tx = new DataSet1TableAdapters.TextBoxTableTableAdapter();
        DataTable dt = new DataTable();
        dt = tx.GetstudData(int.Parse(DropDownList1.SelectedValue));

        foreach (DataRow row in dt.Rows)
        {
            TextBox1.Text = (row["FirstName"].ToString());
            TextBox2.Text = (row["SecondName"].ToString());
        }
    }

SQL Query:

SELECT FirstName, SecondName, StudentImage FROM TextBoxTable WHERE (Id = @Id)

Aspx Source:

<div>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Image ID="Image1" runat="server" />
</div>

Data Base:

enter image description here

You can't. At least you can't easily. There is a way to embed images in web pages: websiteoptimization.com/speed/tweak/inline-images but it would be infinitely easier to write the handler you didn't want to write. If you were using MVC and WebAPI it would be easier still. — Ian Mercer
– Ian Mercer, Commented Oct 17, 2014 at 5:02
@IanMercer : OK. then how can I add generic http handler for above code. I want to display the image by selecting id from the drop down list. Can you please post sample code for this code. — Vipin
– Vipin, Commented Oct 17, 2014 at 5:14

Shivam Bareria · Accepted Answer · 2014-10-17 05:20:41Z

1

Code

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    DataSet1TableAdapters.TextBoxTableTableAdapter tx;
    tx = new DataSet1TableAdapters.TextBoxTableTableAdapter();
    DataTable dt = new DataTable();
    dt = tx.GetstudData(int.Parse(DropDownList1.SelectedValue));
    foreach (DataRow row in dt.Rows)
    {
        TextBox1.Text = (row["FirstName"].ToString());
        TextBox2.Text = (row["SecondName"].ToString());  
        byte[] barrImg = (byte[])(row["StudentImage"].ToString());
        string base64String = Convert.ToBase64String(barrImg , 0, barrImg.Length);
        Image1.ImageUrl = "data:image/png;base64," + base64String;
    }
}'

I think this code will work for you

answered Oct 17, 2014 at 5:20

Shivam Bareria

842 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vipin Over a year ago

While using your code getting an error. The error is Cannot convert type 'string' to 'byte[]'

Arindam Nayak Over a year ago

use this link stackoverflow.com/questions/472906/… to convert string to byte array

Collectives™ on Stack Overflow

Display binary image without using generic http handler

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related