Register  Login  
  September 4, 2010  
ChildLinks Minimize
Print  

User Comments Minimize
From Billy Gordon - Thursday, February 09, 2006

Thanks for providing such a useful module. I use it on our website in several places. (

Billy Gordon

www.vicksburg.org )

 
From Greg Taylor - Thursday, February 09, 2006

You continue to put great things in SGSV, and I can’t say enough good things about it when people ask me how I do some of those complex grids I have on my website. Thank you again and again for a great DNN module.

Greg Taylor - http://www.ghtaylor.com

 
From Roy Dean Leighton - Thursday, February 09, 2006

You are welcome! I really appreciate the work Paul puts into this module. I have found it very useful at displaying data from any database and even formatting the query to include html, though it takes some time, can even produce very readable output.

Thanks Paul, keep up the good work!


Roy Dean Leighton

 
Print  

Free ModulesSQLGridSelectedView V4.1    
Text/HTML Minimize

SQLGridSelectedView V4.1

Here is list of the current features of the SQL Datagrid Display module.

  • 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
  • New Condition Filters
  • Additional Text Search Filter
  • 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
  • New "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
  • OPtional Template base page layout - instead of Datagrid (previously known as SQLPageSelectedView)
  • 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 and MSDE


Settings Form

Print  

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