| Components |
AxpDataGrid is an ASP.NET WebControl and is written in 100% managed code.
* Automatic paging
* Automatic sorting
* SQL Select commands
* Stored Procedures
* .Net DataSources
* Form Editing
* Rich Text Editor
* Lookup values
* Scrollable Grid
* Customizable output
* Powerful
* Easy to use
* Server based
* Supports code-behind
* Integrates with Visual Studio
|
|
 |
|
|
AxpDataGrid 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.
|
|