private void LoadHD()
        {
            AutoCompleteStringCollection acsc = new AutoCompleteStringCollection();

            foreach (DataRow item in HOADON.dSMAHD().Rows)
            {
                acsc.Add(item["MAHD"].ToString());
            }
            txtTK.AutoCompleteCustomSource = acsc;
            dataGridView2.DataSource       = HOADON.getHD();

            LoadDoanhThu();
        }
 private void btnXem_Click(object sender, EventArgs e)
 {
     dataGridView2.DataSource = HOADON.getHD(dateTimePicker1.Value.ToString("yyyy-MM-dd"), dateTimePicker3.Value.ToString("yyyy-MM-dd"));
     LoadDoanhThu();
     Changebackgroundcolor_rowodd();
 }