AxpDataGrid for ASP.net demo

AxpDataGrid for ASP.net

Components

AxpDataGrid for ASP.NET

Product description

Download

Pricing/Buy

Online Documentation

Axezz Forums

Demo 1 - Grid and Edit
With Lookup fields

Demo 1B - Filtering
Using LinkSelector

Select Row, Master-Detail
Using LinkSelector

Calculations
Row summaries

Demo 2 - Form view only
+ Regular expression

Demo 3 - Debug mode
Displays data column
info in Edit Form.

Demo 4 - Larger dataset.
Almost no coding.
Form contains more detail

Demo 5 - Searching

Demo 6 - Master Detail
Two grids

Demo 7 - Vertical Barchart
Simple charting

Demo 8 - Grid-Form
One grid, one Edit form

Demo 9 - Altering appearance
Cell content manipulation Image display

Demo 10 - Rich Text Editor
Html Editor (IE only)
and Calendar Popup

Demo 11 - Scrollable Grid

Visual Studio screen shot

AxpDataGrid is a .Net WebControl and is written in 100% managed code.

The download contains 33 Samples in Visual Basic (VB.net) and C#.

Demo 2 - Form view only

Display a list of detailed records as separate blocks.
Using regular expression replace to highlight words in Notes.

Records per Page :

Record (1..2) of 9 Page 1 of 5

EmployeeID 5

LastName Buchanan

FirstName Steven

Title Sales Manager

TitleOfCourtesy Mr.

BirthDate 3/4/1955

HireDate 10/17/1993

Address 14 Garrett Hill

City London

Region

PostalCode SW1 8JR

Country UK

HomePhone (71) 555-4848

Extension 3453

Photo

Notes Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French.

ReportsTo 2

PhotoPath http://accweb/emmployees/buchanan.bmp

EmployeeID 8

LastName Callahan

FirstName Laura

Title Inside Sales Coordinator

TitleOfCourtesy Ms.

BirthDate 1/9/1958

HireDate 3/5/1994

Address 4726 - 11th Ave. N.E.

City Seattle

Region WA

PostalCode 98105

Country USA

HomePhone (206) 555-1189

Extension 2344

Photo

Notes Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French.

ReportsTo 2

PhotoPath http://accweb/emmployees/davolio.bmp

Record (1..2) of 9 Page 1 of 5

This AxpDataGrid.Net Demo is using MSSQL 2000 Northwind database.

Aspx Code

						<form id="Form1" method="post" runat="server">

						<axp:axpdatagrid
						ID=AxpDataGrid1
						Runat=Server

						ConnectionString="Provider=sqloledb;....."

						SQL="Select * From Employees"

						DisplayType="form"-- Use form mode only

						OrderByFields="2"-- Order by col 2

						RecordsPerPage=2-- Initial pagesize

						RecordsPerPageOptions="2,3,4,5,10"-- Rec per page selection

						FormCellWidths="100,400"-- Column widths

						DisplayNavBar="both"-- Display navigation bar at top and bottom

						></axp:axpdatagrid>

						</form>

						
						C# Codebehind:

						private void Page_Load(object sender, System.EventArgs e)

						{

						// Usa a regular expression to highlight some words in Column number 16 (Notes)

						AxpDataGrid1.SetGridFormatCellFunction(16, "RegExpReplace, /(\\sEnglish|\\sFrench|\\sSpanish|\\sItalian|\\sJapanese|\\sGerman)/gi,<span style=\"background-color:yellow\">$1</span>");
						}

Styles

Stylesheet:

Buttons:

All demos on these pages use the MSSQL 2000 Northwind sample database. The samples in the download is designed to work with the Microsoft Access and MSSQL 2000 Northwind database.

AxpDataGrid works with any OleDB enabled database using standard SQL, e.g. Oracle

The grid view works with any .NET DataSource that can be evaluated as a .Net DataView (this includes DataSet, DataTable and DataView)