Blog: Posts from March, 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 March, 2012
Friday, March 2, 2012PrintSubscribe
Generating the Web Application

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 button underneath the Connection String field. Include the following tables: Categories, Customers, Employees, Order Details, Orders, Products, Shippers, and Suppliers.

Select tables for Order Form web application

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.

Reporting page in Code On Time web application generator

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.

Authentication and Membership screen in Code On Time web app generator

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

Web Application Features Pages in Code On Time Generator

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

Permalinks and Interactive History Option in Code On Time Generator

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.

Theme Selection Page in Code On Time Generator

The next page allows you to change the language of the application, or enable multiple culture sets. Keep the default of en-US, and press Next twice. When the Summary screen comes up, press Generate.

Summary Page in Code On Time Web App generator

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

Baseline Code On Time Generated Application

Friday, March 2, 2012PrintSubscribe
Installing ASP.NET Membership

Microsoft has created ASP.NET Membership as a built-in method of validating and storing user credentials, allowing you to manage users and roles and have an integrated security solution without any effort on your part. Industry-standard security practices are found in the design of the membership database tables and API. Leading database vendors have implemented their own versions of ASP.NET Membership.

If Code On Time detects that ASP.NET Membership tables and views are integrated by your database, then it will generate a fly-over login dialog, self-service membership enrollment, membership bar, and membership manager for your application.

ASP.NET Membership can be added to any database via the Database Connection page.

Under Membership section, press Add button, and confirm to add membership.

Install ASP.NET membership on SQL Server Connection Page in Code On Time web application generator

Code On Time application generator will install ASP.NET Membership in your database and notify you upon completion. You will see the installation log at the bottom of the web application generator window.

Press OK on the confirmation window, and press OK to exit the Database Connection Configuration screen.

Thursday, March 1, 2012PrintSubscribe
Installing Northwind on Microsoft SQL Server

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 2008. Select your data provider from the list, and press the “…” button to compose a connection string.

Database Connection String page in Code On Time web application generator

Enter your server name, credentials, and enter “Northwind” in the Database field.

A typical project will start with selection of an existing database. For this example, we will create a new one. Press Create to the right of Database field, confirm the creation, and the database will be created.

SQL Server Connection Page in Code On Time web app generator

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

Installing Northwind database in SQL Server Connection page in Code On Time generator

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