| Components |
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 1 - Grid and Edit
|
View and Edit a database table. Row mouse roll-over effect. Some data formatting.
NOTE Database updates are disabled. (Property EditPerformUpdates="False")
|
|
Record (1..20) of 77 |
|
Page 1 of 4 |
|
|---|
|
| # |
ProductName |
QuantityPerUnit |
UnitPrice |
UnitsInStock |
| 1 |
Chai |
10 boxes x 20 bags |
$18.00 |
39 |
| 2 |
Change |
24 - 12 oz bottles |
$19.00 |
17 |
| 3 |
Aniseed Syrup |
12 - 550 ml bottles |
$11.00 |
13 |
| 4 |
Chef Anton's Cajun Seasoning |
48 - 6 oz jars |
$22.00 |
53 |
| 5 |
Chef Anton's Gumbo Mix |
36 boxes |
$21.35 |
0 |
| 6 |
Grandma's Boysenberry Spread |
12 - 8 oz jars |
$25.00 |
120 |
| 7 |
Uncle Bob's Organic Dried Pears |
12 - 1 lb pkgs. |
$30.00 |
15 |
| 8 |
Northwoods Cranberry Sauce |
12 - 12 oz jars |
$40.00 |
6 |
| 9 |
Mishi Kobe Niku |
18 - 500 g pkgs. |
$97.00 |
29 |
| 10 |
Ikura |
12 - 200 ml jars |
$31.00 |
31 |
| 11 |
Queso Cabrales |
1 kg pkg. |
$21.00 |
22 |
| 12 |
Queso Manchego La Pastora |
10 - 500 g pkgs. |
$38.00 |
86 |
| 13 |
Konbu |
2 kg box |
$6.00 |
24 |
| 14 |
Tofu |
40 - 100 g pkgs. |
$23.25 |
35 |
| 15 |
Genen Shouyu |
24 - 250 ml bottles |
$15.50 |
39 |
| 16 |
Pavlova |
32 - 500 g boxes |
$17.45 |
29 |
| 17 |
Alice Mutton |
20 - 1 kg tins |
$39.00 |
0 |
| 18 |
Carnarvon Tigers |
16 kg pkg. |
$62.50 |
42 |
| 19 |
Teatime Chocolate Biscuits |
10 boxes x 12 pieces |
$9.20 |
25 |
| 20 |
Sir Rodney's Marmalade |
30 gift boxes |
$81.00 |
40 |
|
|
|
Record (1..20) of 77 |
|
Page 1 of 4 |
|
|---|
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 Products"
DeleteSQL="Delete From Products"
GridFieldsShow="2,5,6,7"
GridCellWidths=",200,,,130,50,50"
EditOptions="ALL NOVIEW"
EditPrimaryKeys="ProductId"
EditFieldsReadOnly="1"
FormCellWidths="100,300"
DisplayNavBar="both"
RowRollOverEffect="True"
RowClickAction="openform"
></axp:axpdatagrid>
</form>
C# Codebehind:
private void Page_Load(object sender, System.EventArgs e)
{
AxpDataGrid1.AddEditLookup ("SupplierId",
"Suppliers",
"SupplierId", "CompanyName",
"2", false);
AxpDataGrid1.AddEditLookup ("CategoryId",
"Categories",
"CategoryId", "CategoryName",
"2", false);
AxpDataGrid1.SetGridFormatCellFunction(6,"FormatCurrency, 2");
}
|
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)
|