How to load image from SQL Server into picture box?

by

You never uploaded the image contents to the database. That’s just the file name.

Say, as an example, that you have a file path to work with (it seems you do, given the question’s contents). In your application, you would upload this to the database following this format:

byte[] image = File.ReadAllBytes("D:\\11.jpg");

SqlCommand sqlCommand = new SqlCommand("INSERT INTO imageTest (pic_id, pic) VALUES (1, @Image)", yourConnectionReference);
sqlCommand.Parameters.AddWithValue("@Image", image);
sqlCommand.ExecuteNonQuery();

Please bear in mind that your pic field will more than likely need to change data type. A common type for this information is VARBINARY.

The next part is reading the file into a PictureBox. For this, you’ll need to SELECT the data out:

SqlDataAdapter dataAdapter = new SqlDataAdapter(new SqlCommand("SELECT pic FROM imageTest WHERE pic_id = 1", yourConnectionReference));
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]["pic"]);
    MemoryStream mem = new MemoryStream(data);
    yourPictureBox.Image= Image.FromStream(mem);
}

And that should be about it. You might want to do better safety checks, but this should help you get started.

More Related Contents:

  1. Translate Rectangle Position in Zoom Mode Picturebox
  2. How can I treat the circle as a control after drawing it? – Moving and selecting shapes
  3. A PictureBox Problem
  4. How to make picturebox transparent?
  5. Creating Custom Picturebox with Draggable and Resizable Selection Window
  6. How to draw on a zoomed image?
  7. Creating different brush patterns in c#
  8. copying free hand drawing from panel in visual studio 2013
  9. How can I get scrollbars on Picturebox
  10. How can I capture as bitmap only what a picturebox is displaying, without using “copy from screen”?
  11. How to rotate image in picture box
  12. Creating Wizards for Windows Forms in C#
  13. Make an Installation program for C# applications and include .NET Framework installer into the setup
  14. How to store int[] array in application Settings
  15. Application.Exit
  16. C# Adding button with value at runtime [closed]
  17. .NET, event every minute (on the minute). Is a timer the best option?
  18. How do I create a message box with “Yes”, “No” choices and a DialogResult?
  19. How to add new line into txt file
  20. Customizing OpenFileDialog
  21. How can I sync the scrolling of two multiline textboxes?
  22. Does the System.Windows.Forms.Timer run on a different thread than the UI?
  23. Synchronize Scroll Position of two RichTextBoxes?
  24. Capturing mouse events from every component
  25. how do i check if a printer is installed and ready using C#?
  26. Closing a form and then call another one
  27. How to compute the correct width of a digit in pixels?
  28. How to install a Font programmatically (C#)
  29. Custom Color Palette in Visual Studio Color Property Editor
  30. How do I get all controls of a form in Windows Forms?

Leave a Comment