Register  Login  
  March 11, 2010  

ModulesSQLGridSelectView    
Text/HTML Minimize

SQLGridSelectedView V5.1

Here is list of the New Features in Current release:

  • Horizontal Selections
  • Selection Ordering -- define the order of selection displayed
  • Ability to define Go button location (top, bottom, top right, button right, ...)
  • Implementation of Intermodule communication (IMC)
  • Better AJAX support (now can export if SGSV placed in Update Panel)
  • GridView used to display data (instead of datagrid from asp.net v1.1)
  • Localization of Setting screen
  • Addition of help (? icon)  on Setting screen
  • Ability of Remember Selections by user
  • Search words added so you can "find" module via search
  • Addition of several CSS classes to improve selection display
  • Additional Selection Filters (up to 8)
  • Additional Condition Filters (up to 8)
  • Additional Date Range Filters (up to 4)
  • Additional Date List Filters (up to 4)
  • Additional TextSearch Filters (up to 8)
  • Date Range can be display stacked on two lines
  • New settings persistence model based on XML
  • Supports import of SQLGridSelectedView V4 Settings
  • Ability to Set Column Header Text
  • Ability to remove a column from Grid
  • Revised User Guide of over 50+ pages - many examples

Existing features of the SQL Display module Version 4:

  • Designed for simple or complex selects
  • Supports Stored Procedures
  • Allows for selection based on Date
  • Allows for selection based on Text value
  • Allows for selection bases on Populated Dropdown values
  • Allows for Creating and/or Editing of Data
  • Optionally Sortable columns
  • 3 Different Types of Paging
  • Export to Excel via CSV or Text file
  • User definable delimiter in export file
  • Optional Column Headers
  • Optional Column Summaries
  • Group by phrase support for complex Selects
  • Parameter substitution for DotNetNuke®  Values
  • Parameter substitution for Session Variables
  • Parameter substitution for Query String Variables
  • Parameter substitution for Selection Parameter
  • Connection String may be defined in Web.Config
  • Support for OLEDB and ODBC connections
  • Works with MSSQL tables or MS Access tables
  • Will work with any database that support a ADO.NET interface
  • Configurable Column Formats - including Width, Alignment and Format
  • Condition Filters
  • Header and Footer Sections
  • Module.css included with default classes
  • Calendar Select Option on Date Selection Filter
  • Filter Selection allow different Display and Selection values
  • Single "Go" Button with the ability to define the button label text
  • "Reset" Button option
  • Ability to set text for Record Count, Page Count and Time Stamp
  • Sortable Customer Format Columns
  • Option on the Text Search to allow multiple entries
  • Option on Filter Selection to use Multi-Select List Boxes
  • Option to display SQL Command on SQL error

Please Note: The addition of a Module.css will overwrite any privately created or modified Module.css - Please backup the module.css if you have made any changes to this file.

Print  

Text/HTML Minimize

Generated Selection Page

Following Examples included as Import File base on the NorthWind Database included with SQL Sever 2000 (also available to download for SQL 2005)


Example1

Example2

Example3

Example4

Example5

Example6

Settings Form

Settings

Print  

  Home | Blog | Forum | Subscriptions | Free Modules   Page generated in 0.100144 seconds.
  Copyright 2010 by TressleWorks   Terms Of Use | Privacy Statement