How do I solve this line

Question

1.00/5 (2 votes)

See more:

Hi, how do you retrieve a image datatype from database and load the image to your label.

In my database, the image column is BINARY DATA

I tried this and it shows system.byte[]

//code for retrieving
string pt = dr["Photo"].ToString();
image = Encoding.ASCII.GetBytes(pt);

Posted 2-Jun-14 2:23am

anoym0us

Updated 2-Jun-14 2:30am

v3

Add a Solution

Comments

TrushnaK 2-Jun-14 8:26am

What you want to ask? Improve your question

[no name] 2-Jun-14 8:28am

You would do a tiny bit of research and write some code.

Raul Iloc 2-Jun-14 8:34am

Which type of application do you use? ASP.NET MVC, WCF, Windows Froms?

anoym0us 2-Jun-14 8:37am

ASP.NET MVC

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ravi Bhavnani · Answer 1 · 2014-06-02T02:33:00

Here's one way to retrieve the binary field and convert it to an image.

SqlConnection conn = ...;
SqlCommand cmd = new SqlCommand ("SELECT img FROM images WHERE imgId = 42", conn);
SqlDataAdapter dataAdapter = new SqlDataAdapter();
DataSet dataSet = new DataSet();
dataAdapter.Fill (dataSet);
if (dataSet.Tables[0].Rows.Count == 1) {
    Byte[] data = new Byte[0];
    data = (Byte[])(dataSet.Tables[0].Rows[0]["img"]);
    using (MemoryStream ms = new MemoryStream (data)) {
      myLabel.Image= Image.FromStream (ms);
    }
}

/ravi

OriginalGriff · Answer 2 · 2014-06-02T02:36:00

If you don't understand why, then the chances are both bits of your code are wrong: the INSERT into the database and the SELECT to fetch the image back.

Have a look here: Why do I get a "Parameter is not valid." exception when I read an image from my database?[^] - it explains what you are doing wrong, and shows you how to do it properly.

Sanju TV · Answer 3 · 2014-06-02T02:34:00

Use this function to retrieve image from database

Create a handler file and use this code.

VB

Public Function ShowEmpImage(ByVal ID As Integer) As Stream
        Try
            con = New SqlConnection(DB.GetCon)
            Dim sql As String = "SELECT top 1 Image  FROM tablname WHERE ID= @ID"
            Dim cmd As SqlCommand = New SqlCommand(sql, con)
            cmd.CommandType = CommandType.Text
            cmd.Parameters.AddWithValue("@ID", ID)
            con.Open()
            Dim img As Object = cmd.ExecuteScalar()
            Return New MemoryStream(CType(img, Byte()))

        Catch
            Return Nothing
        Finally
            con.Close()
        End Try
    End Function

How do I solve this line

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0