private void save_DB() { check = true; byte[] imgByte; //System.Windows.Forms.MessageBox.Show(AppDomain.CurrentDomain.BaseDirectory); System.Drawing.Image img = System.Drawing.Image.FromFile("aa.png"); MemoryStream ms = new MemoryStream(); img.Save(ms, System.Drawing.Imaging.ImageFormat.Png); imgByte = new byte[ms.Length]; imgByte = ms.ToArray(); MemberDataContext memContext = new MemberDataContext(); var query = from memCharacter in memContext.MemberCharacter where memCharacter.MemberName == Player.getInstance().getID().ToString() select memCharacter; foreach (var item in query) { item.CharacterImage = imgByte; Console.WriteLine(item.CharacterImage.ToString()); } try { memContext.SubmitChanges(); } catch (ChangeConflictException) { memContext.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } // System.Windows.Forms.MessageBox.Show(e.ToString()); ms.Close(); }
private void db_Insert() { MemberDataContext memContext = new MemberDataContext(); CardDataContext card = new CardDataContext(); Member mem = new Member(); mem.MemberName = txtID.Text; mem.MemberPassword = txtPassword.Text; mem.MemberPassword2 = txtPassword2.Text; memContext.Member.InsertOnSubmit(mem); try { memContext.SubmitChanges(); card.Game_CardDeck(txtID.Text); } catch { MyMessageBox error = new MyMessageBox(); error.SetText = "같은 아이디가 있습니다."; error.ShowDialog(); } }