Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dbconn.Open();
- dbcomm = new OleDbCommand("SELECT [Champ Name], [DefaultImage] FROM BchampInfo ORDER BY [Champ Name] ASC ", dbconn);
- DataSet ds = new DataSet();
- OleDbDataAdapter sqa = new OleDbDataAdapter(dbcomm);
- sqa.Fill(ds, "allValues");
- List<Image> bmps = new List<Image>();
- for (int dp = 0; dp <= 118; dp++)
- {
- byte[] data = (byte[])ds.Tables[0].Rows[dp][1];
- var image = new BitmapImage();
- using (var mem = new MemoryStream(data))
- {
- mem.Position = 0;
- image.BeginInit();
- image.CreateOptions = BitmapCreateOptions.PreservePixelFormat;
- image.CacheOption = BitmapCacheOption.OnLoad;
- image.UriSource = null;
- image.StreamSource = mem;
- image.EndInit();
- }
- image.Freeze();
- Image imag = new Image();
- imag.Source = image;
- bmps.Add(imag);
- lstview1.ItemsSource = bmps;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement