private void Form1_Load(object sender, EventArgs e) { dsChiNhanh = XuLyDuLieu.docDulieu("Select * from ChiNhanh"); for (int i = 0; i < dsChiNhanh.Rows.Count; i++) { thôngTinToolStripMenuItem.DropDownItems.Add(dsChiNhanh.Rows[i]["MaCN"].ToString()); } dsDHMonAn = XuLyDuLieu.docDulieu("Select * from MonAn"); dgvDsMonAn.DataSource = dsDHMonAn; }
private void LISTVIEW(string idChiNhanh) { dsBan = XuLyDuLieu.docDulieu("Select * from Ban where MaCN LIKE '" + idChiNhanh + "'"); lvDsBan.Items.Clear(); for (int i = 0; i < dsBan.Rows.Count; i++) { lvDsBan.Items.Add(dsBan.Rows[i]["MaBan"].ToString()); //lvDsBan.Items[i].SubItems.Add(dsBan.Rows[i]["MaCN"].ToString()); lvDsBan.Items[i].SubItems.Add(dsBan.Rows[i]["TinhTrang"].ToString()); lvDsBan.Items[i].SubItems.Add(dsBan.Rows[i]["ThoiGian"].ToString()); } }