Self promotion can be difficult especially if it's not in your nature.  In my case, I find it difficult.  However, I received a forum post from a new subscriber to my site that indicated that he had been looking of a SQL Grid display module for some time and just discovered my module.  So I guess it is time to do some self-promotion.

So what is SQLGridSelectedView?  First let's take a look a the name:

  SQL - indicates the use of SQL to query a database
  Grid - indicates the typical display format although templating is available
  Selected - indicates the ability to filter the selection of data 
  View - the primary focus is to view data, but creating and updating data is possible.

SQLGridSelectedView is also known as SGSV.  The module is primarily a database data viewer at heart, but provides many options in the way the data is displayed.  My sample site has examples of the various types of selections and displays possible.

The module allows access to any database that can be described via a connection string. ODBC, OLE and SQL Native provider support is available.  I am aware of users connecting to all version of SQL Server, plus MS Access, Excel, Oracle, MySQL, and even RDB!.

SQLGridSelectedView can provided selections for Conditions, Date Lists, Date Ranges, Data Lists (sub-selects), and Text.  You can define applied CSS by data conditon, format colums (handy for dates as SQL does a rather poor job of this) and add summaries and  various sorting options.

SQLGridSelectedView provides several types of export such as CSV, Html, Text, and PDF.

SQLGridSelectedView supports Inter-module communication. This means that one SQLGridSelectedView (SGSV) module can pass information other SGSV modules on the same page. SGSV module can be used to define the selected view and these selections can be passed to SGSV modules to display various different views of data based on the selections.  See this example using the NorthWind database.

Additionally, SQLGridSelectedView provides the ability to edit data -- the traditional Create, Update and Delete capabilities are provided -- the focus of this feature to maintain configuration data as validation is limited.

There is a 80+ page user guide (here) that describes the various features of the module.

Hope this review has peaked your interest in SQLGridSelectedView.  If you are working at display data from the database check it out.

Paul.