After you successfully connected to the database, select all datasource tables you'd like to build C#/VB.NET code for. Next, highlight one of the selected tables and proceed through the other screens in ASPRunner.NET adjusting settings for the selected table.
You can always see the name of the currently selected table in the middle of the blue info pane on top. To switch between selected tables, use the Table list pane on the left.
Type in the name, type, size, scale (applies to the DECIMAL field type in SQL Server, Oracle and MySQL only) for each field. Set the Primary key field. Click Create table.
To edit or delete the tables, right-click the table name in the list.
Synchronizes the database.
Opens Menu Builder.
Arranges tables alphabetically.
Shows all fields in all tables.
Hides all fields in all tables.
Opens the Label Editor where you can change the table captions.
Opens the Table link properties window where you can add new table relations.
Shows/Hides fields for the currently selected table.
Opens the Create SQL script window where you can create SQL scripts for tables/data transfer to another server.
Searches the table names.
To open the context menu of a table/view/chart/report/dashboard, click near its name or right-click the table.
The Change caption option allows editing caption and field labels. Click the Advanced option to change the base table for view/chart/report or filename prefix.
Since the view, chart, and report may include fields from several tables, the base table is the table where the data is added, edited, and deleted. Key columns can be selected for the base table on the Choose pages screen.
By default, the prefix for each generated file name is the table name. E.g., if the table name is OrderDetails, the file name of the List page becomes OrderDetails/list. If you change the prefix to details, the file name becomes details/list.
Click Create custom View to create an additional view of the same table. This feature is useful if you want to present several views of the same data.
When you create a new custom view, all current settings of the table are copied into it, except for visual templates and events. You can create a copy of an existing custom view: right-click the custom view and select Copy.
The Cars table shows all cars in the database. SQL query: select * from Cars.
The Active listings view displays only the active listings. SQL Query: select * from Cars where status='active'.
The Closed listings view displays only the closed listings. SQL Query: select * from Cars where status='closed'.
The SQL query can be modified later on the SQL query screen in ASPRunner.NET.
Every time you make changes on the Datasource tables screen (e.g., create a new table, add or edit table fields, etc.), make sure that these changes are synchronized with the database. The structures of the database and ASPRunner.NET project should be synchronized.
To synchronize the database manually, use the Sync database button or right-click the table tree or blank area near the table tree and select Sync database.
The tables that were renamed outside of ASPRunner.NET or deleted in ASPRunner.NET are moved to the Deleted tables folder. You can restore, rename and restore, or remove the selected table from the project permanently.
Right-click the Deleted tables folder to get two options: Remove all tables and Restore all tables.
You can add multiple data sources and mix several database types like MS Access, SQL Server, and MySQL in a single ASPRunner.NET project. You can have a master table in MySQL and a details table in MS Access. The same applies to lookup tables.
To add a new database connection:
•click Add connection;
•select the database type and connect to the database.
The first database connection is considered "primary". However you can make any other connection primary by right-clicking the database name and selecting the corresponding option.
The following features work only with the primary database connection:
•Add template to project - the template can be only added only to the primary database.
•Upload to demo account - the tables from the primary database are uploaded to the demo account.
All other features work with all database connections, including the Save project as template option.
We do not recommend to add tables with the same names that belong to different database connections in order to avoid conflicts.
REST API Connections
ASPRunner.NET is able to display data received from the third party REST APIs. In order to create such a REST View you need to add a REST API connection.