NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
ASP.NET SQL Where Builder Control for Creating Ad Hoc
3432
ASP.NET SQL Where Builder Control for Creating Ad Hoc
http://www.truecontent.info/winscripts/aspnet_sqlwherebuilder.php
SqlWhereBuilder is a web control which provides a user interface for generating custom SQL WHERE clauses. Designed to support ad hoc reporting needs, users add conditions through the interface, and developers use either the GetWhereClause() or GetWhereClauseWithParameters() method upon postback to compile the chosen conditions into a string of text suitable for inclusion in a SQL WHERE clause. The SqlWhereBuilder control was developed with the following considerations:
User interaction should be handled client-side, preventing the need for server postbacks with every condition manipulation
Where possible, take advantage of functionality provided server-side through ASP.NET.
The SqlWhereBuilder web control provides a friendly interface for a user to enter query conditions, which may be compiled upon postback into a SQL WHERE clause. As an ASP.NET server control wrapping a JavaScript library, user-interaction happens entirely client-side, while on the server, additional functionality such as XML-based configuration and integration with IDbCommand objects is implemented. ASP.NET > Scripts and Controls > Database Tools Oct 10, 2006 Mike Ellison
User interaction should be handled client-side, preventing the need for server postbacks with every condition manipulation
Where possible, take advantage of functionality provided server-side through ASP.NET.
The SqlWhereBuilder web control provides a friendly interface for a user to enter query conditions, which may be compiled upon postback into a SQL WHERE clause. As an ASP.NET server control wrapping a JavaScript library, user-interaction happens entirely client-side, while on the server, additional functionality such as XML-based configuration and integration with IDbCommand objects is implemented. ASP.NET > Scripts and Controls > Database Tools Oct 10, 2006 Mike Ellison
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
Other links at ASP.NET > Scripts and Controls > Database Tools
Access2MySQL Pro is a reliable bi-directional database migration tool which allows you to convert from:
MS Access to MySQL
MS Access to MySQL Dump
MS Access to PHP Script
MS Access to MS Access
MySQL to MS Access
MySQL to MySQL.
MySQL to MySQL Dump
MySQL to PHP Script
MS Access to MySQL
MS Access to MySQL Dump
MS Access to PHP Script
MS Access to MS Access
MySQL to MS Access
MySQL to MySQL.
MySQL to MySQL Dump
MySQL to PHP Script
Category:
100% runtime managed code.
Requires no OLAP-servers to work. It's possible to install the Library on any web site with ASP.NET support.
An ability to create any multidimensional cube at the time when application is running. Cubes may be created dynamically on the base of any queries from different tables.
Easy settings. The component doesn't require disk space to hold temporary OLAP-data.
Calculation "on the fly".
Comfortable interacting. Users may perform all operations no need to use intricate expressions of MDX-language.
Automatic updating of OLAP-cube in background mode. Users are still able to work with the cube while it's being updated, so they will not even notice that something's happening until the cube updating has finished.
Supports user groups, sorting, filtering by dimension members. Can filter by any combination of dimension members in any dimension.
Supports hierarchical dimensions described by "Parent-Child" relations. Both "balanced" and "unbalanced" hierarchies are supported. No restrictions for the amount of hierarchical levels.
Supports "snowflake" schema.
Requires no OLAP-servers to work. It's possible to install the Library on any web site with ASP.NET support.
An ability to create any multidimensional cube at the time when application is running. Cubes may be created dynamically on the base of any queries from different tables.
Easy settings. The component doesn't require disk space to hold temporary OLAP-data.
Calculation "on the fly".
Comfortable interacting. Users may perform all operations no need to use intricate expressions of MDX-language.
Automatic updating of OLAP-cube in background mode. Users are still able to work with the cube while it's being updated, so they will not even notice that something's happening until the cube updating has finished.
Supports user groups, sorting, filtering by dimension members. Can filter by any combination of dimension members in any dimension.
Supports hierarchical dimensions described by "Parent-Child" relations. Both "balanced" and "unbalanced" hierarchies are supported. No restrictions for the amount of hierarchical levels.
Supports "snowflake" schema.
Category:
Search, navigate, sort, update, add, delete, export, upload, link, filter, nest, print, copy and much more ...
Cross-browser, IE and Firefox supported
Designed with performance and scalability in mind. See DbNetGrid run against 300,000 records.
Seamless integration with MS Office.
No coding required. Integrated GUI designer interface.
Browser based. Design and run from anywhere. No client installation required. No Java requirement. Pure DHTML.
Fully encapsulated component. Integrates easily with any web page.
Grids can be linked or nested together to create powerful drill-down web reports.
Integrates with other DbNetSuite components.
Generate robust web-based applications.
Extensive database support. Works with SQL Server 2000, MSDE 2000, SQL Server 2005, SQL Server Express 2005, Oracle, Firebird, Sybase, DB2, MySQL, Access, Visual FoxPro, InterSystems Cach?, Informix, Advantage and Pervasive
Simple server-based licensing.
Fully customisable.
Cross-browser, IE and Firefox supported
Designed with performance and scalability in mind. See DbNetGrid run against 300,000 records.
Seamless integration with MS Office.
No coding required. Integrated GUI designer interface.
Browser based. Design and run from anywhere. No client installation required. No Java requirement. Pure DHTML.
Fully encapsulated component. Integrates easily with any web page.
Grids can be linked or nested together to create powerful drill-down web reports.
Integrates with other DbNetSuite components.
Generate robust web-based applications.
Extensive database support. Works with SQL Server 2000, MSDE 2000, SQL Server 2005, SQL Server Express 2005, Oracle, Firebird, Sybase, DB2, MySQL, Access, Visual FoxPro, InterSystems Cach?, Informix, Advantage and Pervasive
Simple server-based licensing.
Fully customisable.
Category:
Aspose.Total for .NET offers 18 different, high power components for one low price! Furthermore, if any new components are released within a year of your purchase - you will receive them absolutely free. With Aspose.Total you will be able to create robust, scalable solutions sure to satisfy any need. You will be able to programmatically manage some of the most popular file formats used in business: Word, Excel, PowerPoint, Project, PDF and Flash. Aside from the powerful file management components Aspose.Total also contains components for charting, email, spell checking, barcode creation, ad hoc query generation, recurrence patterns, network protocols and workflow. Aspose.Total is your true value solution. We encourage you to download the FREE evaluation version to see how this great suite of components can work for you!
Category:
How does the BuilderEditor ASP.NET component work?
The BuilderEditor component generates the data entry forms used to insert and edit data based on the data source schema. The data source schema is inferred from the data source to which the BuilderEditor component is bound at design-time (see Figure 1). If the data source doesn't exists at design-time, for example when it is typed directly in code, you can specify the data source schema directly using the Fields editor (see Figure 2).
The BuilderEditor component generates the data entry forms used to insert and edit data based on the data source schema. The data source schema is inferred from the data source to which the BuilderEditor component is bound at design-time (see Figure 1). If the data source doesn't exists at design-time, for example when it is typed directly in code, you can specify the data source schema directly using the Fields editor (see Figure 2).
Category:
Main Category
165
2028
756
275
169
1801
1074
892
1127
7088
70
874
58
2145
170
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 18673
Categories: 1275
Registered Users: 537
Mailing List Subscribers: 2031
Unique Outgoing Hits: 192560
Pagerank Statistics
PHP News