private void load_BaiHat_home() { dtBaiHat_home = new BaiHat_BUS().getBaiHat_home(); foreach (DataRow dr in dtBaiHat_home.Rows) { ListViewItem li = lvwBaiHat_Home.Items.Add(""); li.SubItems.Add(dr["tenbaihat"].ToString()); li.SubItems.Add(dr["tenalbum"].ToString()); DataTable dt = new Casi_Baihat_BUS().getCasi_BaiHat_by_mabaihat(dr["mabaihat"].ToString()); string cac_casi = ""; foreach (DataRow r in dt.Rows) { DataTable dtcasi = new CaSi_BUS().getCasi_by_macasi(r["macasi"].ToString()); foreach (DataRow r1 in dtcasi.Rows) { cac_casi += r1["tencasi"].ToString() + ", "; } } li.SubItems.Add(cac_casi + "..."); li.SubItems.Add(dr["tentheloai"].ToString()); li.SubItems.Add(dr["loibaihat"].ToString()); li.Tag = dr["mabaihat"]; } stt(lvwBaiHat_Home); }
private void lvwTheLoai_SelectedIndexChanged(object sender, EventArgs e) { if (lvwTheLoai.SelectedItems.Count == 0) { return; } lvwBaiHat_TheLoai.Items.Clear(); try { DataTable dt = new BaiHat_BUS().getBaiHat_by_TheLoai(lvwTheLoai.SelectedItems[0].Tag.ToString()); foreach (DataRow dr in dt.Rows) { ListViewItem li = lvwBaiHat_TheLoai.Items.Add(""); li.SubItems.Add(dr["tenbaihat"].ToString()); DataTable dtA = new Album_BUS().getAlbum_by_ma(dr["maalbum"].ToString()); DataRow r = dtA.Rows[0]; li.SubItems.Add(r["tenalbum"].ToString()); DataTable dtt = new Casi_Baihat_BUS().getCasi_BaiHat_by_mabaihat(dr["mabaihat"].ToString()); string cac_casi = ""; foreach (DataRow rt in dtt.Rows) { DataTable dtcasi = new CaSi_BUS().getCasi_by_macasi(rt["macasi"].ToString()); foreach (DataRow r1 in dtcasi.Rows) { cac_casi += r1["tencasi"].ToString() + ", "; } } li.SubItems.Add(cac_casi + "..."); li.SubItems.Add(dr["loibaihat"].ToString()); } } catch (Exception) { MessageBox.Show("Lỗi không xác định "); return; } stt(lvwBaiHat_TheLoai); lblBaiHatTrongTheLoai.Text = "Danh sách các bài hát có trong Thể loại: [" + lvwTheLoai.SelectedItems[0].SubItems[1].Text + "]"; }