private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = GridViewBusTable.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(GridViewBusTable.GetFocusedDisplayText())) { value = GridViewBusTable.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { string query = String.Format("it.TYPE like '{0}%'", GridViewBusTable.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "TYPE")); var special = context.BUSTABLE.Where(query); if (!string.IsNullOrWhiteSpace(GridViewBusTable.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE"))) { query = String.Format("it.{0} like '{1}%'", "CODE", GridViewBusTable.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE")); special = special.Where(query); } int count = special.Count(); if (count > 0) { BusTableBindingSource.DataSource = special; GridViewBusTable.ClearColumnsFilter(); } else { MessageBox.Show("No records in database."); GridViewBusTable.ClearColumnsFilter(); } } this.Cursor = Cursors.Default; }