Blog: Posts from March, 2012

When creating a new order, the order date should default to the current date.

Switch back to the Designer, and expand the Orders controller in the Explorer. Expand Fields, and double click on OrderDate.

In the Code Default property, write:

DateTime.Now

Press OK to save the field. Press Generate in the top left corner, and wait for the page to load. Navigate to Order Form, and create a new order. Select a customer and employee. You will see that the current date has been inserted into the Order Date field.

Now that the Order Form page has been set up, we will want to customize several settings. First, we shall optimize the Orders controller. The list of order is currently displayed in alphabetical order of Customer Company Name. It would make more sense to sort the orders according to the date the order was made. Switch back to the Designer, and open the “dv100” Orders data view in the Explorer. Double click on grid1. Scroll down to the Sort Expression field, and enter “OrderDate desc” (do not enter the double quotes).

Press OK to save the view, and press Generate to regenerate the application. If you navigate to Order Form page, you will see that the orders are sorted in descending order of Order Date.