| 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 7 - Vertical Bar Chart
|
Simple but efficient bar chart.
|
Record (1..77) of 77 |
|
Page 1 of 1 |
|
|---|
Category  |
Product |
Sales |
|
| Beverages |
Chai |
$4,887 |
 |
| Beverages |
Change |
$7,039 |
|
| Beverages |
Chartreuse verte |
$4,476 |
|
| Beverages |
Côte de Blaye |
$49,198 |
|
| Beverages |
Guaraná Fantástica |
$1,630 |
|
| Beverages |
Ipoh Coffee |
$11,070 |
|
| Beverages |
Lakkalikööri |
$7,379 |
|
| Beverages |
Laughing Lumberjack Lager |
$910 |
|
| Beverages |
Outback Lager |
$5,468 |
|
| Beverages |
Rhönbräu Klosterbier |
$4,486 |
|
| Beverages |
Sasquatch Ale |
$2,107 |
|
| Beverages |
Steeleye Stout |
$5,275 |
|
| Condiments |
Sirop d'érable |
$9,092 |
|
| Condiments |
Original Frankfurter grüne Soße |
$4,761 |
|
| Condiments |
Northwoods Cranberry Sauce |
$4,260 |
|
| Condiments |
Louisiana Fiery Hot Pepper Sauce |
$9,373 |
|
| Condiments |
Louisiana Hot Spiced Okra |
$2,958 |
|
| Condiments |
Grandma's Boysenberry Spread |
$2,500 |
|
| Condiments |
Gula Malacca |
$6,738 |
|
| Condiments |
Genen Shouyu |
$1,475 |
|
| Condiments |
Chef Anton's Cajun Seasoning |
$5,215 |
|
| Condiments |
Chef Anton's Gumbo Mix |
$374 |
|
| Condiments |
Aniseed Syrup |
$1,724 |
|
| Condiments |
Vegie-spread |
$6,899 |
|
| Confections |
Valkoinen suklaa |
$2,173 |
|
| Confections |
Zaanse koeken |
$2,931 |
|
| Confections |
Chocolade |
$1,282 |
|
| Confections |
Gumbär Gummibärchen |
$10,443 |
|
| Confections |
NuNuCa Nuß-Nougat-Creme |
$1,693 |
|
| Confections |
Maxilaku |
$3,129 |
|
| Confections |
Pavlova |
$8,663 |
|
| Confections |
Sir Rodney's Marmalade |
$7,314 |
|
| Confections |
Sir Rodney's Scones |
$5,273 |
|
| Confections |
Schoggi Schokolade |
$10,974 |
|
| Confections |
Scottish Longbreads |
$4,158 |
|
| Confections |
Tarte au sucre |
$21,638 |
|
| Confections |
Teatime Chocolate Biscuits |
$2,987 |
|
| Dairy Products |
Queso Cabrales |
$6,912 |
|
| Dairy Products |
Queso Manchego La Pastora |
$8,335 |
|
| Dairy Products |
Raclette Courdavault |
$35,775 |
|
| Dairy Products |
Mozzarella di Giovanni |
$11,603 |
|
| Dairy Products |
Gudbrandsdalsost |
$13,063 |
|
| Dairy Products |
Gorgonzola Telino |
$7,301 |
|
| Dairy Products |
Mascarpone Fabioli |
$2,669 |
|
| Dairy Products |
Camembert Pierrot |
$20,505 |
|
| Dairy Products |
Flotemysost |
$8,439 |
|
| Dairy Products |
Geitost |
$786 |
|
| Grains/Cereals |
Gnocchi di nonna Alice |
$32,604 |
|
| Grains/Cereals |
Filo Mix |
$2,124 |
|
| Grains/Cereals |
Gustaf's Knäckebröd |
$4,234 |
|
| Grains/Cereals |
Ravioli Angelo |
$2,157 |
|
| Grains/Cereals |
Tunnbröd |
$2,289 |
|
| Grains/Cereals |
Singaporean Hokkien Fried Mee |
$5,408 |
|
| Grains/Cereals |
Wimmers gute Semmelknödel |
$8,056 |
|
| Meat/Poultry |
Tourtière |
$3,184 |
|
| Meat/Poultry |
Thüringer Rostbratwurst |
$34,756 |
|
| Meat/Poultry |
Perth Pasties |
$10,662 |
|
| Meat/Poultry |
Mishi Kobe Niku |
$6,936 |
|
| Meat/Poultry |
Pâté chinois |
$7,833 |
|
| Meat/Poultry |
Alice Mutton |
$17,605 |
|
| Produce |
Manjimup Dried Apples |
$24,571 |
|
| Produce |
Longlife Tofu |
$1,001 |
|
| Produce |
Tofu |
$6,234 |
|
| Produce |
Uncle Bob's Organic Dried Pears |
$9,186 |
|
| Produce |
Rössle Sauerkraut |
$13,949 |
|
| Seafood |
Spegesild |
$2,981 |
|
| Seafood |
Nord-Ost Matjeshering |
$6,034 |
|
| Seafood |
Röd Kaviar |
$3,518 |
|
| Seafood |
Rogede sild |
$3,356 |
|
| Seafood |
Jack's New England Clam Chowder |
$4,957 |
|
| Seafood |
Konbu |
$813 |
|
| Seafood |
Ikura |
$9,936 |
|
| Seafood |
Inlagd Sill |
$6,894 |
|
| Seafood |
Gravad lax |
$629 |
|
| Seafood |
Escargots de Bourgogne |
$2,076 |
|
| Seafood |
Carnarvon Tigers |
$15,950 |
|
| Seafood |
Boston Crab Meat |
$9,815 |
|
|
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 CategoryName, ProductName, ProductSales, Round(ProductSales/300,0) As px From [Sales By Category]"
GridFreeFormatCell="4,<img height=10 width=#px# src='gfx/chartel.gif'>")
RecordPerPage=100
DisplayRecordsPerPageSelect=False
GridDisplayIndex=False
GridDisplayFieldNames="Category, Product, Sales, "
OrderByFields="1"
DisplayNavBar="top"
></ axp:axpdatagrid>
</form>
C# Codebehind:
private void Page_Load(object sender, System.EventArgs e)
{
AxpDataGrid1.SetGridFormatCellFunction(3,"FormatCurrency, 0");
AxpDataGrid1.SetGridColAttributes(4,"align=left");
}
|
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)
|