Connecting to database Home

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using ASPRunner.NET
Working with projects
Connecting to the database
Datasource tables, list fields, searchable fields
Choose pages
Login page
User login settings
Avanced Security Settings
User group permissions
Fields order and totals
Miscellaneous settings
Choose theme
Visual Editor
About
Toolbars
Page Elements
Formatting options
Validation types
Lookup wizard
Events
Output directory settings
After you done
FTP upload
FrontPage Publishing
Advanced topics
ODBC
Master-details relationship
Troubleshooting "Operation must use an updateable query" errors
Connecting to database
Connecting to MS Access database
Connecting to MS SQL Server database
Connecting to MySQL database
Connecting to Oracle database
Publishing ASP.NET application to the remote Web server
Using FTP client to publish ASP.NET pages to the remote Web server
Using FrontPage to publish ASP.NET pages to the remote Web server
Events
More about events
Predefined actions
Send simple email
Send email with new data
Save new data in another table
Insert a record into another table
Check if specific record exist
Display a message on the WEB page
Redirect to another page
Custom code
Sample code
Show list of customer orders
Before deleting a record check if related record exist
Check if start date is earlier then end date
Speed up data entry using events
Frequently Asked Questions
Error: Could not load type ...
Error: Login failed for user '(null)'
Error: Login failed for user 'MACHINE_NAME\IUSR_MACHINE_NAME'
Error: Operation must use an updateable query
Error: Syntax error in UPDATE statement
Error: Syntax error in INSERT INTO statement
Error: Could not find MySQL ODBC 3.51 driver
Error: Client does not support authentication protocol
Error: Could not access CDO.Message object
How can I add new ODBC Datasource
I cannot find ODBC Administrator applet on Windows 2000 machine
I cannot connect to my Excel (Access) database
Order ASPRunner.NET online

 
  ASPRunner manual


Working with projects

 

Project structure

With ASPRunner.NET, you can save all your settings in a single project file and do not have to go through individual files if you simply need to change a single label or field format.

For each project ASPRunner.NET saves to its own directory with the following subdirectories:

  1. visual - Contains modified visual templates.

  2. tmp - Temporary storage of visual templates.
  3. output - Directory with output files. You can change or rename the Output directory.

The default directory for a new project is projects/project_name. The Project file will be saved in the project directory as project_name.netr.

When you open a project created with a previous version of ASPRunner.NET, you are prompted to choose a project directory. After you select a directory, your project file is copied to it. Then the next time you open your project it will be from the folder you selected, not from the original location.

If you upload files to the Web server using third party FTP client software, you must upload the entire contents of the output directory.

When you make a backup of your project, you should include all files in the project directory together with all subdirectories. At a minimum, you should backup the project file itself along with all files in the visual directory.

Click the "Project" button and select from the drop down list to open an existing project or to save the current one.

Creating new a project

When you create a new project you have two options:

  • Create a new project from scratch using Application Wizard

  • Create a project from the template

More info on templates that are shipped with ASPRunner.

Opening an existing project

To open existing project or save a current one, click Project button any time.

Saving a project

If you want to save the current project under a different name - for example, development purposes or to create a backup - select the "Save Project As" option. A new project directory will be created and all necessary project files will be copied to it.

Note: ASPRunner.NET creates a new project automatically upon startup.

The CHM file was converted to HTML by chm2web software.