Blog: Posts from April, 2012

Labels
AJAX(112) App Studio(7) 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(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) 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 April, 2012
Tuesday, April 17, 2012PrintSubscribe
Configuring Data View Selection Mode

The selection mode of data rows on all pages of your application can be controlled in the Project Wizard settings.

You can also configure the selection mode for the specific data views.

Create a Northwind sample and activate the project Designer.

Select Employees / container1 / view1 (Employees, grid1) node on the Pages tab in the Project Explorer.

Data view selected in the Project Explorer

Change Selection Mode property and click OK button to save the changes.

Data view 'Selection Mode' property in Project Designer

Click Browse on the Project Designer toolbar to view the application.

Employees data view with the Selection Mode set to Single.

Employees data view with the 'Selection Mode' set to 'Single'.

Employees data view with the Selection Mode set to Multiple.

Employees data view with the 'Selection Mode' set to 'Multiple'.

The standard action Delete supports the Multiple selection mode. Multiple selection also works with batch editing of records.

You can create custom business rules or an SQL action to implement business logic applicable to multiple selected data rows.

Tuesday, April 17, 2012PrintSubscribe
Configuring Row Selection Mode for the Entire Application

The default configuration of a Code On Time web application is to allow a selection of a single data row on all pages. The screen shot below demonstrates a single row of Suppliers selected in the Northwind sample.

Data row 'Selection Mode' is set to 'Single' in the data view of suppliers in a Code On Time web application

You can enable a multiple row selection on all application pages as follows.

Select the project name on the start page of the application generator and choose Settings.

Select Features in the menu of settings. Activate feature group Grid Properties.

Toggle “on” the option Enable multiple selection in all grid views and click Finish button.

Enabling multiple row selection in all data views on a Code on Time web application

Select Refresh option to refresh the project settings. Click Refresh button without selecting any data controllers.

Press Generate to have the application reconfigured with the new feature. The default web browser will display the application.

Now you can select multiple data rows in all application data views presenting lists of records.

Multiple row selection mode enabled in a data view of a web app created with Code On Time web application generator

Note that only intrinsic Delete action and batch update support multiple row selection.

You can create custom business rules or an SQL action to implement business logic applicable to multiple selected data rows.

You can also enable multiple row selection on individual page data views.

Monday, April 16, 2012PrintSubscribe
Opening a Lookup Window in Search Mode

Lookup windows can display the first page of data, or present search options instead upon activation.

In a sample Northwind application, navigate to Orders page. On the action bar, press New Orders. Click the (select) link in the first data field, Customer Company Name.

Customer Company Name lookup link on New Orders form

The lookup window will show the first page of data rows. The default page size is ten.

Default Customer ID lookup window in Code On Time web application

A user can perform Quick Find or activate the advanced search bar to narrow down the list of available data rows.

Advanced search bar in the lookup window

Let’s activate the search mode immediately when the lookup window is displayed for the first time. This will be useful if the number of lookup records is large. The display of the first page of data has little use in such cases.

Start Code On Time web application generator, click on the project name, and select Design. In the Project Explorer, switch to Controllers tab. Double-click on Orders / Fields / CustomerID node.

Scroll down to the Lookup section. Toggle the checkbox next to Search On Start property.

'Search On Start' property enabled for CustomerID field in Code On Time Designer

Press OK to save the field. On the tool bar, press Browse to generate the application and open it in your default web browser.

Navigate to the Orders page, and create a new order. Activate the Customer Company Name lookup, and you will see the lookup window open in advanced search mode.

Lookup window opened in advanced search mode

Enter the search parameters and press Search to find a record. Alternatively, you can just press the Search button without entering any search parameters, and a full list of customers will appear.

List of records pulled in Customer ID lookup window