Blog: Posts from December, 2009

AJAX(112) App Studio(2) Apple(1) Application Builder(244) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(100) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(4) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(17) OAuth(8) OAuth Scopes(1) OAuth2(10) Offline(19) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(171) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) Stored Procedure(4) Teamwork(15) Tips and Tricks(85) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(335) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Posts from December, 2009
Thursday, December 31, 2009PrintSubscribe
Masked Editing, Auto Completion, Inline Record Insertion, New Themes

We are ending the year 2009 with a bang!

Here is list of features available in the latest update.

Grid View Allows Inserting New Rows Inline

Action New is now supported in grid views.


Here is a record in “New” mode displayed alongside of the other records in the grid view.


Masked Editing

Masked editing is supported by components of Ajax Control Toolkit, which provides the foundation for Data Aquarium Framework. Now you can easily enable masked editing in Code OnTime Designer with a a few clicks of a mouse on any field of any data controller. Read about mask format here.


Here you can see the masked editing in action:


Auto-Completion In Views

New attribute Auto Complete Prefix Length on a data field of a view controls the minimum prefix length for auto-completion to start.

You can quickly define this parameter on a data fields with the help of Code OnTime Designer. Pictured below is the data field City of editForm1 view in Customers data controller. The value of the prefix is set to 1.


Here you can see the auto-completion in action:


Server-Side Formatting Of Values

Data Aquarium Framework takes every opportunity to offload the processing of presentation logic to the client browser. The standard formatting of values is controlled by the data field property Data Format String. The actual formatting is done via JavaScript String.format function, which has powerful but limited capabilities if compared to .NET System.String.Format.

Now you can simply un-check the Format On Client box in Code OnTime Designer and additional processing will be performed on the server. The data controller will create a dynamic data field and will provide a formatted value for it. The actual field is aliased to present the dynamic data field in read-only mode.


Here you can see the [Product].[Discount] field formatted in the column five according to the data format string 00.00 shown in the previous screen shot. Note that this particular data format string is not compatible with the JavaScript implementation of String.format.


Html Encoding

Data Aquarium Framework makes sure that user data will not break the presentation when HTML compatible character sequences are entered as field values. Sometimes you might want to have them displayed as an actual HTML.

Suppose you have entered a product category as follows:

Cheeses <b>are great</b>

If you disable HTML encoding for the data controller field directly in the data controller or in Code OnTime Designer then the following will be presented with the phrase “are great” displayed in “bold” font in the Description column of the second grid row.


Improved blob Processing

File upload has just became easier with this release. Now you can simply select a file and the uploading starts instantly. A nice AJAX-style animated image is indicating process.

The previous implementation required user to additionally click on submit button next to the file input control.

Five New Themes

Users with Code OnTime Designer subscription are now able to create applications styled with five new themes. You can see samples of these themes presented in various browsers in this very post.

Wednesday, December 30, 2009PrintSubscribe
Masked Edit Format

Data Aquarium Framework supports client-side masked editing in all views through the JavaScript component MaskedEditBehavior avaiable in  Ajax Control Toolkit. You can see a live sample of this component in action here.

Mask Type 

Type of validation to perform:
None - No validation
Number - Number validation
Date - Date validation
Time - Time validation
DateTime - Date and time validation

Mask Characters and Delimiters

9 - Only a numeric character
L - Only a letter
$ - Only a letter or a space
C - Only a custom character (case sensitive)
A - Only a letter or a custom character
N - Only a numeric or custom character
? - Any character
/ - Date separator
: - Time separator
. - Decimal separator
, - Thousand separator
\ - Escape character
{ - Initial delimiter for repetition of masks
} - Final delimiter for repetition of masks


9999999 - Seven numeric characters
99\/99 - Four numeric characters separated in the middle by a "/"

Here is how you can define a mask directly in the data controller descriptor:

<field name="Phone" type="String" label="Phone" 
maskType="None" mask="999-999-9999" />

Code OnTime Designer fully supports both mask and maskType.

Monday, December 28, 2009PrintSubscribe
Batch/Mass Editing of Multiple Records

Learn how to enable batch/mass editing in ASP.NET AJAX applications created with Code OnTime Generator and Web Site Factory. Batch editing will allow your end-users to modify multiple records at the same time.

Watch this video on our YouTube channel at

Live Demo

You can see live “batch edit” at the following URLs:

Enter admin/admin123% for user name and password if requested.


“Batch Edit” action command allows mass updates of multiple records selected in grid or form view. You need to configure an action that executes BatchEdit command.

If no command is specified then an inline batch editing is enabled in a grid view. If the name for the form is specified as an argument then the action will open the form in “batch edit” mode.

A check box with “update” label is displayed under each field. User must manually include every field that must be propagated to all selected records. The record with sample field values does not have to be selected/included in batch edit.
Multiple records are edited inline in a grid view.


Multiple records are edited in a form.