|
Events are pieces of ASP.NET code that executed before or after
record was added, edited, deleted, when new users registers etc.
Typical events send an email with old or new data record, save data
in another table, check record uniqueness, show related to current
record info.
Typical parameters passed to events
parNewValues - OleDbParameterCollection.
Each field on the Add/Edit form represented as 'Field type'-'Field
value' pair
Example of usage:
-
|
Page.Response.Write(parNewValues(1).OleDbType &"
- "& parNewValues(1).Value) |
Where - WHERE clause that
points to current record to be edited or deleted
Example of usage:
-
|
Dim sSQLSelect As String = "select * from
[Order details] where " & where
Dim cn As New OleDbConnection(func.GetConnectionStr())
Dim cmdSelect As OleDbCommand = New OleDbCommand(sSQLSelect, cn)
cmdSelect.CommandType = CommandType.Text
... |
ASPRunner.NET comes with set of handy predefined code snippets that
you can use in Events.
Sample
code snippets
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
Here are
some real life events
Show list of customer orders
Check if
start date is ealier than end date
Before
deleting a record check if related records exist
Speed up data entry
using events |
