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