05-Apr-2010 Version 2.6.1
-added: New methods in TextStorage class: LoadFromFile and LoadFromResourceSet - they allows you to load resources from .properties or .resx files.
-added: New method BuildSQLEx in Query class;
-added: New property QuoteColumnAlias in Query.Formats;
-added: New property in Query: NoPathResolution;
-added: New property in Query.Formats: EscapeSymbol - it allows you to define escape symbol for LIKE statements;
-added: An ability to specify TOP or LIMIT clauses in result SQL;
-added: An ability to define virtual tables in your data model;
-added: Support for Native Oracle connections in Data Model Editor;
-added: New event in Query class: CondSqlGen.
-added: Now EasyQuery assemblies can be used on web sites with Medium Trust securtiy level;
-added: An ability to define maximum height for JavaScript popup menus;
-changed: EditMode property in SortColumnsPanel was replaced by SortEditMode;
-fixed: Few small bugs in Data Model Editor;
-fixed: List of tables was not sorted in DME;
-fixed: The problem with comma decimal point;
-fixed: Some problems with JavaScript menu in Chrome and Opera 10;
-fixed: Few problems with the translation of QueryPanel messages;
01-Jul-2009 Version 2.5.0
-added: Internet Explorer 8.0 support;
-added: ExtraTables property in Query class;
-added: Support for "Cross" type of table joins;
-added: LoadOperatorsFromFile and LoadOperatorsFromString methods in DataModel class - an ability to load only operator list into data model;
-added: Query.Formats.WildSymbol property - an ability to define wild symbol used in LIKE and similar operators;
-added: Query.Options.SelectTop property - allows to define TOP command for SELECT clause;
-added: Query.Options.LimitClause property - allows to define LIMIT clause (for MySQL and PostgreSQL);
-added: New DB gate for native connection to MS SQL Server;
-added: Connection string builder dialog for MS SQL Server DB Gate;
-added: An ability to change all text messages used in EasyQuery controls on-the-fly;
-added: Appearance.RowButtonTooltip property in QueryPanel and QueryColumnsPanel controls;
-added: Appearance.HeaderBgColor and Appearance.HeaderCssClass properties in QueryColumnsPanel control;
-fixed: small problems with Spanish satellite assemblies;
-fixed: JavaScript error for item with special characters returned by SQL List value editor;
-fixed: few problems in Data Model Editor;
11-Feb-2009 Version 2.4.0
-added: An ability to define sorting columns separately from the main column list;
-added: BuildParamSQL() method in Query class which allows to build parametrized SQL statements;
-added: Params property in Query.Result - give an access to list of parameters in case of using BuildParamSQL method;
-added: AllowSorting property in QueryColumnsPanel control;
-added: "Aggregate" property for virtual entity attributes;
-added: Automatical generation of HAVING clause for conditions with entity attributes marked as "aggregate";
-added: Now QueryColumnsPanel and SortColumnsPanel can show Up and Down buttons: see Appearance.ShowUpDownButtons property;
-added: Appearance.ScriptMenuStyle.ItemMaxWidth property - allows to specify maximum width of menu items. If some item is wider then it will be wrapped.
-added: The top position of sub-menus is adjusted automatically according to the current window height.
-added: An ability to specify class for 'over' menu items: Appearance.ScriptMenuStyle.CssClassOver property;
-added: An ability to specify background color for 'over' menu items: Appearance.ScriptMenuStyle.BackColorOver property;
-added: EditMode property in QueryPanel and QueryColumPanel controls: An ability to fix some panel elements;
-added: ReadOnly property for Query.Condition objects;
-changed: Appearance.ScriptMenuStule.ItemWidth property was renamed to ItemMinWidth;
-fixed: The problem with unnecessary horizontal scroll bars in script menu.
28-Oct-2008 Version 2.3.0 (revision 2)
-added: QuoteFields property in DataModel.Link class;
-added: Default validation for numeric values;
-added: "-file:" parameter in Data Model Editor;
-fixed: An error occured during date/time values processing;
-fixed: ColumnsChanged event occured several times in some cases;
-fixed: ValidateValue event was not raised in QueryPanel control;
-fixed: "Unrecognized attribute" when click on entity item when add a column or condition;
-fixed: Wrong behaviour of QueryPanel when CustomList value editor is used in condition;
-fixed: Wrong behaviour of QueryPanel with SqlList value editor in AJAX mode;
20-Aug-2008 Version 2.2.1
-added: RowButtonImageUrl property in QueryPanel.Appearance
-added: ColumnButtonImageUrl property in QueryColumnsPanel.Appearance
-added: ValueRequest event in QueryPanel control;
-added: Data property in ValueRequestEventArgs class;
-fixed: ElementCssClass and ScriptMenuStyle.CssClass properties did not work;
-fixed: Wrong behaviour of EasyQuery.NET controls at design time;
05-Aug-2008 Version 2.2.0
-added: UseDbName property in SqlFormats class;
-added: Visual Studio 2008 support;
-changed: Now column caption by default contains entity + attribute name;
-fixed: The problem with "lost" __doPostBack() function;
09-Jul-2008 Version 2.1.0
-added: New Data Model Editor - fully rewritten on .NET
-added: An ability to select entity attribute in the right side of condition (through Ctrl+Click);
-added: An ability to define macro values (e.g. );
-added: An ability to translate default operators;
-added: New operators for date/time values (before, after, etc.);
-added: An ability to organize operators into several predefined groups;
-added: New value kind: Attribute;
-added: An ability to use {exprN.table} or {exprN.field} macros in operator expressions;
-added: An ability to fill the list of operators for some attribute with defaults;
-changed: New JavaScript menu: more functional and more efficient;
-changed: Global code refactoring have been done;
-fixed: Several small problems have been fixed;
16-Feb-2008 Version 1.11.0
-added: An option to turn on/off aggregate columns menu;
-changed: AllowEditCaptions property was moved to QueryColumnsPanel from CPAppearance class;
-fixed: Problem with storing menu items in Session object;
-fixed: Date value format problem;
-fixed: Problem when QueryPanel is used together with Telerik RadGrid;
04-Dec-2007 Version 1.10.3
-added: Strong names in Korzh.WebControls and Korzh.EasyQuery.WebControls assemblies;
-fixed: A JavaScript error when EasyQuery.NET components are used with AJAX Toolkit controls;
27-Nov-2007 Version 1.10.2
-changed: Input box is shown now for "starts with" or "contains" operators in any case;
-fixed: Wrong behaviour of components if SesstionStateMode=SQLServer (serialization did not work);
-fixed: Root condition row was not changed correctly after query loading;
-fixed: Problem with comma and double-quote symbols in list values.
05-Nov-2007 Version 1.10.1
-added: An ability to set the color of attribute, operator or expression label;
-added: New option "Use in sorting" which permit or forbid sorting for an attribute;
-added: LazyJoins property in Query.Options;
-fixed: Focus lost was not processed in edit box and date/time picker;
-fixed: Problem with single quotes in sub-queries;
-fixed: Wrong processing of list values;
-fixed: SQL keywords (like "FROM") were not taken in quotes;
-fixed: "Error rendering control" exception at design-time;
06-Jul-2007 Version 1.9.2
-fixed: NullReferenceException when some attribute with "List" value editor is used in condition;
-fixed: Wrong aggregate functions list: QueryColumnsPanel always showed aggregate function for the first added column;
-fixed: JS Error after Query.Clear() operation on AJAX-enabled web-pages;
26-Jun-2007 Version 1.9.1
-added: An ability to mark any operator as "Case insensative";
-added: "Use in ..." filter in Data Model Editor (DME);
-added: An ability to add stored procedures and Oracle views in DME;
-fixed: Quotes were wrongly used in sub-queries;
-fixed: JavaScript error in IE 7 when user clicks on [enter value] label;
10-May-2007 Version 1.8.0
-added: support for ASP.NET AJAX: now QueryPanel and QueryColumnsPanel can be used with UpdatePanel control;
-added: UseDatePicker property in QueryPanel.Appearance - allows to disable using calendar control for date values;
-added: New Calendar control - now it looks good and works well both in IE and FireFox;
-added: AllowEditCaptions property in QueryColumnsPanel.Appearance - turn on/off an ability to modify column captions;
-added: An ability to save User Data for entities in DME;
-added: StoreOptions property in Query class;
-changed: DME now show table alias in table selection dialog;
-fixed: Query options were not stored;
-fixed: Joins were no listed in Result SQL when SqlSytax == SQL1
-fixed: Sub-queries were taken in quotes by mistake;
-fixed: Several minor issues;
23-Mar-2007 Version 1.7.0
-added: Database options for ADO Gate in Data Model Editor: now you can indicate if you wants to used Views and Linked Tables in the list of all available tables;
-added: New overloaded LoadFromFile and SaveToFile functions in Query class: now they allows to load/save only columns or only conditions;
-added: List cache for QueryPanel control: now is not necessary to execute the same query in SqlExecute event on each postback;
-added: Calendar can be used for date/time values selection (works in IE only);
-fixed: Wrong behaviour of elements when XListBox is placed on some user control;
-changed: Row element classes registration mechanism: now it is similar to registration of Expression descendants;
-fixed: The error that occured in DM Editor and DM Wizard under Windows Vista;
-fixed: Few small bugs in DM Editor;
22-Dec-2006 Version 1.6.2
-added: NullAttribute property in DataModel - gets default entity attribute object for "unrecognized" attributes;
-fixed: JavaScript error in Internet Explorer 7.0;
-fixed: Null reference exception on some queries;
27-Nov-2006 Version 1.6.1
-added: VB.NET demo project;
-added: New method of DataModel class FillByDataTable which allows to fill model by DataTable object;
-added: New method of DataModel class which allows to add default list of operators - AddDefaultOperators;
-added: An ability to select several items from the list of available values for "is in list" operator;
-added: DbsPort and QryPort utilites which allow to convert old .qry and .dbs files (used in Simple/Active Query) to new formats;
-added: DefExprType property in DataModel.Operator class;
-added: Query.GetConditionsText method - allows to get human readable representation of query conditions;
-added: QueryPanel.CreateValueElement event - allows to change value editor element at run-time;
-added: SqlFormats.AlphaAlias property - allows to control the format of column alias in result SQL statement;
-added: Database schemas support in Data Model Editor;
-added: New property in DataModel.Table: SchemaName;
-added: SqlFormats.UseSchema property;
-added: SqlFormats.DefaultSchemaName property;
-added: "Quote" property for entity attributes;
-added: Appearance.ShowEntitiesAsTree property in QueryPanel;
-changed: ColumnsChanged event now has more specific type ColumnsChangedEventHandler instead of common EventHandler type;
-changed: Postback performance has beed improved;
-fixed: NotStartsWith and NotContains operators were not processed correctly;
-fixed: Wrong behaviour on adding condition in multi level query;
-fixed: Several minor bugs in Data Model Editor;
-fixed: Wrong processing of the default type property for operators in Data Model Editor and query panel;
-fixed: LinkType was not saved for root query predicate;
-fixed: Some minor problems in Data Model Wizard application;
19-Jul-2006 Version 1.5.1
-added: New property in Query object: bool CanBuild. It returns true if there is at least one enabled condition or at least one result column;
-added: New events in QueryPanel control: ElementApplyFormats, EntityElementApplyFormants, OperatorElementApplyFormats. They allows to change different element formats (e.g. script menu style) before rendering;
-added: GetSql method of Query.Result object. Allows to get SQL statement with custom SELECT and ORDER BY clauses;
-added: An ability to specify "custom list" value editor in Data Model Editor. This value editor does not contain list of items but has a name and can be filled at run-time;
-added: ListRequest event - allows to fill items at run-time for "custom list" value editors;
-changed: ScriptMenuStyle now is inherited from System.Web.UI.WebControls.Style class;
-changed: Query object now automatically use 0 for empty numeric values in conditions;
-fixed: Appearance properties did not save their values on postback;
-fixed: QueryColumnsPanel control ignored "Use in result" option of entity attributes;
-fixed: Enabled state of condition was not saved into query definition file;
-fixed: Single quote in constant values used in conditions was not replaced by double quotes in result SQL statement that caused SQL execution error;
-fixed: Several minor bugs in Data Model Editor;
26-Jun-2006 Version 1.5.0
-added: StoreModelPath property in Query class;
-added: QueryName and QueryDescription properties in Query class;
-added: Description property in DataModel class;
-added: FilePath property in DataModel class;
-added: DataModel.DatabaseParameters class that represents different options of database linked with datat model;
-added: DbParams property in DataModel class;
-added: StoreDbParams property in DataModel class;
-added: new controls QueryColumnsPanel and SortColumnsPanel;
-added: New Data Model Editor dialog: supports several levels of entities, new format of operator expressions, new design of tables/links pane and allows to edit connection settings;
-added: Data Model Wizard program that allows to create new data models easily;
-added: sevaral new properties in QueryPanel.Appearance: ScriptMenuStyle, RowCssClass, ElementCssClass;
-added: an ability to show fully qualified entity attribute name (with entity name prefix). AttrElementFormat properties in QueryPanel.Appearance and QueryColumnsPanel.Appearance;
-added: now user can select entity attribute when add a condtion through "[click here to add ...]" label in QueryPanel control or column in QueryColumnsPanel control;
-changed: the way Data Model object generates entity attribute IDs ("table.field" pattern is used now instead of numbers);
-changed: All resources and scripts used in library were moved to resources;
-changed: class names are changed (Entity - EntityAttr, EntityGroup - Entity) to unify data model object with their internal representation;
-fixed: wrong hint for condition row and column row buttons;
-fixed: several minor bugs;
03-Mar-2006 Version 1.0.0
-------------------------
First public release of EasyQuery.NET WebForms edition
Home/Products