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
Saturday, March 31, 2012PrintSubscribe
Auto Select in Data Views

Complex master/detail pages in Code On Time web applications are hiding detail records until a specific master record is selected.

For example, this is the initial state of the Suppliers page in the Northwind sample. This page is capable of rendering a list of suppliers with their respective products. If a master supplier is not selected then the Products child data view is not visible.

The initial state of the master/detail page 'Suppliers' without a selected master record.

Users can click on a link in the first column to activate the Suppliers form view. This will result in the linked products displayed at the bottom of the page below the form.

You can configure an application data view to simulate a click on a link in the first column of the first row as soon as a page loads in the web browser.

Start web application generator, select the project name, and activate the Project Designer.

Select Suppliers / container1 / view1 in Project Explorer.

Page data view selected in the Project Explorer

Enable property “Auto Select First Row” under Presentation section of the data view properties and click OK to save the changes.

Data view property 'Auto Select First Row' in the Project Designer

Click Browse on the tool bar and navigate to the Suppliers page. The very first row in the master view of suppliers will be selected. Products from the selected supplier are displayed beneath the form view.

Property 'Auto Select First Row' causes automatic execution of the first action in the action group with the 'Grid' scope.

Setting the Auto Select First Row property to True causes automatic execution of the first action in the action group with the “Grid” scope.

The default configuration of this action group in shown next. As you can see the first row will be selected in the form view editForm1 if a user clicks on a link in the first column. The same effect is caused by Auto Select First Row property when page loads in the web browser.

Action group with scope 'Grid' expanded in Project Explorer

Right-click action group ag1 and select Show All Actions option.

Context menu of the action group in Project Explorer

Select the action group ag2 in Project Designer and click Up on the tool bar.

Changing the order of actions in the action group

The hierarchy of nodes in Project Explorer will change. Action a2 with command name Edit is now the first action in the action group ag1 with the scope of “Grid”. Note that this action does not have a view specified as the command argument.

Modified action group in Project Explorer

Click Browse button on the tool bar of Project Designer and navigate to the Suppliers page once more. The first row is selected and presented in edit mode.

'Edit' action executed without an argument on a page with the master data view that has its property  'Auto Select First Row' set to 'True'

Saturday, March 31, 2012PrintSubscribe
Auto Highlight in Data Views

The following screen shot shows the automatically generated page Suppliers from the Northwind sample. If you navigate to the page and sort or filter records then only the master data view Suppliers is visible.

Standard master/detail page 'Suppliers' in the 'Northwind' sample created with Code On Time web application generator

Click on any data row and it will become highlighted. Linked detail records will be displayed at the bottom of the page.

Linked 'Products' are displayed if a user clicks on a master row of 'Suppliers' view

Sometimes it may be desirable to highlight the first row in the master view automatically.

Start the application generator, click on the project name, choose Design, and select the master data view of the page in Project Explorer.

Data view selected in Project Explorer

Check the box labeled “Auto Highlight First Row” under the Presentation section of the data view properties and click OK.

'Auto Highlight First Row' property of a data view

Click Browse button on the tool bar to view the page in the web browser.

The very first visible row will be automatically highlighted. Linked details will be displayed as well.

The initial state of the page loaded in a web browser if 'Auto Highlight First Row' property of the master view is enabled

Friday, March 30, 2012PrintSubscribe
What is Windows Azure Platform?

Azure Factory allows rapid development of web applications for Microsoft Windows Azure cloud. In minutes you can create cross-browser web applications that look similar to the one in the picture.

Sample Azure Factory application created with Code On Time

Curious what Windows Azure is? Read on or take a look at the Azure Factory tutorial explaining how to create an Azure Factory project and deploy it to the cloud with Code On Time web application generator.

What is Windows Azure Platform?

Windows Azure Platform is a cloud hosting service run by Microsoft that enables you to store data, as well as build and connect apps. Everything is stored in a Microsoft data center - the only thing you have to manage is your application. The applications are hosted on cloud operating systems called Windows Azure. This operating system serves as a runtime for your application. While it can't be accessed directly, it can be interacted with using the Azure Portal. You can create, edit, and delete hosted services, and storage accounts. Rich SQL Azure reporting capabilities are also present.

What is the Windows Azure Platform?

Typical "On-Premise" Application Setup

The usual application setup in your own on-premise data center will include the following items:

  • Firewall
  • Load balancer
  • Application server
  • Database server
  • Other services (access control, security)

This setup will take an exhaustive amount of time and money to implement, and that's just the hardware side. You will also need to install the operating systems and configure them to work together. And how long will this system run until you have to start updating, patching, and fixing everything? When traffic increases, you'll also have to scale this system. Windows Azure offers a better solution.

Typical 'On-Premise' Application Setup

Using Windows Azure

Switch your application to Windows Azure - all the hardware is stored in a Microsoft data center, and there is no need to manage the operating system. All you have to do is deploy your application to the cloud, and everything will take care of itself. This allows you to focus on adding business value and key features to your applications.

With Azure Factory, your job becomes even easier. Point to your database and press Generate. In a few minutes, you will have a full featured web application that is sure to impress peers and customers. Then, press Publish, and you will have everything you need to deploy to Windows Azure.

Using Windows Azure

SQL Azure

Windows Azure allows you to store and run your application in the cloud. SQL Azure will store the the data for your application. It is a relational database using SQL technology, that runs in the Azure cloud. Use the online Database Manager provided by Microsoft, or connect to the database with SQL Server Management Studio 2008 R2. SQL Azure also supports T-SQL.

The database is highly scalable - availability will increase with demand, and price will be dictated by usage. All data is distributed across many nodes, with at least three copies, to insure fault tolerance. If one copy goes down, another copy is automatically activated to insure a seamless experience.

SQL Azure

Continue to Azure Factory