Advertisement
Guest User

Untitled

a guest
Aug 28th, 2014
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. dbconn.Open();
  2. dbcomm = new OleDbCommand("SELECT [Champ Name], [DefaultImage] FROM BchampInfo ORDER BY [Champ Name] ASC ", dbconn);
  3. DataSet ds = new DataSet();
  4. OleDbDataAdapter sqa = new OleDbDataAdapter(dbcomm);
  5. sqa.Fill(ds, "allValues");
  6.  
  7. List<Image> bmps = new List<Image>();
  8.  
  9. for (int dp = 0; dp <= 118; dp++)
  10. {
  11. byte[] data = (byte[])ds.Tables[0].Rows[dp][1];
  12. var image = new BitmapImage();
  13. using (var mem = new MemoryStream(data))
  14. {
  15. mem.Position = 0;
  16. image.BeginInit();
  17. image.CreateOptions = BitmapCreateOptions.PreservePixelFormat;
  18. image.CacheOption = BitmapCacheOption.OnLoad;
  19. image.UriSource = null;
  20. image.StreamSource = mem;
  21. image.EndInit();
  22. }
  23. image.Freeze();
  24. Image imag = new Image();
  25. imag.Source = image;
  26. bmps.Add(imag);
  27. lstview1.ItemsSource = bmps;
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement