Contents

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using ASPRunner.NET
Working with projects
Connecting to the database
Datasource tables
Master-detail
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
"View as" settings
"Edit as" settings
Validation types
Lookup wizard
Events
Output directory settings
After you done
FTP upload
FrontPage Publishing
Advanced topics
Master-details relationship
AJAX-based Functionality
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
Demo Account
What is the Demo Account
Terms and conditions
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
Order ASPRunner.NET online

 
Home
ASPRunner.NET 5.0 manual
Prev Page Next Page
 
 

Connecting to database

 

ASPRunner.NET supports the following databases:

  • MySQL

  • Oracle

  • Microsoft SQL Server

  • MS Access

Select your database type and press Next>>. Depending on the selected database type you will see one of the database-specific dialog boxes shown below.

 

Connecting to MySQL - type the Host/Server Name (usually localhost), user name, password and click Connect.

Select Database and click Next >>.

 

Connecting to Oracle, Microsoft SQL Server - type the Database Name, username, password and click Connect.

Connecting to MS Access (ODBC Data Source) - browse for database file. Press Open when done.

Check Create a databse copy in App_Data folder if you want relative path to be used in database connection string. Please also specify the path name if the database is located at a subfolder from the root. Use this option if you plan to transfer files to the remote Web server. In this case ASPRunner.NET creates a copy of database in the Output folder. ASP.NET pages will work with this database file copy which means you won't see changes in original database file.

Press Next>> when done.

Click the Recent database button to see a list of recently opened databases. You can use this button to quickly connect to previously opened databases.

After you successfully connected to database, it is time to select datasource tables.

 

Converted from CHM to HTML with chm2web Standard 2.83 (unicode)