private void FillResult() { try { Cursor.Current = Cursors.WaitCursor; TT myTableAdapter = TableAdapter; var myQuery = new TableQuery(TableQuery); if (!String.IsNullOrEmpty(txtSearch.Text)) { TableQuery.Where.Add( new QueryParam(DefaultSearch, txtSearch.Text)); } myQuery.OrderBy.Add( new OrderBy( new QueryParam(DefaultSearch))); DataTable data = myTableAdapter.GetData(myQuery); grdResult.DataSource = data; ViewResult.BestFitColumns(); if (!string.IsNullOrEmpty(DefaultSearch.Name)) { ViewResult.FocusedColumn = ViewResult.Columns[DefaultSearch.Name]; } } finally { Cursor.Current = Cursors.Default; } }
private void FillResult() { try { Cursor.Current = Cursors.WaitCursor; var query = new TableQuery(Query); if (!String.IsNullOrEmpty(SearchBy)) { var where = new WhereCollection(); foreach (var item in SearchColumns) { QueryParam param; if (item.DbTypeIsNumeric()) { int intConvert; if (!int.TryParse(SearchBy, out intConvert)) { continue; } param = new QueryParam(item, intConvert); } else { param = new QueryParam(item, eCondition.ecLike, SearchBy); } param.Relationship = eRelationship.erOr; where.Add(param); query.OrderBy.Add(new OrderBy(param)); } query.Wheres.Add(where); } var command = new SqlServerScriptWizard(query).GetSelectStatment(); grdResult.DataSource = Connection.Instance.SqlServerQuery(command.Item1, command.Item2); ViewResult.BestFitColumns(); ViewResult.ClearSorting(); if (!SearchColumns.IsEmpty()) { ViewResult.FocusedColumn = ViewResult.Columns[SearchColumns.First().Name]; ViewResult.FocusedColumn.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; if (Record != null) { var fieldValue = Record[ViewResult.FocusedColumn.FieldName].ToString(); ViewResult.StartIncrementalSearch(fieldValue); } } } finally { Cursor.Current = Cursors.Default; } }