ActiveQueryBuilder.ASPNET
2.13.0
See the version list below for details.
dotnet add package ActiveQueryBuilder.ASPNET --version 2.13.0
NuGet\Install-Package ActiveQueryBuilder.ASPNET -Version 2.13.0
<PackageReference Include="ActiveQueryBuilder.ASPNET" Version="2.13.0" />
paket add ActiveQueryBuilder.ASPNET --version 2.13.0
#r "nuget: ActiveQueryBuilder.ASPNET, 2.13.0"
// Install ActiveQueryBuilder.ASPNET as a Cake Addin #addin nuget:?package=ActiveQueryBuilder.ASPNET&version=2.13.0 // Install ActiveQueryBuilder.ASPNET as a Cake Tool #tool nuget:?package=ActiveQueryBuilder.ASPNET&version=2.13.0
Visual SQL Query Builder for classic ASP.NET and MVC environemnts, Razor and ASPX view engines, with full support of all popular database servers and appropriate SQL dialects. Working with Active Query Builder the end-user can combine visual query building with direct SQL query text editing. Active Query Builder allows for parsing of complex SQL queries for their visual representation as well as for programmatic analysis and modification.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net20 is compatible. net35 is compatible. net40 is compatible. net403 was computed. net45 is compatible. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
- log4net (> 2.0.2 && < 99.0.0)
- Newtonsoft.Json (> 6.0.7 && < 99.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
2.14.3 | 1,646 | 2/8/2019 |
2.14.2 | 1,226 | 6/22/2018 |
2.14.1 | 1,291 | 12/1/2017 |
2.14.0.1 | 1,232 | 11/14/2017 |
2.14.0 | 1,250 | 10/3/2017 |
2.13.16 | 1,256 | 9/15/2017 |
2.13.15 | 1,215 | 9/6/2017 |
2.13.14 | 1,209 | 8/18/2017 |
2.13.13 | 1,414 | 7/14/2017 |
2.13.12 | 1,258 | 7/4/2017 |
2.13.11 | 1,273 | 6/16/2017 |
2.13.10.1 | 1,390 | 5/22/2017 |
2.13.10 | 1,244 | 5/17/2017 |
2.13.9 | 1,356 | 4/5/2017 |
2.13.8 | 1,274 | 3/24/2017 |
2.13.7 | 1,230 | 3/17/2017 |
2.13.6 | 1,279 | 3/15/2017 |
2.13.5 | 1,394 | 3/3/2017 |
2.13.4 | 5,617 | 2/17/2017 |
2.13.3 | 1,316 | 2/9/2017 |
2.13.2 | 1,317 | 2/2/2017 |
2.13.1 | 1,375 | 1/27/2017 |
2.13.0 | 1,342 | 1/27/2017 |
2.12.5 | 1,491 | 12/12/2016 |
2.12.4 | 1,356 | 11/10/2016 |
2.12.3 | 1,644 | 11/1/2016 |
2.12.2 | 1,420 | 10/28/2016 |
2.12.1 | 1,379 | 10/21/2016 |
2.12.0 | 1,328 | 10/19/2016 |
2.11.9 | 1,667 | 9/23/2016 |
2.11.8 | 1,633 | 9/21/2016 |
2.11.7 | 1,322 | 9/1/2016 |
2.11.6 | 1,367 | 8/5/2016 |
2.11.5 | 1,400 | 7/25/2016 |
2.11.4 | 1,809 | 6/16/2016 |
2.11.3 | 1,468 | 5/11/2016 |
2.11.2 | 1,530 | 4/20/2016 |
2.11.1 | 1,445 | 4/15/2016 |
2.11.0 | 1,407 | 3/28/2016 |
2.10.17 | 1,325 | 3/23/2016 |
2.10.14 | 1,423 | 3/4/2016 |
2.10.13 | 1,350 | 3/3/2016 |
2.10.12 | 1,677 | 2/29/2016 |
2.10.11.1 | 1,780 | 2/25/2016 |
2.10.11 | 1,695 | 2/25/2016 |
2.10.10 | 1,445 | 2/20/2016 |
2.10.9 | 1,376 | 2/11/2016 |
2.10.8 | 1,368 | 2/10/2016 |
2.10.7 | 1,379 | 2/2/2016 |
2.10.6.1 | 1,409 | 1/20/2016 |
2.10.6 | 1,336 | 1/20/2016 |
2.10.5 | 1,383 | 1/12/2016 |
2.10.4 | 1,590 | 12/22/2015 |
2.10.3 | 1,331 | 12/21/2015 |
2.10.2 | 1,556 | 12/2/2015 |
2.10.1 | 1,448 | 11/30/2015 |
2.10.0 | 1,494 | 11/25/2015 |
2.9.16 | 1,437 | 11/16/2015 |
2.9.15 | 1,490 | 11/10/2015 |
2.9.14 | 1,419 | 11/5/2015 |
2.9.13 | 1,430 | 11/4/2015 |
2.9.12 | 1,416 | 11/2/2015 |
2.9.11 | 1,440 | 10/20/2015 |
2.9.10 | 1,375 | 10/16/2015 |
2.9.9 | 1,757 | 10/8/2015 |
2.9.8 | 1,552 | 10/7/2015 |
2.9.7 | 1,647 | 10/2/2015 |
2.9.6 | 1,480 | 9/22/2015 |
2.9.5 | 1,486 | 9/18/2015 |
2.9.4 | 1,435 | 9/16/2015 |
2.9.3 | 1,397 | 9/2/2015 |
2.9.2.2 | 1,439 | 8/28/2015 |
2.9.2.1 | 1,477 | 8/28/2015 |
2.9.2 | 1,448 | 8/28/2015 |
2.9.1 | 1,447 | 8/21/2015 |
2.9.0 | 1,867 | 8/12/2015 |
2.8.15.1 | 1,692 | 8/7/2015 |
2.8.15 | 1,755 | 8/7/2015 |
2.8.14 | 1,780 | 8/3/2015 |
2.8.13 | 1,565 | 7/30/2015 |
2.8.12 | 1,656 | 7/16/2015 |
2.8.11 | 1,426 | 7/3/2015 |
2.8.10 | 1,474 | 6/23/2015 |
2.8.9 | 1,444 | 6/17/2015 |
2.8.8 | 1,452 | 6/5/2015 |
2.8.7 | 1,465 | 5/20/2015 |
2.8.6 | 1,461 | 5/13/2015 |
2.8.5 | 1,648 | 4/30/2015 |
2.8.3 | 1,589 | 4/22/2015 |
2.8.2 | 1,496 | 4/13/2015 |
2.8.1 | 1,480 | 4/9/2015 |
2.8.0 | 1,395 | 4/8/2015 |
2.7.10 | 1,453 | 4/8/2015 |
2.7.9 | 1,561 | 3/18/2015 |
2.7.8 | 2,034 | 2/25/2015 |
2.7.7 | 1,760 | 2/20/2015 |
2.7.6 | 1,822 | 2/17/2015 |
2.7.5 | 1,671 | 2/12/2015 |
2.7.4 | 1,738 | 2/11/2015 |
2.7.3 | 1,460 | 2/3/2015 |
2.7.2 | 1,420 | 2/2/2015 |
2.7.1 | 1,597 | 1/22/2015 |
2.7.0 | 1,556 | 1/19/2015 |
2.6.8 | 1,628 | 1/2/2015 |
2.6.7 | 2,184 | 12/25/2014 |
2.6.6 | 1,882 | 11/25/2014 |
2.6.5 | 1,668 | 11/24/2014 |
2.6.4 | 2,765 | 10/31/2014 |
2.6.3 | 2,150 | 10/31/2014 |
2.6.2 | 1,631 | 10/23/2014 |
2.6.1 | 1,527 | 10/22/2014 |
2.6.0.1 | 1,493 | 10/21/2014 |
2.5.17 | 1,541 | 10/13/2014 |
2.5.16 | 1,549 | 10/3/2014 |
2.5.15 | 1,448 | 10/2/2014 |
2.5.14 | 1,664 | 9/23/2014 |
2.5.13 | 1,593 | 9/11/2014 |
2.5.12 | 1,507 | 9/10/2014 |
2.5.11 | 1,479 | 9/9/2014 |
2.5.10 | 1,512 | 9/5/2014 |
2.5.9 | 1,571 | 9/3/2014 |
2.5.8 | 1,557 | 9/1/2014 |
2.5.7 | 1,745 | 8/28/2014 |
2.5.6 | 1,572 | 8/19/2014 |
2.5.5 | 1,557 | 8/18/2014 |
2.5.4 | 1,825 | 8/13/2014 |
2.5.3 | 1,653 | 7/31/2014 |
2.5.2 | 1,513 | 7/23/2014 |
2.5.1 | 1,624 | 7/18/2014 |
2.5.0 | 1,654 | 6/30/2014 |
2.4.1 | 1,647 | 5/23/2014 |
2.4.0 | 1,491 | 5/21/2014 |
2.3.3 | 1,523 | 5/16/2014 |
2.3.2 | 1,673 | 5/14/2014 |
2.3.1 | 1,623 | 4/29/2014 |
2.3.0 | 1,604 | 4/21/2014 |
2.2.9 | 1,706 | 4/21/2014 |
2.2.8 | 1,688 | 4/14/2014 |
2.2.7 | 1,685 | 4/9/2014 |
2.2.6 | 1,611 | 4/1/2014 |
2.2.5 | 1,540 | 3/25/2014 |
2.2.4 | 1,535 | 3/20/2014 |
2.2.3 | 1,539 | 3/18/2014 |
2.2.2 | 1,606 | 3/12/2014 |
2.2.1 | 1,506 | 3/6/2014 |
2.2.0 | 1,572 | 3/3/2014 |
2.1.2 | 1,575 | 2/17/2014 |
2.1.1 | 1,577 | 2/10/2014 |
2.1.0.1 | 1,483 | 2/6/2014 |
2.0.16 | 1,568 | 2/4/2014 |
2.0.15 | 1,519 | 2/3/2014 |
2.0.14 | 1,504 | 1/30/2014 |
2.0.13 | 1,562 | 1/29/2014 |
2.0.12 | 1,603 | 1/27/2014 |
2.0.11 | 1,702 | 1/23/2014 |
2.0.10 | 1,550 | 1/22/2014 |
2.0.9 | 1,514 | 1/21/2014 |
2.0.7 | 1,591 | 1/20/2014 |
2.0.6 | 1,548 | 1/17/2014 |
2.0.5 | 1,530 | 1/15/2014 |
2.0.4 | 1,539 | 1/14/2014 |
1.1.8 | 1,545 | 1/21/2014 |
1.1.7 | 1,562 | 1/20/2014 |
1.1.6 | 1,519 | 1/14/2014 |
1.1.5 | 1,512 | 1/10/2014 |
1.1.4 | 1,541 | 12/31/2013 |
1.1.3 | 1,522 | 12/27/2013 |
1.1.2 | 1,507 | 12/12/2013 |
1.1.1 | 1,495 | 12/10/2013 |
1.1.0 | 1,619 | 11/22/2013 |
1.0.7 | 1,608 | 11/21/2013 |
1.0.6 | 1,630 | 11/5/2013 |
1.0.5 | 1,559 | 10/23/2013 |
1.0.4 | 1,512 | 10/22/2013 |
1.0.3.1 | 1,567 | 10/18/2013 |
1.0.3 | 1,536 | 10/18/2013 |
1.0.2 | 1,564 | 10/16/2013 |
1.0.1 | 1,577 | 10/10/2013 |
1.0.0.1 | 1,580 | 10/8/2013 |
1.0.0 | 1,572 | 10/8/2013 |
0.8.10.1 | 1,610 | 10/2/2013 |
0.8.10 | 1,586 | 10/2/2013 |
0.8.9.2 | 1,600 | 10/1/2013 |
0.8.9.1 | 1,848 | 10/1/2013 |
0.8.9 | 1,557 | 10/1/2013 |
0.8.8 | 1,890 | 9/27/2013 |
0.8.7.1 | 1,666 | 9/25/2013 |
0.8.7 | 1,567 | 9/25/2013 |
0.8.6.1 | 1,584 | 9/23/2013 |
0.8.6 | 1,893 | 9/23/2013 |
0.8.5.2 | 1,849 | 9/18/2013 |
0.8.5 | 1,502 | 9/23/2013 |
0.8.4.4 | 1,605 | 8/27/2013 |
0.8.4.3 | 1,651 | 8/27/2013 |
0.8.4.2 | 1,587 | 8/27/2013 |
0.8.4.1 | 1,911 | 8/27/2013 |
- The bug with datasouce popup menu not showing in IE has been fixed.
+ Ability to add new calculated fields by the end-user has been made.
Now users can add new fields to database objects and specify custom SQL
expressions for them. These can be fields intended to perform some
manipulations on real database object fields (concatenation, "if - then"
expressions, etc.) They can also be used to get values from lookup tables.
Of course, the end-user must have the necessary knowledge of SQL language,
so we recommend to turn this feature on only if you know that if will be
valuable for your end-users.
Setting the new QueryBuilderControl.EnableUserFields property to true
enables addition and removal of user-defined fields by the end-user.
+ The new validateCondition and validateExpression methods have been added
to validate values for the Expression and Condition grid cells.
+ The new MetadataContainer.ExportUserFieldsToXML and ImportUserFieldsFromXML
methods have been added to save and restore user-defined fields to a file.
They let keep the user's work between work sessions.
+ The new User Fields demo has been added to demonstrate the new functionality.
+ The new "AllColumns" value can be applied to the UseCustomExpressionBuilder
property of the Grid control. Setting it turns the possibility to edit values
in both Expression and Condition column cells using the custom editor.
+ The new method QB.Web.Application.setUserData(data) has been added. The data
passed to this method will be sent to the server within the next sync event.