Blog: Posts from October, 2012

Saturday, October 20, 2012Print Subscribe

Let’s change the length of the data field text boxes to match the expected text length.

In the Project Explorer, right-click on Orders / Views / editForm1 / c1 – Orders node, and press Show All Data Fields.

This will open a grid of data fields in the Project Browser window. Mouse over the field Freight, click on the dropdown activator, and press Edit.

Enter “5” in the Cols property, press Save to save the data field.

Also change the following data fields:

Field Name	Cols
ShipName	30
ShipAddress	30
ShipCity	30
ShipRegion	30
ShipPostalCode	30
ShipCountry	30

Press Browse, and wait for the page to load. Start editing any order, and you will see that the data fields have been resized.

Labels: Designer, Tutorials, Web Application Generator

Saturday, October 20, 2012Print Subscribe

Order Form Sample–Part 12

There are only three shipping companies in the Northwind database. By default, the web application generator renders the ShipVia field as a lookup.

A lookup is very useful when there is a long list of options, as it offers sorting, filtering, and quick find. In this situation, the lookup is just a hindrance to the user. Let’s change this lookup to a drop down list.

In the Project Explorer, switch to the Controllers tab. Double-click on Orders / Fields / ShipVia (Int32) –> Shippers node.

Change the following settings:

Property	New Value
Items Style	Drop Down List
Data Value Field	ShipperID
Data Text Field	CompanyName

Press OK to save. Press Browse, and wait for the page to load. If you edit an order, you will see that Ship Via Company Name field is now a drop down list.

Labels: Designer, Tutorials, Web Application Generator

Saturday, October 20, 2012Print Subscribe

Order Form Sample–Part 11

When creating a new order, the fields ShippedDate, ShipVia, and Freight are not known. Let’s remove these fields from the createForm1 view.

Switch back to the Designer, and expand Order Form / c100 / view1 / createForm1 / c1 – New Orders node. While holding Shift key, highlight the fields ShippedDate, ShipVia, and Freight. Right-click and press Delete option in the context menu.

Press Browse and wait for the application to load. If you create a new order using the Order Form, you will see that the data fields have been removed.

Labels: Designer, Tutorials, Web Application Generator