Databases
StackOverflow2013
Postsdbo
POC#/WPF Retrieving images from database and displaying them
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POC#/WPF Retrieving images from database and displaying them
    primarykey
    data
    text
    <p>I need to retrieve the url of the image from the database, bind it to a business object, convert it into a bitmap image and map it into the resource dictionary. The resource dictionary is used as a library and I cannot change it.</p> <p>The database consists of one table that has three columns: id, name, url. It is the SQL CE 3.5 local database. I want to be able to show all images at once.</p> <p>What I managed to write:</p> <pre><code>using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Data; using System.Collections; using System.Collections.ObjectModel; using System.Windows.Media.Imaging; using System.Windows; using System.Windows.Media; namespace Library.Components { public class ComponentsList : ObservableCollection&lt;Components&gt; { public ComponentsList() { String connString = @"Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data Source=local_source"; String query = @"SELECT id, name, url FROM GraphicComponents"; // Fill the Set with the data using (SqlConnection conn = new SqlConnection(connString)) { try { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = query; conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { this.Add(new Components(rdr)); } } finally { if (conn.State != ConnectionState.Closed) conn.Close(); } } } } public class Components { int _componentID; string _name; BitmapImage _url; public Components(IDataRecord record) { _componentID = (int)record["id"]; _name = (string)record["name"]; _url = (string)record["url"]; //Code taken from a tutorial used to convert the url into BitmapImage CreatePhoto((byte[])record["url"]); } void CreatePhoto(byte[] photoSource) { _url = new System.Windows.Media.Imaging.BitmapImage(); System.IO.MemoryStream strm = new System.IO.MemoryStream(); int offset = 78; strm.Write(photoSource, offset, photoSource.Length - offset); // Read the image into the bitmap object _url.BeginInit(); _url.StreamSource = strm; _url.EndInit(); } public int ComponentID { get { return _componentID; } } public string Name { get { return _name; } } public BitmapImage Photo { get { return _url; } } } } </code></pre> <p>In the resource dictionary in XAML I have Images controls. The source of the image is hardcoded; but I need to retrieve it from the database.</p> <p>Thanks in advance for any help. The code is a mess and I'm sure that there is a simpler way of retrieving the URLs of the images from a database and map them into the resource dictionary.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USEVA
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POC#/WPF Retrieving images from database and displaying them
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POC#/WPF Retrieving images from database and displaying them
      1. USslugster
      1. VTFavorite
    3. VO
      singulars
      1. POC#/WPF Retrieving images from database and displaying them
      1. USTimores
      1. VTFavorite
    1. COWhat do you mean by map it into the resource dictionary?
      singulars
      1. POC#/WPF Retrieving images from database and displaying them
      1. USMichal Ciechan
    2. COIt seems that I commented on wrong post. I have the resource dictionary in XAML: <ResourceDictionary> <Image IsHitTestVisible="False" Stretch="Fill" ToolTip="Nuclear" Source="Library/image2.png" /> <Image IsHitTestVisible="False" Stretch="Fill" ToolTip="Plus" Source="Library/image1.png" /> </ItemsControl.Items> </s:Toolbox> </ResourceDictionary> As you can see the "urls" are hardcoded. I need a binding here.
      singulars
      1. POC#/WPF Retrieving images from database and displaying them
      1. USEVA
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload