Blog: Posts from February, 2013

Posts from February, 2013
Thursday, February 28, 2013PrintSubscribe
“Freezing” Data Fields

A common practice in data sheets is to “freeze” a column so that essential information is always displayed for each row. The second generation data sheet allows both freezing columns at run-time, as well as configuring a column to be frozen at design-time.

Freezing at Run-Time

Create a sample Northwind web application. Browse the site, and navigate to the Order Details page. On the action bar, press Actions | Show in Data Sheet.

Changing the grid view to data sheet view.

Activate the column header dropdown for Product Name, and press Freeze.

Activating 'Freeze' option for Product Name column.

All columns up to the frozen column will change color. When the data sheet is scrolled to the right, the frozen columns will continue to be displayed.

Frozen columns 'Order Customer#' and 'Product Name' continue to be displayed when the data sheet is scrolled to the right.

Columns can be added or removed from the freeze by activating the Freeze option for that column. You may unfreeze the column by activating the column header dropdown and pressing Unfreeze.

Unfreezing the Product Name column.

Freezing at Design-Time

Start the Project Designer. In the Project Explorer, double-click on Customers / Order Details / container1 / view1 (OrderDetails, grid1) / grid1 / ProductID –> ProductProductName data field node.

Data field 'ProductID' of view 'grid1'.

Assign a tag.

Property New Value
Tags data-sheet-freeze

Press OK to save the field. On the toolbar, press Browse. On the action bar, press Actions | Show in Data Sheet.

Changing the grid view to data sheet view.

When the data sheet loads, the Product Name column will be frozen by default.

The column 'Product Name' is frozen by default.

The frozen columns can still be changed by the user using the method described in the previous section.

Wednesday, February 27, 2013PrintSubscribe
Configuring Hierarchy

The “hierarchy-parent” tag can be used to present a hierarchical view of information.

Note that hierarchy is only available in the second generation data sheet view.

First, create the HR sample web application using Oracle Database Engine.

Adding a New Page

When generation is complete, activate the Project Designer. On the Project Explorer toolbar, click on the New Page icon.

Creating a new page.

Assign a name to the page:

Property Value
Name Hierarchy

Press OK to save. Drop the new Hierarchy page node on the right side of Home page to place it second in the menu.

Dropping Hierarchy page onto Home page.     Hierarchy page is second in the menu.

Switch to the Controllers tab. Right-click on EMPLOYEES data controller and press Copy.

Copying EMPLOYEES controller.

Switch back to the Pages tab. Right-click on Hierarchy page and press Paste. The data controller will be instantiated as a data view.

Pasting onto Hierarchy page.     The data view has been instantiated as a data view in a container on the page.

Configuring Hierarchy in Data Sheet

Double-click on Hierarchy / c101 / view1 (EMPLOYEES) / grid1 view node.

View 'grid1' of EMPLOYEES controller.

Change the view type.

Property New Value
Type Data Sheet

Press OK to save. Double-click on Hierarchy / c101 / view1 (EMPLOYEES) / grid1 / MANAGER_ID –> MANAGER_LAST_NAME data field node.

Data field 'MANAGER_ID' of view 'grid1'.

Tag the data field as the hierarchy parent.

Property New Value
Tags hierarchy-parent

Press OK to save.

Viewing the Results

On the toolbar, press Browse. The data sheet will now be organized according to the hierarchy.

Hierarchy in the Oracle sample database.

Wednesday, February 27, 2013PrintSubscribe
Enabling Second Generation Data Sheet Preview

Starting with release, web applications created with Premium or Unlimited edition include a preview of the second generation data sheet view. The new implementation supports horizontal and vertical scrolling, column resizing, and freezing. In addition, applications based on Microsoft SQL Server or Oracle also support hierarchical presentation of data.

The preview does not yet support all capabilities available in the original data sheet. The missing features will be released as soon as they become production-ready. Therefore, the second generation data sheet is disabled by default. If you would like to take it for a spin, make sure to regenerate your web app and follow the instructions below.

Start the web application generator. Create a sample Northwind web app. When generation is complete, click on the project name in the start page of the generator. Then, click Develop to open the project in Visual Studio.

In the Solution Explorer, right-click on ~\App_Code folder, and press Add | Add New Item…


Select Class from the list, and assign a name. Press Add to create the file.


Replace the existing code base with the following:


namespace MyCompany.Data
    public partial class ControllerUtilities
        public override bool SupportsScrollingInDataSheet
            get { return true; }

Visual Basic:

Namespace MyCompany.Data
    Partial Public Class ControllerUtilities
        Public Overrides ReadOnly Property SupportsScrollingInDataSheet As Boolean
                Return True
            End Get
        End Property
    End Class
End Namespace

Save the file and run the web app. Navigate to the Customers page. On the action bar, press Action | Show in Data Sheet.


The grid view will render the second generation data sheet.


The second generation data sheet will be enabled by default when the feature set of the previous implementation is replicated.

To use the original data sheet view implementation, make sure that the SupportsScrollingInDataSheet property of class ControllerUtilities returns false.

Continue to EASE Geo Tagging