private void LoadAgain() { var r = new DatabaseNV(); List <CustomerParameter> lst = new List <CustomerParameter>(); DataTable dt = r.SelectData("Load", lst); this.dataGridViewPhongban.DataSource = dt; this.buttonSua.Enabled = false; }
private void comboBoxPhongban_TextChanged(object sender, EventArgs e) { string TenPB = this.comboBoxPhongban.Text; List <CustomerParameter> lst = new List <CustomerParameter>(); lst.Add(new CustomerParameter() { key = "@tenphongban", value = TenPB }); var r = new DatabaseNV(); dataGridViewLuong.DataSource = r.SelectData("BANGLUONGTHEOPHONG", lst); }
public void LoadAgain() { var db = new DatabaseNV(); List <CustomerParameter> lst = new List <CustomerParameter>(); lst.Add(new CustomerParameter() { key = "@tukhoa", value = textBoxTimkiem.Text }); string sql = ""; if (this.radioButton1.Checked == true) { sql = "SelectAllNhanVien"; } if (this.radioButton2.Checked == true) { sql = "SelectAllNhanVienHetHan"; } dgvKetQua.DataSource = db.SelectData(sql, lst); }