Master-detail relationship 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.NET manual


Speed up data entry using events

 

On ADD page you might want to prepopulate some edit boxes with recently used values. This can be done using combination of Default values and BeforeAdd Event.

Let's say at the end of day you need to enter several data records for each Order. To prepopulate EmployeeID, ShipVia and Freight fields with last entered values you need to the following:

1. Set Default values of those fields to Page.Session("EmployeeID"), Page.Session("ShipVia") and Page.Session("Freight") respectively. This can be done on the Formatting tab.

2. Use BeforeEdit Event to save EmployeeID, ShipVia and Freight values in Session variables

Page.Session("EmployeeID") = parNewValues(1).value

Page.Session("ShipVia") = parNewValues(5).value

Page.Session("Freight") = parNewValues(6).value

All examples are for Framework 1.1, VB.NET language.

The CHM file was converted to HTML by chm2web software.