Code Generator

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
Code Generator
Saturday, December 8, 2012PrintSubscribe
HR Sample App (Oracle)

Sample database HR (Human Resources) comes standard with Oracle database server. Let’s create a web application straight from this database.

Getting Oracle on Your Computer

First, download the Oracle Database Express Edition 11g Release 2 installation files.

When the download is complete, extract the zip folder. Run the file at DISK1\setup.exe. Follow the steps to install Oracle Express Edition 11g on your computer.

When the database server has been installed, log in to the management website. The link to the page is available at C:\oraclexe\app\oracle\product\11.2.0\server\Get_Started.url. In the web browser, click on the Application Express tab, and create a workspace in order to access the database.

Native vs. Managed Data Provider

Code On Time web application generator creates web apps based on Microsoft ASP.NET, a component of Microsoft.NET technology. Database vendors offer middleware that allows ASP.NET applications to communicate with their servers. Oracle offers two providers:

The ODP.NET (Oracle Data Provider) is included in the Oracle Data Access Components (ODAC) for Windows package. The provider is a managed .NET wrapper that “speaks” to unmanaged native API of Oracle database server.

Because of this mix of managed and unmanaged code, there is a need to install both 32-bit and 64-bit versions of ODP.NET when working with Windows 7 and 8. Some components of development tools for Windows support only 32-bit architecture. Each version of ODP is around 230 MB in size.

The ODP.NET, Managed Driver is less than 2 MB in size and written purely in .NET. It has better performance and is easier to configure. This is the recommended .NET provider for ASP.NET web applications.

Click on one of the links above and install one of the providers for Oracle.

Creating a Web Application

Start the code generator, and click on the Create a new web application link on the start page. Select Web Site Factory to create the project.

Creating a 'Web Site Factory' project on the New Project screen.

Assign the project a name of “HR”, select the programming language of your choice (C# or Visual Basic), and press Create.

Assigning a name of 'HR' to the project.

Leave the default Namespace and Framework values and press Next.

Select the desired ODP provider in the Data Provider dropdown, and click on the “…” button next to Connection String field to access the Oracle Connection screen.

Selecting the 'Oracle Data Provider for .NET, Managed Driver' for the Data provider dropdown on the Database Connection screen.

'Oracle Data Provider for .NET' data provider selected. The '...' button next to Connection String field will activate the 'Oracle Connection' screen.

Enter your Server name, User name, and Password in the appropriate fields.

If you are working with Oracle Express Edition and using ODP.NET Managed Driver, leave the Server name blank. If you are using ODP.NET , then enter “127.0.0.1” in the Server name.

Press the Test button to test the connection string.

Alert showing that test connection succeeded for the Oracle connection string.

Press OK to dismiss the Connection Status window, and press OK to insert the configured connection string into the field.

Press Next twice to reach the Reporting page. Check the box to enable reporting.

Enabling reporting for the web application.

Press Next to reach the Themes page. Select Social from the list box.

Selecting a theme for the web application.

Hold down Shift, and press Next to skip to the Summary screen.

Activating the 'Generate' button on the Summary screen.

Press Generate to start the code generation. A window will open in your default web browser with the web app when complete.

Generated web application loaded in the default web browser.

Learn how to configure Custom Membership and Role Provider for your Oracle database.

Friday, October 19, 2012PrintSubscribe
Order Form Sample–Part 6

You will now be on the Database Connection page. If you are using a free version of the generator, you are limited to 10 tables. You can select tables to generate by clicking on the Change link underneath the Connection String field. Include the following tables: Categories, Customers, Employees, Order Details, Orders, Products, Shippers, and Suppliers.

image

If you have a licensed version, you can skip selection of tables.

Once the database connection has been set up, keep pressing Next until you reach the Reporting page. Check the box to enable reporting, and press Next.

image

On the Authentication and Membership page, you can see that ASP.NET Membership has automatically been configured, provided that you installed the membership on the connection string page. If membership had already been added to your database previously, you can just click on Status button on the connection string page to make Code On Time configure the settings automatically.

image

Press Next, and you will be taken to the Features page. Under Page Header, insert “Order Form Sample”.

image

Switch to the Permalinks and History section, and enable both checkboxes.

image

Press Next twice to reach the Theme page. Select Modern theme. You can view samples of all the themes at http://codeontime.com/learn/introduction/user-interface/themes-a-c.

image

Hold down Shift key, and press next to skip to the Summary page. Press Generate.

image

When the generation is completed, the new web application will open in your default browser.

image

Friday, August 31, 2012PrintSubscribe
Creating a New Web App

Let’s create a new Web Site Factory project.

Start Code On Time web application generator and select Web Site Factory under New Project.

Creating a Web Site Factory project on the Start Page of Code On Time web application generator.

The next page will prompt to specify a name and programming language of the project.

Select the programming language of your choice and specify the following name:

Property Value
Name MyProject1

Assigning a name and programming language to the new project.

Press Create button to create the project.

The next page allows changing the Namespace and the version of Microsoft .NET Framework. Leave the default values and press Next.

Configuring the namespace and .NET Framework for the project.

This page allows specifying the Data Provider and Connection String. Select your data provider from the list.

This tutorial uses Microsoft SQL Server database engine. If you do not have a database server, consider installing Microsoft SQL Server 2012 Express.

Click on the button to the right of the Connection String field to open the Connection String Configuration page.

Selecting a Data Provider and activating the Connection String Configurator.

If you have SQL Server Express edition, specify the following:

Property Value
Server .\SQLEXPRESS
Database Northwind
Sample Tables Northwind

To the right of Database field, click on the Create button and confirm to create the database.

Creating a new database on the specified server on the Connection String Configuration page.

To the right of the Sample Tables dropdown, press Install and confirm to populate the project database with the Northwind dataset.

Installing Northwind database tables and data into the specified database.

Code On Time does not offer tools to design databases. Use your favorite database management tools, such as Microsoft SQL Server Management Studio, to work with the database schema.

Our application will have built-in user and role management system. Code On Time applications rely on the security infrastructure available in ASP.NET.

Under Membership section, press Add and confirm to add ASP.NET Membership to the database.

Adding ASP.NET Membership to the database.

You will see a confirmation when the membership has been configured.

Press OK to finish configuration of the database connection string.

Configuration of the database connection string has been finished in a Code On Time web application.

If you are using a trial version of the application generator, the project size is limited to 10 tables or views. To select a subset of tables for the project, click the Change button next to “All database tables and views are included in this project”. Include the following tables: Categories, Customers, Employees, EmployeeTerritories, Order Details, Orders, Products, Shippers, Suppliers, and Territories.

Selecting database tables and views to include in the project.

Press Next twice to reach the Reporting configuration page. Enable dynamic and static reports in the application.

Enable reporting by checking the box on the Reporting Page of the Project Wizard.

Hold down Shift key and press Next – this will skip directly to the Summary page. Press the Generate button to start creation of the web application.

Summary page of the Project Wizard.

When generation is complete, the web site will open in your default browser.

Web Site Factory web application running in a web browser.