ASPRunner Professional: Build Database Web Apps Fast with No Coding

Top Features of ASPRunner Professional — Complete User Guide

Overview

ASPRunner Professional is a low-code tool for quickly creating database-driven web applications from databases like SQL Server, MySQL, PostgreSQL, Oracle, and SQLite. It generates secure, responsive web interfaces (CRUD pages, reports, and dashboards) while letting developers customize logic, layout, and security.

Key Features

1. Visual Project Builder

   • Drag-and-drop page layout and field positioning.
   • Table-to-page mapping automates generation of list, view, add, edit, delete pages.
   • Project preview with instant local testing.

2. Multi-Database Support

   • Connects to SQL Server, MySQL, PostgreSQL, Oracle, SQLite, and ODBC data sources.
   • Automatically reads schema, relationships, indexes, and constraints.

3. Prebuilt Page Types

   • List, View, Add, Edit, Delete pages.
   • Search and Advanced Search builders with multiple condition support.
   • Reports (summary, grouped) and charts for visual analytics.
   • Master–detail pages and nested grids for related data.

4. Security & Authentication

   • Built-in user registration, login, and role-based access control.
   • Supports LDAP/Active Directory and cookie/session management.
   • Granular permissions per table, page, and field.

5. Custom Business Logic

   • Server-side event handlers (Before/After record add/edit/delete, page load).
   • Client-side JavaScript hooks for custom UI behavior and validation.
   • Ability to embed custom SQL and stored procedures.

6. Responsive UI & Theming

   • Modern responsive templates compatible with desktop and mobile.
   • Theme customization: CSS editing, template overrides, and layout tweaks.

7. Reporting & Export

   • Export data to CSV, Excel, PDF, and printable reports.
   • Custom report templates and parameterized reports.

8. Charts and Dashboards

   • Built-in chart types (bar, line, pie) with grouping and aggregation.
   • Dashboard pages combining lists, charts, and summary widgets.

9. Performance & Optimization

   • Pagination, server-side sorting, and filtering to handle large datasets.
   • Query optimization via indexes and custom SQL options.

10. Deployment Options

    • Generates deployable ASP.NET (Classic or MVC) projects or PHP projects (depending on version).
    • One-click publish to IIS or FTP; manual deploy options for custom servers.

11. Audit Trails & Logging

    • Change logging for record history; configurable audit fields (created_by, modified_by).
    • Application logs for debugging events and errors.

12. Internationalization

    • Multi-language support and localization for labels, messages, and date/number formats.

13. Extensibility & Integrations

    • API endpoints for integration with other systems.
    • Ability to call external services from server-side events or JavaScript.

Typical Workflow (Step-by-step)

1. Connect to your database and select tables/views.
2. Let ASPRunner read schema and auto-generate pages.
3. Customize pages: layout, fields, and visibility.
4. Configure security: user roles and permissions.
5. Add business logic with server events or client scripts.
6. Build reports and dashboards.
7. Test in preview mode, then export/generate code.
8. Deploy to your web server (IIS/FTP or PHP host).

Best Practices

• Design your database schema with clear keys and foreign keys for accurate master–detail pages.
• Use server-side validation for critical business rules; reserve client-side for UX.
• Apply role-based permissions to sensitive pages and fields.
• Optimize heavy queries with indexes and server-side pagination.
• Keep custom code modular in events and external scripts to simplify upgrades.

Limitations & Considerations

• Generated code may require manual adjustments for complex customizations.
• Licensing costs and platform-specific deployment requirements vary by edition.
• For highly specialized UI/UX needs, deeper front-end work may be necessary.

Resources

• Official documentation, tutorials, and sample projects (check vendor site).
• Community forums and example code for custom event handlers and integrations.

If you want, I can generate a concise quickstart checklist, a sample event-handler script, or a deployment checklist for IIS/PHP—tell me which.