private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = GridViewCarInfo.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(GridViewCarInfo.GetFocusedDisplayText())) { value = GridViewCarInfo.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { string query = String.Format("it.NAME like '{0}%'", GridViewCarInfo.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "NAME")); var special = context.CARINFO.Where(query); if (!string.IsNullOrWhiteSpace(GridViewCarInfo.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE"))) { query = String.Format("it.{0} like '{1}%'", "CODE", GridViewCarInfo.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "CODE")); special = special.Where(query); } int count = special.Count(); if (count > 0) { CarInfoBindingSource.DataSource = special; GridViewCarInfo.ClearColumnsFilter(); } else { MessageBox.Show("No records in database."); GridViewCarInfo.ClearColumnsFilter(); } } this.Cursor = Cursors.Default; }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { GridViewCarInfo.ClearColumnsFilter(); cODETextEdit.Focus(); //trigger field leave event if (CarInfoBindingSource.Current == null) { //fake query in order to create a link between the database table and the binding source CarInfoBindingSource.DataSource = from opt in context.CARINFO where opt.CODE == "KJM9" select opt; CarInfoBindingSource.AddNew(); if (GridViewCarInfo.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewCarInfo.FocusedRowHandle = GridViewCarInfo.RowCount - 1; } setValues(); cODETextEdit.Focus(); setReadOnly(false); newRec = true; return; } GridViewCarInfo.CloseEditor(); temp = newRec; if (checkForms()) { errorProvider1.Clear(); if (!temp) { context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, ( CARINFO)CarInfoBindingSource.Current); } CarInfoBindingSource.AddNew(); if (GridViewCarInfo.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewCarInfo.FocusedRowHandle = GridViewCarInfo.RowCount - 1; } setValues(); cODETextEdit.Focus(); setReadOnly(false); newRec = true; } }