Audit Log

Open Events tab in ASPRunner.NET. Select Table Events->Edit page->After record updated.

Then click Add action and select Insert a record into another table.

Then modify the code to fit your needs.

Here is the sample code you can use (vb.net 1.1 example):
[codebox] Dim sSQLInsert As String = "insert into AuditTable (ip, name,time) values (@ip, @name, @dt)"

Dim cn As New OleDbConnection(func.GetConnectionStr())
Dim cmdInsert As OleDbCommand = new OleDbCommand(sSQLInsert, cn)

cmdInsert.CommandType = System.Data.CommandType.Text
cmdInsert.Parameters.Add("@ip", OleDbType.VarChar).Value = System.Web.HttpContext.Current.Request.UserHostAddress

cmdInsert.Parameters.Add("@name", OleDbType.VarChar).Value = System.Web.HttpContext.Current.Session("User").UserName

cmdInsert.Parameters.Add("@dt", OleDbType.DateTime).Value = DateTime.Now()
cn.Open()

cmdInsert.ExecuteNonQuery()

cn.Close()

[/codebox]
Put the same code to Add page->After page is added event.
You can also use "Before record updated" event to save record that was changed.