Blog: Posts from October, 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 October, 2012
Friday, October 19, 2012PrintSubscribe
Order Form Sample–Part 7

Let’s create a new page in the application. Switch back to the web application generator, click on the “OrderForm” project name, and press Design.

The design environment allows you to change logical aspects of the project, and consists of two primary elements. The Project Designer, on the left side of the screen, displays a list of objects or properties of the selected object. On the right side of the screen, the Project Explorer allows you to browse and manipulate pages, controllers, and user controls. At the top of the screen, there are several buttons. The Generate button regenerates the web application and displays it in a built-in browser window, called Preview. The Browse button will regenerate the application and open it in your default browser. The Exit button goes back to the web application generator.

The Project Browser and Project Explorer panes of the Project Designer window.

Let’s add a new page called Order Form. In the toolbar of the Project Explorer, press the New Page icon.

New Page context menu option on the toolbar of the Project Explorer.

Give this page the following settings:

Property Value
Name OrderForm
Description This is the order management form.
Style Miscellaneous
About This Page This is the order management form.
Roles (blank)

Press OK to save the page. The page will be added to the bottom of the hierarchy. Drag the new Order Form page node to the right side of Home node to place it second in the hierarchy.

Dropping Order Form page node on the right side of Home page.    Order Form page has been placed second in the hierarchy.

We’ll need to add a container to this page to store the data views. In the Explorer, right-click on the Order Form page, and press New Container.

New Container context menu option on a page node in the Project Explorer.

None of the default properties need to be changed, so just press OK to save the container.

Let’s instantiate two controllers on the page. In the Project Explorer, switch to the Controllers tab. While holding Ctrl key, select Orders and OrderDetails nodes in that order. Right-click and select Copy.

Copy context menu option for Orders and OrderDetails controllers.

Switch back to the Pages tab. Right-click on the container and press Paste. The data controllers will be added to the container as data views.

Paste context menu option on container 'c101' in the Order Form page.     Orders and OrderDetails instantiated as data views on the Order Form.

Drag Order Form / c101 / view2 (OrderDetails) / grid1 / OrderID data field node onto Order Form / c101 / view1 (Orders) data view node. This will configure a master-detail relationship between the two views, with OrderID as the filtered field.

Dropping OrderID data field node onto view1 data view node to establish a master-detail relationship.     Master-detail relationship established between view2 and view1.

Double-click on Order Form / c101 / view2 (OrderDetails) data view node. Change the following settings:

Property New Values
Page Size 300
Show View Description false
Show View Selector false
Show Pager None

Press OK to save the data view. In the Project Explorer, right-click on Order Form page node, and press View in Browser.

View in Browser context menu option for Order Form page node.

Wait for the web application to be generated, and it will open in your default browser. Log in, and you will see Order Form page on the menu bar and the site map.

Order Form page present on the site menu and site map.

Click on the Order Form link, and you will see a list of orders.

A list of orders displayed on the Order Form.

Select an order, and relevant order details will appear underneath.

When an order is selected, order details are displayed underneath.

Thursday, October 18, 2012PrintSubscribe
Order Form Sample–Part 4

The Database Connection page is the first page you will see after creating a new project. This page allows you to specify your data provider and connection string. We will be using Microsoft SQL Server 2012. Select your data provider from the list, and press the “…” button to compose a connection string.

Button to activate the database connection string page.

A typical project will start with selection of an existing database. For this example, we will create a new one. Enter your server name, credentials, and enter “Northwind” in the Database field.

Property Value
Database Northwind

Press Create to the right of Database field, confirm the creation, and the database will be created.

Database with the name of 'Northwind' created on the specified server.

Under Sample Tables, select Northwind from the dropdown. Press Install, and confirm. This will install the Northwind sample database into the specified server.

Installing the Northwind sample into the specified database.

You can monitor the progress in the log at the bottom. The web app generator will notify you upon completion.

Thursday, October 18, 2012PrintSubscribe
Order Form Sample–Part 3

Let’s create a baseline Code On Time Web Site Factory application. Run the web app generator, and select Web Site Factory project type. If you have already created a project previously, click on the Create new web application link under the list of projects to access the New Project screen.

Create a new Web Site Factory project.

Web Site Factory project type is based on a directory structure. Files will be compiled upon saving to the hard drive. Web Site Factory is suitable for an application of any complexity and is the easiest to manage. If you’re starting web development or coming to ASP.NET from other technologies, then this is the project type for you.

In the Name field, enter “OrderForm”. This will be the name of the folder that stores the project, and will be the display name shown on the start page of the code generator. Select the programming language of your choice, and press Create.

Specify the name for the project, as well as the programming language of your choice.

When finished, press Next. This will create the project.

On the next page, you can enter the Namespace, which will be used throughout the whole application. The namespace is a prefix used in all classes of the generated code base. We’ll leave the default name “MyCompany”. You can also change the Framework to either .NET 3.5 or 4.0. The latter is suggested, as it has better performance.

This screen allows changing the Namespace and Framework of the project.

Press Next to continue to the next page.