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);
        }