예제 #1
0
 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;
 }
예제 #2
0
 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());
     }
 }