private void button6_Click(object sender, EventArgs e) { Banggiactrl bg = new Banggiactrl(); string _danghd = ""; if (comboBox1.Text.Trim() == "") { _danghd = ""; } else if (comboBox1.Text.Trim() == "false") { _danghd = "0"; } else { _danghd = "1"; } string _ngaythem = ""; string _ngayhuy = ""; if (dateTimePicker1.Checked == true) { _ngaythem = dateTimePicker1.Text.Trim(); } if (dateTimePicker2.Checked == true) { _ngayhuy = dateTimePicker1.Text.Trim(); } bg.LoadDataGridView(dataGridView1, textBox1.Text.Trim(), textBox2.Text.Trim(), _ngaythem, _ngayhuy, _danghd); }
private void BangGiaKhamBenh_Load(object sender, EventArgs e) { Banggiactrl bg = new Banggiactrl(); bg.LoadDataGridView(dataGridView1, "", "", "", "", ""); LoadDataGridViewFormat(); TrangThaiBanDau(); clsDatabase cls = new clsDatabase(); cls.loadcombobox(comboBox1, "SELECT Distinct(Danghoatdong) FROM tblLoaihinhdichvu", 0); }