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 5 - Searching, Grid and Form view, custom hyperlink to form

Same as Demo 4, but using Company name as hyperlink to form.

Search CompanyName :

Records per Page :

Record (1..20) of 2155 Page 1 of 108

# CustomerName OrderDate RequiredDate ProductName

1 Vins et alcools Chevalier 7/4/1996 8/1/1996 Queso Cabrales

2 Vins et alcools Chevalier 7/4/1996 8/1/1996 Singaporean Hokkien Fried Mee

3 Vins et alcools Chevalier 7/4/1996 8/1/1996 Mozzarella di Giovanni

4 Toms Spezialitäten 7/5/1996 8/16/1996 Tofu

5 Toms Spezialitäten 7/5/1996 8/16/1996 Manjimup Dried Apples

6 Hanari Carnes 7/8/1996 8/5/1996 Jack's New England Clam Chowder

7 Hanari Carnes 7/8/1996 8/5/1996 Manjimup Dried Apples

8 Hanari Carnes 7/8/1996 8/5/1996 Louisiana Fiery Hot Pepper Sauce

9 Victuailles en stock 7/8/1996 8/5/1996 Gustaf's Knäckebröd

10 Victuailles en stock 7/8/1996 8/5/1996 Ravioli Angelo

11 Victuailles en stock 7/8/1996 8/5/1996 Louisiana Fiery Hot Pepper Sauce

12 Suprêmes délices 7/9/1996 8/6/1996 Sir Rodney's Marmalade

13 Suprêmes délices 7/9/1996 8/6/1996 Geitost

14 Suprêmes délices 7/9/1996 8/6/1996 Camembert Pierrot

15 Hanari Carnes 7/10/1996 7/24/1996 Gorgonzola Telino

16 Hanari Carnes 7/10/1996 7/24/1996 Chartreuse verte

17 Hanari Carnes 7/10/1996 7/24/1996 Maxilaku

18 Chop-suey Chinese 7/11/1996 8/8/1996 Guaraná Fantástica

19 Chop-suey Chinese 7/11/1996 8/8/1996 Pâté chinois

20 Chop-suey Chinese 7/11/1996 8/8/1996 Longlife Tofu

Record (1..20) of 2155 Page 1 of 108

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

Aspx Code

						-- Search 

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

							  Search CompanyName : 

							  <asp:TextBox id="CustomerName" runat="server"></asp:TextBox>

						<axp:axpdatagrid
						ID=AxpDataGrid1
						Runat=Server

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

						GridLinkIndex=8-- Col 8 is Hyperlink to form

						GridFieldsShow="8,16,17,21"-- Column numbers

						FormCellWidths="160,300"-- Column widths

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

						></axp:axpdatagrid>

						</form>

						
						C# Codebehind extract:

						private string sql = "Select * From Invoices";

						protected System.Web.UI.WebControls.TextBox CustomerName;

						...

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

						{

						if (CustomerName.Text != string.Empty )

						  	AxpDataGrid1.SQL = sql + " Where CustomerName Like '"

						  	+ CustomerName.Text.Replace("'","''") + "%'";

						else

						  	AxpDataGrid1.SQL = sql;

						}

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)