private void button1_Click(object sender, EventArgs e)
 {
     if (txtSearchRoomService.Text == "")
     {
         this.loadDataRoomService();
     }
     else
     {
         string Key = txtSearchRoomService.Text.Trim();
         if (Key == null || Key == string.Empty || Key.Length == 0)
         {
             List <RoomServiceDTO> listTimKiem = rsrvBus.select();
             this.loadDataRoomService(listTimKiem);
         }
         else
         {
             List <RoomServiceDTO> listTimKiem = rsrvBus.search(Key);
             this.loadDataRoomService(listTimKiem);
         }
     }
 }
        private void loadDataRoomService()
        {
            rsrvBus = new RoomServiceBUS();
            List <RoomServiceDTO> list = rsrvBus.select();

            if (list == null)
            {
                MessageBox.Show("Fail");
                return;
            }
            dtgvUseService.Columns.Clear();
            dtgvUseService.DataSource = null;

            dtgvUseService.AutoGenerateColumns = false;
            dtgvUseService.AllowUserToAddRows  = false;
            dtgvUseService.DataSource          = list;

            DataGridViewTextBoxColumn IDS = new DataGridViewTextBoxColumn();

            IDS.Name             = "ids";
            IDS.HeaderText       = "Service:";
            IDS.DataPropertyName = "ids";
            IDS.AutoSizeMode     = DataGridViewAutoSizeColumnMode.Fill;
            dtgvUseService.Columns.Add(IDS);

            DataGridViewTextBoxColumn IDR = new DataGridViewTextBoxColumn();

            IDR.Name             = "idr";
            IDR.HeaderText       = "Room";
            IDR.DataPropertyName = "idr";
            IDR.AutoSizeMode     = DataGridViewAutoSizeColumnMode.Fill;
            dtgvUseService.Columns.Add(IDR);

            DataGridViewTextBoxColumn Time = new DataGridViewTextBoxColumn();

            Time.Name             = "time";
            Time.HeaderText       = "Time";
            Time.DataPropertyName = "time";
            Time.AutoSizeMode     = DataGridViewAutoSizeColumnMode.Fill;
            dtgvUseService.Columns.Add(Time);

            DataGridViewTextBoxColumn NUMBER = new DataGridViewTextBoxColumn();

            NUMBER.Name             = "number";
            NUMBER.HeaderText       = "Number";
            NUMBER.DataPropertyName = "number";
            NUMBER.AutoSizeMode     = DataGridViewAutoSizeColumnMode.Fill;
            dtgvUseService.Columns.Add(NUMBER);

            DataGridViewTextBoxColumn COST = new DataGridViewTextBoxColumn();

            COST.Name             = "cost";
            COST.HeaderText       = "Cost";
            COST.DataPropertyName = "cost";
            COST.AutoSizeMode     = DataGridViewAutoSizeColumnMode.Fill;
            dtgvUseService.Columns.Add(COST);


            CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[dtgvUseService.DataSource];

            myCurrencyManager.Refresh();
        }