DbNetGrid

	Home Features Designer Testimonials Reviews Download Purchase Online Upgrading

Features

Overview
Scalable
Sort
Chart
Mail Merge
Save
Search
Edit
User Profiles
Align
Apply Style
Columns
Transform
Totals & Subtotals
Linking
Nest
Drag'N'Drop
Copy
Print
Databases
Multi-Lingual

Overview

DbNetGrid is a fully encapsulated AJAX enabled grid component designed for use in Intranet/Internet development. It provides a fast and flexible way of presenting and updating database information in a browser environment. DbNetGrid can be used as a simple grid component integrated with your own applications, a web-reporting tool or as part of a fully functional web-application. No need to write any code. Grids can be generated from the DbNetGrid::Designer interface.

DbNetGrid can be added easily to existing HTML/ASP or ASP.NET in a few seconds pages and can be used in conjunction with tools such as VS.NET and Dreamweaver MX. DbNetGrid can be configured with as little as 3 lines of code.

DbNetGrid has a massive array of capabilities that you can activate with a few lines of code saving hundreds of man-hours of development time. These capabilities include:

• Update, insert and delete records (including custom validation).
• Point and click re-ordering.
• Search dialog (with the ability to use the full range of SQL relational operators)
• Ability to export results in HTML, Word, Excel or XML formats.
• Create charts using MS Excel
• Link to MS Word and perform automated mail-merges

• PC
• IE5+/Firefox 1.0+

• IIS4/5/6 (Internet Information Server)
• Microsoft .NET Framework 1.0+
  

Back to Top

Scalable

DbNetGrid has been designed to perform not just against small datasets of a few hundred records but against large datasets that are often encountered in a real-world production environment. DbNetGrid unique server-side architecture means that it only ever holds one row of data in memory at any one time.

This means that DbNetGrid is not only fast but scales in applications with a high degree of concurrency. This can contrast markedly with other grid components which load the entire dataset into memory on the server which can have a crippling effect in a multi-user environment.

Back to Top

Sort

Click on any column title to sequence the rows by the data in the selected column. Click again to reverse the sequence.

Click on the sort button () in the toolbar to invoke the Sort Dialog. From here you can create nested ordering and apply it to the grid.

Back to Top

Chart

Represent your data graphically by combining DbNetGrid data with MS Excel charting features

Back to Top

Mail Merge

Combine DbNetGrid data with MS Word letter templates to create powerful mail-merging capabilities

Back to Top

Save

Click on the Save button () to

save the results in HTML, Word, Excel or XML format.

Data in Excel format.

Back to Top

Search

Use the comprehensive searching facilities in the Search Dialog to find data.

Exploit the full power of SQL with a simple user-friendly dialog.

Pop-up lookup windows for easy selection of coded search criteria

Create even more powerful queries by combining search dialog criteria using the Composite Search Dialog

Back to Top

Edit

Pop-up calendar for date fields

Make changes to the data using the feature rich Edit Dialog

Pop-up HTML Editor for text fields

Built-in file upload capability for links to images and documents

Back to Top

User Profiles

User Profiles allow a user to save a run-time configuration of the grid such as search criteria, sort order or column selections to the database and to then restore that configuration using the User Profile dialog.

In addition to saving grid properties user profiles can also be customised to save the state of other elements on the page and to restore these in conjunction with grid properties.

Align

Correct alignment is automatically applied to columns based on the type of the contained data.

Back to Top

Apply Style

Apply user-defined styles selectively to rows and columns in the grid. E.g.

document.all.dbnetgrid1.setColumnProperty

('city','backgroundColor:orange')

document.all.dbnetgrid1.setColumnProperty ('region','backgroundColor:yellow',/WY/,true)

document.all.dbnetgrid1.setColumnProperty ('region','backgroundColor:darkorange',/WA/,true)

document.all.dbnetgrid1.setColumnProperty ('region','backgroundColor:gold',/SP/,true)

Back to Top

Columns

Select grid columns at run-time.

Back to Top

Transform

Use the powerful transform property to convert

text into images or links.E.g.

document.all.dbnetgrid1.setColumnProperty('image_path','
transform:makeImgElement')
...

function makeImgElement(cell)
{
  cell.innerHTML = '<img src=/images/' + cell.innerText + '>'
]

Back to Top

Totaling & Subtotaling

Back to Top

Linking

Grids can be easily linked together to provide powerful drill-down capabilities.

E.g.

Back to Top

Nest

Use the addNestedGrid method to create powerful tree-view style drill-down capabilities.

Back to Top

Drag'N'Drop

Grid columns can be re-organised or removed from the grid by dragging the column headers

Back to Top

Copy

Copy the grid to the application of your choice via the clipboard.

Back to Top

Print

Send the grid directly to a printer.

Back to Top

Databases

Databases currently supported are:

• SQL Server (7, 2000)
• MSDE
• Access
• MySQL
• DB2 (not DbNetGrid.Net)
• Oracle
• Sybase
• Intersystems Cachй (not DbNetGrid.Net )
• Visual Fox Pro
• Informix
• Advantage
• Firebird

Back to Top

Mulitlingual

All the text values used in the component are stored in a configuration file dbnetlang.xml.

This file can store as many translations as required and each translation can be selected using the dng_lang property. e.g.

Back to Top