private void flp_Pic_DragDrop(object sender, DragEventArgs e) { try { DeliciousEntities dbcontext = new DeliciousEntities(); if (CountPic > 0) { IngID = Convert.ToInt32(this.dataGridView1.Rows[this.bindingSource1.Position].Cells["食材編號"].Value); string[] filenames = (string[])(e.Data.GetData(DataFormats.FileDrop)); for (int i = 0; i < filenames.Length && CountPic > 0; i++) { System.IO.MemoryStream ms = new System.IO.MemoryStream(); Image.FromFile(filenames[i]).Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] bytes; bytes = ms.GetBuffer(); Merchandise_Picture_Table TableNew = new Merchandise_Picture_Table() { IngredientID = IngID, MerchandisePicture = bytes }; dbcontext.Merchandise_Picture_Table.Add(TableNew); dbcontext.SaveChanges(); CountPic--; } } else { MessageBox.Show("圖片超過5張了"); } ShowPic(); } catch (Exception) { } }
private void bt_udpics_Click(object sender, EventArgs e) { for (int i = 0; i <= ms.Count - 1; i++) { Byte[] bytes; bytes = ms[i].GetBuffer(); var newMerchidisePic = new Merchandise_Picture_Table() { IngredientID = getIngId, MerchandisePicture = bytes }; dbcontext.Merchandise_Picture_Table.Add(newMerchidisePic); try { dbcontext.SaveChanges(); MessageBox.Show("新增圖片成功"); this.Close(); } catch (Exception) { MessageBox.Show("新增圖片失敗"); } } }