private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = GridViewUsers.FocusedColumn.FieldName; string value = String.Empty; //if (!string.IsNullOrWhiteSpace(GridViewUsers.GetFocusedDisplayText())) value = GridViewUsers.GetFocusedDisplayText(); //if (!string.IsNullOrWhiteSpace(value)) //{ string query = String.Format("it.UserID like '{0}%'", GridViewUsers.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "UserID")); var results = context.ExtranetUser.Where(query); int count = results.Count(); if (count > 0) { UsersBindingSource.DataSource = results; GridViewUsers.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value); GridViewUsers.FocusedRowHandle = 0; GridViewUsers.FocusedColumn.FieldName = colName; } else { XtraMessageBox.Show("No records in database."); GridViewUsers.ClearColumnsFilter(); } //} this.Cursor = Cursors.Default; }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { if (modified || newRec) { DialogResult select = DevExpress.XtraEditors.XtraMessageBox.Show("Do you want to confirm these changes?", Text, MessageBoxButtons.YesNoCancel); if (select == DialogResult.Cancel) { return; } if (select == DialogResult.Yes) { if (!SaveRecord()) { return; } } if (select == DialogResult.No) { if (newRec) { RemoveRecord(); } else { RefreshRecord(); } } } GridViewUsers.ClearColumnsFilter(); if (UsersBindingSource.Current == null) { //fake query in order to create a link between the database table and the binding source UsersBindingSource.DataSource = from opt in context.ExtranetUser where opt.UserID == "KJM9" select opt; } CheckEditAgent.Focus(); GridViewUsers.CloseEditor(); newRec = true; ignoreLeaveRow = true; //so that when the grid row changes it doesn't try to save again UsersBindingSource.AddNew(); if (GridViewUsers.FocusedRowHandle == GridControl.AutoFilterRowHandle) { GridViewUsers.FocusedRowHandle = GridViewUsers.RowCount - 1; } CheckEditAgent.Focus(); setReadOnly(false); ignoreLeaveRow = false; }