LT Data Viewer Web Part
The Lightning Tools Data Viewer Web Part can save you time and money as it stops the need for developers to write custom code and allows your end users to easily display and format the data they need to see.
The LTDVWP provides the following benefits:
1. No need for SharePoint Designer. The LTDVWP is configured within the browser.
2. Allows for Integrated Security or provided Username and Password
3. Allows for connection to SQL, Oracle and Access (accdb & mdb) via the configuration of properties. (No need for Connection Strings)
4. Connect directly to Tables/Views and Stored Procedures
5. Supports Aggregate Functions such as Count, Min, Max, and Sum
6. Allows for Conditional Formatting on Cells or Rows
7. Filtering of data
8. Caching of Data
9. Update, Delete, and Insertion of Data
10. Web Part Connections
For a full screen in-depth screencast please click here.
You can also get a trial of the web part by clicking here.
The below image displays the LTDVWP configured to display data from the Northwind SQL Database. Notice the Optional icons to the left allowing for the Editing and Deletion of Data. The CustomID hyperlink provides a connection to another LTDVWP for filtering purposes

(Click on Image to Enlarge)
Once the Edit icon is selected – as long as the logged on user has permissions, they can update the data as shown in the following image.

The Web Part is easily configured via a secondary toolpane allowing for you to select which columns to display, setup aliases, grouping, links, and aggregate functions

Purchase Details
The Web Part is available for only $400 per SharePoint Server. Software maintenance is 20% of the purchase price per year and includes:
- Product updates, including for new versions of SharePoint
- Unlimited technical support via email, phone and remote desktop
Please click here to purchase the LT Data Viewer Web Part.