ASP.NET SQL Where Builder Control for Creating Ad Hoc Reports

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.

Download Here



Free Vb.Net and ASP.Net Book - Introducing Microsoft Visual Basic 2005 for Developers

Download the whole asp.net book
Get a focused, first look at the features and capabilities in Microsoft Visual Basic 2005, Visual Studio 2005, and the .NET Framework 2.0. If you currently work with Visual Basic 6, these authors fully understand the adoption and code migration issues you'll encounter. They'll step you through a quick primer on .NET Framework programming, offering guidance for a productive transition. If you already work with .NET, you'll jump directly into what's new, learning how to extend your existing skills. From the innovations in rapid application development, debugging, and deployment, to new data access, desktop, and Web programming capabilities, you get the insights and code walkthroughs you need to be productive right away.
For Asp.Net web developers read Chapter 6: Building ASP.Net Web Applications Visual Studio 2005 builds on the innovation introduced in Visual Studio .NET and makes Web development easier than ever before for both experienced and novice Web developers.
Download the whole asp.net book