Blog: Posts from January, 2010

Labels
AJAX(112) App Studio(6) Apple(1) Application Builder(245) 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(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) 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(18) OAuth(8) OAuth Scopes(1) OAuth2(11) Offline(20) 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(178) 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(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Posts from January, 2010
Sunday, January 31, 2010PrintSubscribe
Universal Annotations and Dynamic Field Configuration

We are announcing immediate availability of two new features in Web Site Factory and Data Aquarium Framework premium projects. The features are included in the latest release of the product and are available to all subscribers to the Premium Projects.

Universal Annotations

This feature allows end users to extend any data records exposed by your application with custom annotations and attachments. Users can activate this feature on demand and enter notes and attach any number of files. The notes and attachments are stored outside of the application database in a specified folder.

You can activate this feature for the entire application or for individual data controllers.

The live demo is available at http://dev.codeontime.com/demo/annotations/pages/customers.aspx.

Click on the link above and sign in as admin/admin123% or user/user123% . Select any customer record and press edit button. Action Annotate will become available on the action bar of the form.

image

Click on Annotate button and the screen will transform as follows. New category Notes and Annotations is dynamically added to the form layout.

image

Enter a note and attach a few files. The screen will transform into the following. The category Notes and Attachments will move to a dedicated tab. Each note and attachment are presented as fields of the data record.

image

This feature requires no coding and may prove to be invaluable when end users are in the need of custom fields that were not incorporated in the database by design.

Note that users in role Administrators are allowed to add and delete notes and attachments. All other roles are only allowed to add new notes and attachments . Every note and attachment label incorporates the user name, email, and time-stamp.

Dynamic Field Configuration

Dynamic field configuration allows to provide data-driven run-time properties of individual data fields.

Here is the dynamic configuration of ProductName field in Products data controller.

image

Expression HeaderText=CategoryCategoryName will force the Data Aquarium Framework to use the name of the product category as the HeaderText of the field.

You can see this in action at http://dev.codeontime.com/demo/annotations/pages/products.aspx.

The grid view automatically uses the category name of the first record on the page or the category name of the selected product as a header text of the first column.

image

The same affect is taking place when you view your data in a form.

image 

You can override dynamically many properties of any field in a data controller through stored or calculated database table columns any properties of the fields in a given row. Open ~/App_Code/Data/DataField.cs(vb) to see available data field properties.

image

Dynamic field configuration is a great addition to the arsenal of developers building extensible data driven applications.

Sunday, January 24, 2010PrintSubscribe
Floating Data Field Layout

The new floating layout of data fields allows automatic hypertext-like display of data fields in Web Site Factory applications. The floating layout can be applied to any data field category in a form view. You can see this in action at http://dev.codeontime.com/demo/websitefactory1/pages/employees.aspx if you select an employee record.

image

The layout is useful when you have a large number of fields in your database tables. The forms will automatically adjust themselves when you edit the record or resize the window. Here is the same form in edit mode. Notice that the field composition is not the same this time.

image

You can make this form even more compact if you request the field category to start the new column.

Here is the same record with the floating category of data fields that was configured to start the new column.

image

Here is the same record in edit mode.

image

You can instruct the code generator to start all form view categories in the new column and use the floating field layout on Features page of the project settings.

image

Thursday, January 14, 2010PrintSubscribe
Ad Hoc Reporting

Learn to create ad hoc reports in Web Site Factory projects.

We will show how to create an ad hoc report based on a business object layer class generated by Code OnTime Generator. Then we will replace the business object layer object with a ControllerDataSource component.

Watch this video on our YouTube channel at http://www.youtube.com/watch?v=wAeNRB-kdLY.

We will create a dataset with a table adapter based on a free-form SQL query or optional stored procedure. Then we will replace ControllerDataSource component in the AJAX web application created in the first part of the tutorial with an ObjectDataSource hooked to the data table adapter.

Watch this video on our YouTube channel at http://www.youtube.com/watch?v=T_FYskbhYCM.