load image from database to image control in wpf

Question

0.00/5 (No votes)

See more:

C#

try
{
    SqlConnection conn = new SqlConnection("Data Source=UDAY;Initial Catalog=Sample;Integrated Security=True");
    conn.Open();
    SqlCommand cmd = new SqlCommand("select id from testimage", conn);
    cmd.ExecuteNonQuery();
    if (image1.DataContext != null)
    {
                      return;
    }
    //using filestream object write the column as bytes and store it as an image
    foreach (DataRow dataRow in dataTable.Rows)
    {
        if (dataRow.ItemArray[0].ToString() == comboBox1.SelectedItem.ToString())
        {
            FileStream FS1 = new FileStream("c:\\image.jpg", FileMode.Create);
            byte[] blob = (byte[])dataRow.ItemArray[1];
            FS1.Write(blob, 0, blob.Length);
            FS1.Close();

            ImageSourceConverter imgs = new ImageSourceConverter();
                        
            image2.Stretch = Stretch.Fill;
            image2.DataContext = null;

        }
    }
}
catch (Exception ex)
{
    System.Windows.Forms.MessageBox.Show(ex.StackTrace);
}

I didn't get any errors, but the image is not loading. Can you help me?

Posted 20-Jan-11 23:34pm

udaykumar.k

Updated 21-Jan-11 4:05am

#realJSOP

v3

Add a Solution

Comments

#realJSOP 21-Jan-11 10:05am

I added WPF to your question tags

2 solutions

Solution 2

You are using ExecuteNonQuery. This does not return any rows, but any output parameters specified will be populated with data. You are not specifying any paramaters and your query is Select an ID.

Read the spec on ExecuteNonQuery to see this; http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx[^]

You should be executing a ExecuteReader and the query should include the necessary column containing the blob.

At present the blob won't have anything to write to the file.

Posted 21-Jan-11 3:57am

DaveAuld

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)

#realJSOP · Accepted Answer · 2011-01-21T04:03:00

You're also not setting the image source property to what you're hoping is the returned image.

I don't know if you need it or not, but I use this method to convert a byte[] array to an BitmapImage object:

C#

//--------------------------------------------------------------------------------
public static BitmapImage BitmapImageFromBytes(byte[] bytes)
{
   BitmapImage  image  = null;
   MemoryStream stream = null;
   try
   {
       stream = new MemoryStream(bytes);
       stream.Seek(0, SeekOrigin.Begin);
       System.Drawing.Image img = System.Drawing.Image.FromStream(stream);
       image = new BitmapImage();
       image.BeginInit();
       MemoryStream ms = new MemoryStream();
       img.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
       ms.Seek(0, SeekOrigin.Begin);
       image.StreamSource = ms;
       image.StreamSource.Seek(0, SeekOrigin.Begin);
       image.EndInit();
    }
    catch (Exception)
    {
       throw;
    }
    finally
    {
       stream.Close();
       stream.Dispose();
    }
    return image;
}