Loading Image through label

Question

I am trying to load an image through label using this code

private void getData()
    {
        SqlConnection conn = new SqlConnection("Data Source = localhost\\SQLEXPRESS;Initial Catalog = MejOnlineManagementDB00;Integrated Security=True;");
        conn.Open();
        SqlCommand sqlCmd = new SqlCommand(@"SELECT empName,empLname,empMi,empImage
                                            FROM employees
                                            WHERE empName = '"+ ddlAvail.SelectedItem.Value.ToString() +"'", conn);
        SqlDataReader rdr = sqlCmd.ExecuteReader();

        if (rdr.HasRows)
        {
            while (rdr.Read())
            {
                lblName.Text = rdr.GetValue(0).ToString(); 
                lblLname.Text = rdr.GetValue(1).ToString();
                lblMi.Text = rdr.GetValue(2).ToString();
                lblImage.Text = "<img runat='server' src='" + rdr.GetValue(3).ToString() + "'></img>";
            }
        }
        conn.Close();
    }

every time I select a dropdownlist value it generates me set of sql data.My only problem is the image.Cause it wont load any image at all.The filepath on my visual studio and image name is correct. This is an example of my image ../Images/Profile/logo.jpg I save the images filepath on my database.

what is your image stored as in the server? If it's a byte array see http://stackoverflow.com/questions/3801275/how-to-convert-image-in-byte-array. — Barry O'Kane, Apr 20 '16 at 10:56
@BarryO'Kane its jpg I think or any image file extension.Im using the filepath to pull the specific name of the image in the server using sql. — rai nalasa, Apr 20 '16 at 11:02
@jamiedanq it wont show the image.My file path and filename is correct. — rai nalasa, Apr 20 '16 at 11:06
@jamiedanq I see so I need to change the value type of my label? — rai nalasa, Apr 20 '16 at 11:15
@jamiedanq I'll try this.But in this way I couldnt adjust its width and size using my css? — rai nalasa, Apr 20 '16 at 11:21
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/109664/discussion-between-rai-nalasa-and-jamiedanq). — rai nalasa, Apr 20 '16 at 11:28

jamiedanq · Accepted Answer · 2016-04-20T15:50:09.883

1

Your code looks fine

Make sure the file path your are retrieving from the database exists and the path isn't returning any unwanted characters.

That is:

rdr.GetValue(3).ToString()  //should return the right path (string)

It should be fine. Hope this helped

edited Apr 20 '16 at 15:50

answered Apr 20 '16 at 13:46

jamiedanq

967
7
12

@barry I had just changed my my file parh turns out it s wrong.Jamiedanq helped me. – rai nalasa Apr 20 '16 at 21:07

score 0 · Answer 2 · edited May 23 '17 at 12:16

0

It won't ever show the image because all that your code is doing is setting the text on the label.

If you want to display the image try this , or this.

edited May 23 '17 at 12:16

Community

1
1

answered Apr 20 '16 at 11:11

Barry O'Kane

1,189
7
12

Loading Image through label

2 Answers2