DBGate Samples

Light Theme Dark Theme

Preface

DBGate allows you to create corporate web applications.

It features an ASP.NET Core server-side component that generates REST services from database metadata.
Database developers can customize services using configuration tables like xls.handlers and xls.translations.

Additionally, DBGate includes a JavaScript client-side component for retrieving and updating data via the REST API.
This allows database developers to build corporate web applications for existing databases in just a few hours.

All samples below utilize database-side configurations, except for CSS styles in a few examples.

You can download samples for SQL Server, Oracle Database, MySQL, and PostgreSQL using the SaveToDB SDK.

Sample 01 - Basic Features

This sample demonstrates basic features available with zero configuration.

You can load data from tables, views, and stored procedures, and save data changes back to the database.

Full Article | cashbook | view_cashbook | usp_cashbook | usp_cash_by_months

Sample 02 - Advanced Features

This sample showcases advanced features used to build corporate applications.

For instance, explore dynamic parameter values, filtered drop-down lists, conditional formatting, and UI and data translation.

en-US en-GB de-DE es-ES es-US fr-FR fr-CA it-IT pt-PT pt-BR ru-RU ja-JP ko-KO zh-CN zh-TW

Full Article | usp_cashbook2 | usp_cashbook3 | usp_cash_by_months

Sample 04 - Order Form

This sample illustrates how to embed DBGate forms and use formulas like =[@amount]*[@price].

Full Article

Sample 13 - Data Types

This sample allows you to test supported data types across different .NET, ODBC, and OLEDB data providers.

Full Article

Sample 16 - Symbol Lists

This sample demonstrates how to create forms for managing many-to-many relationships.

Full Article

Sample 17 - Budget Request

This sample shows how to create multi-dimensional input forms with calculated totals and conditional formatting.

Full Article

Sample 20 - Cube App

This sample illustrates how to create forms using the PIVOT operator or JSON output.

Full Article

API Samples

This section provides examples of DBGate API usage.

Full Article

Tab Framework

This sample demonstrates how business users can create applications using the Tab Framework.

Full Article

Gartle Budgeting

Gartle Budgeting is a sample of a budgeting application.

The primary client is Microsoft Excel, but it also functions within DBGate.

Gartle Planning

Gartle Planning is a sample of a planning application.

The primary client is Microsoft Excel, but it also works within DBGate.

Authentication

The examples above use logins with specified passwords for demonstration purposes.

You can access any sample using the following logins with a common password: Usr_2011#_Xls4168

To reset the login, close your browser and reopen the page.

AzureDemo100	sample01_user1, sample02_user3, sample04_user1, sample16_user1, sample17_user1, sample20_user1
gBudgetingApp	ba_analyst_01, ba_accountant_01, ba_admin_01, ba_user_101, ba_user_201, ba_user_301, ba_user_401
gPlanningApp	pa_analyst_01, pa_admin_01, pa_user_01