AxpDataGrid for ASP.NET by Axezz Data

Features:

Data retrieval and update.

SQL based.
This datagrid is primarily tuned and optimized for SQL based interaction with databases.

Database support.
AxpDataGrid uses the .NET OleDb data provider. The following databases are supported: Microsoft SQL Server, Oracle, Microsoft Access, Sybase Adaptive Server 9. Using other databases or data sources might work, but no general testing is done for these. As an example of the flexibility offered, it is possible to use Excel as a data source.

Using .NET DataSources.
It is possible to use a .NET data source as input to the grid as long as the data source can be evaluated to a DataView (this includes a DataTable in a DataSet, a DataTable and a DataView). Data can NOT be updated for these types of data sources unless resorting to SQL for the data update.

Stored Procedures.
Database stored procedures can be used as data source for the grid and form view mode, but data updates require SQL.

Presentation and navigation
Paging is automatically supported.

Sorting is automatically supported.

3 main modes: Grid View, Form View and Form Edit.
It is possible to have different view of the data in each mode. The Grid and Form View can f.ex. be based on a join query and have different formatting functions set. The Form Edit is SQL based and works against single database tables.

Data Editing Features

Lookup values.
Data edit lookup values can be set by specifying the Lookup database table and fields or by supplying a .NET DataTable. The latter can be created from a database, from XML, in memory or by a range of other means (ref. .Net documentation)

Pure Data Entry Form.
It is possible to have a data entry form without a grid view. This can be further restricted to having data entry where the only allowed action is adding new records.

Data validation.
Simple datatype validation is automatically performed by the grid.

Custom validation.
Server side validation code can be added. The grid does not use the .Net Validation Controls.

Rich Text Editor.
A simple but effective Html based editor is supplied as open source.

Custom lookup pages.
It is possible to add custom data lookup pages (e.g. a calendar lookup).

Fields properties.
Visibility, size, disabled state, readonly state and so on can be set per field.

Excel Export
The grid supports export to Excel of all the data in the current recordset.

Look and Feel
Settings for colors, fonts, grid lines, graphics, button colors etc. are set in CSS files and a few GIF files. The grid is currently supplied with 35 stylesheets.

Cross-Browser
The grid requires that javascript is enabled and a decent browser. Functionality is regularly tested for the newest version of MS Internet Explorer, Mozilla, Mozilla Firefox and Opera. Grid scroll functionality works 100% in IE, and to a lesser extent in Mozilla / Opera.

Data Formatting
Several data formatting possibilities exists with the grid. Simple formatting can be set using utility functions. More elaborate formatting in code behind. Please see the sample application and the documentation for some ideas.

Scrollable Grid
Grid scroll functionality works well in IE, decent in Mozilla, and OK in Opera. The scalable (to 100%) scrollable grid functionality works in IE only, other browsers will just display the grid without scrolling.

A few technical notes
AxpDataGrid is an alternative, not a descendant of the asp.net DataGrid. It is written from the ground up as a .net WebControl. It is a fast light weight datagrid with a small footprint. Due to the fact that it does not utilize ViewState, the size of the generated Html page will be significantly smaller than if you use the asp.net DataGrid.