DB2 Sample Web Application

Labels
AJAX(112) App Studio(6) 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(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(178) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) 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
Tuesday, February 5, 2013PrintSubscribe
DB2 Sample Web Application

The database server DB2 Express-C, provided by IBM, comes with a database called “SAMPLE”. Let’s use Code On Time web application generator to create a web app straight from this database.

Installing and Configuring DB2

The first step is to download the  DB2 Express-C 10.1.2 for Windows 64-bit from the IBM website.

When the download is complete, run the executable. Follow the steps to install DB2 on your computer.

Creating a Web Application

Start the web app generator and click on the Create a new web application link on the start page. On the New Project screen, select Web Site Factory.

Creating a new Web Site Factory application.

Assign a name of “DB2Sample”, select your preferred programming language, and press Create.

Creating a new project called 'DB2Sample'.

Preserve the default Namespace and Framework, and press Next.

Namespace and Framework page of Code On Time project wizard.

From the Data Provider dropdown, select IBM DB2 .NET Data Provider.

Creating a DB2 database connection string.

To the right of the Connection String field, click on the “…” button to activate the Connection String Assistant.

If you are using a locally installed database, use the following configuration:

Database: SAMPLE

If you want to connect to a local database as a different user, use Server of “127.0.0.1” or “localhost”. If you are using a remote database, model your configuration after the one below:

Server: [IP Address]:[Port]
Database: SAMPLE
User name: [User name]
Password: [Password]

Press Test to confirm that the settings are configured correctly.

The connection succeeds when tested.

Press OK to insert the connection string into the field.

Configured connection string inserted into the 'Connection String' field.

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

Enabling reporting for the Web Site Factory web application.

The next page allows configuration of Custom Membership and Role Providers. Leave the default settings and press Next until you reach the Theme page. Select “Summer” from the list box.

Selecting the 'Summer' theme in the Project Wizard.

Hold down Shift key and press Next to skip to the Summary page. Press Generate to create the web application.

The Summary screen of the Project Wizard.

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

Default Employee page of a generated web application from SAMPLE DB2 database.