Asrar Ahmed
New Member
A fully customizable and database-friendly grid component for B4A,
designed to give developers maximum control over rows, columns, styles, and data binding.
Supports both manual column definitions and auto-detection from SQL queries.
---
- Database Integration
- Bind grid to any SQL query withDataSource.
- Auto-detects columns if not defined manually. - Custom Columns
- Add columns manually viaAddColumn.
- Supports column widths, headers, and data types. - Headers & Footers
- Full control over colors, fonts, alignment, and height.
- Frozen columns with independent headers & footers. - Row Customization
- Adjustable row height.
- Alternate row styling.
- Custom cell styles. - Search & Sorting
- Built-in search panel with highlight.
- Auto-detectsORDER BYand shows sort indicators.
- Single-click column sorting. - Frozen Columns
- First column can stay fixed while scrolling horizontally. - Selection Handling
- Customizable selection color.
- Methods for clearing or refreshing selection. - Customizable Grid Appearance
- Grid background color.
- Border visibility.
- Highlight color.
- Theme-friendly. - Performance
- Uses UltimateListView internally for smooth scrolling.
- Supports large datasets.
---
1. Cell Customization
2. Column & Row Customization
3. Database Binding
4. Footers
5. Frozen Column
6. Headers
7. Grid Customization (colors, styles, etc.)
8. Search Queries
9. Sorting
10. Selections
---
1. Copy UltraDBGrid.bas to your project’s Class Modules.
2. Add UltimateListView library to your project.
3. Add UltraDBGrid to your layout or create it programmatically.
---
Code:
' Initialize grid
UltraDBGrid1.Initialize(Me, "Grid")
Activity.AddView(UltraDBGrid1, 0, 0, 100%x, 100%y)
' Add column manually (optional)
UltraDBGrid1.AddColumns("Name", "name", 120dip, UltraDBGrid1.TypeString)
' Bind to database
UltraDBGrid1.DataSource(SQL1, "SELECT id, name, salary FROM employees ORDER BY name")---
(Library + 10 Demo Apps + GIFs)
---
- Tested on B4A 12+ with UltimateListView.
- Current version: v1.01 (Initial Release).
- Feedback & feature requests are welcome!