private void btnDelete_Click(object sender, EventArgs e) { var db = new DBGoMusicEntities(); if (MessageBox.Show("Do you want to delete this song?", "Confirm", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { for (int i = 0; i < this.lstSong.SelectedRows.Count; i++) { var row = this.lstSong.SelectedRows[i]; var item = (BaiHat)row.DataBoundItem; try { BaiHat bh = db.BaiHats.Find(item.id); db.BaiHats.Remove(bh); db.SaveChanges(); //Do it } catch (Exception ex) { MessageBox.Show(ex.Message); } } this.ShowBaiHat(); } }
private void btnSave_Click(object sender, EventArgs e) { try { var db = new DBGoMusicEntities(); var updatE = db.BaiHats.Find(this.bh.id); updatE.Song = this.txtName.Text; updatE.Singer = this.txtSinger.Text; updatE.Songwriter = this.txtWriter.Text; updatE.Album = this.txtAlbum.Text; db.Entry(updatE).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { BaiHat bh = new BaiHat(); bh.Song = this.txtName.Text; bh.Singer = this.txtSinger.Text; bh.Songwriter = this.txtWriter.Text; bh.Album = this.txtAlbum.Text; try { var db = new DBGoMusicEntities(); db.BaiHats.Add(bh); db.SaveChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }