Web Application Generator

Labels
AJAX(112) App Studio(9) 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(178) 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(184) 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(3) 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
Web Application Generator
Monday, June 25, 2012PrintSubscribe
Formatting Data Fields

The Data Format String is used to format the value of a field before it is presented to the end user. It can be specified on the field itself, and will be applied to all instances of the field bound to the views (data fields). If it is specified on the data field level, then only that data field will use the data format string.

The Unit Price data fields in the Products controller are assigned the currency data format string of “c” by default.

On the Products page, the Unit Price field uses a standard currency data format string.

Let’s  assign the data field on the grid view a different format string.

Start the Project Designer. In the Project Explorer, double-click on Categories / Products / container1 / view1 / grid1 / UnitPrice data field node.

Unit Price data field in grid1 view on the Products page.

Change the Data Format String property:

Property New Value
Data Format String c4

Press OK to save the data field. On the toolbar, press Browse, and wait for the web application to load in your default browser.

Navigate to the Products page. The Unit Price data field on the grid view will be formatted with four numbers after the decimal place.

Unit Price data field in grid view shows 4 numbers after the decimal place.

Select a record. The Unit Price data field on the edit form will be formatted with the standard two numbers after the decimal place.

The Unit Price data field in the edit form uses the standard currency data format string.

Monday, June 25, 2012PrintSubscribe
Format On Server

Format strings are used to format data before presentation to the end user. There are standard numeric and date/time format strings. In addition, custom date/time format strings can be created. The formatting is performed in the client web browser by default.

Microsoft.NET offers rich data formatting capabilities. Developers may request formatting of field values on the server to take advantage of everything it has to offer.

For example, the Unit Price field in the Order Details controller uses the standard currency format string of “c”. An application with en-US culture will format the number as a currency with a dollar sign on the left, period as a decimal separator, and parenthesis's to indicate negative values. The $0.00 indicates a zero value.

Unit Price field with default format string of 'c'.

Server-side formatting offers additional field value formatting options.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab and double-click on Order Details / Fields / UnitPrice field node.

UnitPrice field of OrderDetails controller.

Change the following properties:

Property New Value
Data Format String 000,000.00;(000.00);Zero Value
Format On Client False

The data format string is a custom numeric format string. Positive, negative, and zero value strings are separated by a semicolon.

Press OK to save the field. On the toolbar, click on the Browse button to generate the web application.

Navigate to the Order Details page. The values in Unit Price field will be formatted according to the custom numerical format string. All eight digits will be displayed. Zero values will be represented with the text “Zero Value”.

Unit Price field using server-formatted custom numeric format string.

Notice that when the row is in edit mode, the values of fields formatted on the server will be displayed in raw form.

When the row is in edit mode, the values of fields formatted on the server will be displayed in raw form.

Monday, June 25, 2012PrintSubscribe
Where is my Stuff?

The “Navigate To” feature allows direct navigation to an item in the Project Designer.

It can be activated by clicking on the Navigate To icon in the Project Explorer toolbar, or by pressing the “Ctrl+,” keyboard shortcut (press “Control” key simultaneously with “Comma” key).

Navigate To icon on the Project Explorer toolbar.

This action will open the Navigate To window. In the Search terms field, enter text describing the project configuration element that you are trying to locate. The list of possible results will appear underneath as soon as you finish typing. The yellow box will show details of the selected item, with the search term highlighted.

Let’s try this feature with the Northwind sample.

When the word “Products” is typed in the Search terms field, the first matched result will be the Name property of the Products page.

Navigate To with 'Products' as the search term.

Press OK button or the Enter key to navigate to the selected result. The node containing the result will be highlighted in the Project Explorer. The node will also open in the Project Designer.

Products page selected in the Project Explorer.

Activate Navigate To, and search for “reportsto”. Results matching the exact phrase will be displayed in the Result box.

Navigate To with 'reportsto' as the search term.

Search for “reports to”. Exact matches will be listed first, followed by partial matches. Select the command from the result list. The yellow box will display all instances of each individual word.

Navigate To with 'reports to' as the search term.

Search for “order details”. Matches of identifying attributes of project configuration elements will have the highest priority in the results. Combinations of the words in the search parameter come next.

Navigate To with 'order details' as the search term.

Search for “order details”, wrapped in quotation marks. This will only find exact matches of the search term.

Navigate To with 'order details' including quotation marks as the search term.

You can mix quoted phrases and unquoted words, such as in the example below.

Navigate To allows search of combinations of quoted phrases and unquoted words.