Remote Dataset Page

Navigation:  Quick Start Guides > Cloud Storage Based App >

Remote Dataset Page

Previous pageReturn to chapter overviewNext page

The Dataset Page is used to display data from the database.

1) DB List View Page will be used to fetch and display the database table information in the form of list.

2) DB Record View Page will be used to display all or selected fields of the table corresponding to each list item from the DB List View Page.

 

1)Create DB List View Page

 

Step 1: Click on New from the menu to create a new Page.

 

mobilous_appexe_npe_myproject_menubar_file_options

 

Step 2: Enter name of the page in "Set Page Title" section and select the DB List View  page.

 

mobilous_appexe_npe_myproject_dblistview

 

Step 3: Drag and drop it on the "App Title Folder" onto the tree and click OK to open the page.

 

mobilous_appexe_npe_myproject_dblistview_page

 

Step 4: DB List View Page Editor and its Page Properties window opens up on the right. User need to set the DB Settings and Table cell properties.

 

mobilous_appexe_npe_myproject_dblistview_pageeditor     mobilous_appexe_myproject_sbsg_Remotedbproperty

 

Step 5: Preview the Page.

 

mobilous_appexe_myproject_sbsg_localdbpreview

 

 

2) Create DB Record View Page

 

 

Step 1: Click on "New" from the menu to create a new Page.

 

mobilous_appexe_npe_myproject_menubar_file_options

 

Step 2: Enter Page Title "Record" in "Set Page title" box, Select DB Record View Page.

 

mobilous_appexe_myproject_sbsg_localdbrecord

 

Step 3: Drag and Drop the Page on the "List" Page on the left side of the window.

 

mobilous_appexe_myproject_sbsg_localdbrecord1

 

Step 4: DB Record View Page Editor and its Page Properties window opens up on the right.

1)Select "Cell Style" as "Custom".

2)Select "Service Name" as "Mobilous" and "Table Name" as "emp".

3)Select Row in the "Table Group".

4)Click on Edit(0) Button corresponding to the Cell as shown in the Image.

 

mobilous_appexe_myproject_sbsg_localdbrecpage   mobilous_appexe_myproject_sbsg_Remotedbrecordproperty

 

Step 5: Drag and Drop TextField UI Part in the new Row edit area. Select the "Fieldname" to be displayed from the Dropdown as shown in the Image.

 

mobilous_appexe_myproject_sbsg_localdbrecordeditcell

 

Step 6: Three rows are added by clicking on "Add" from the Properties Palette window. TextField is added to each row, by clicking on corresponding Edit(0) Button. Select Field names for each Textfield from the Properties Palette window to display id, name, and address as shown in the image.

 

mobilous_appexe_myproject_sbsg_localdbrecordset

 

 

3) Add Navigation

 

Step 1: Click on "List" Page on the New Page Window. Click "OK" to open the Page.

 

mobilous_appexe_myproject_sbsg_localdbaddnavi1

 

Step 2: Click on Edit(0) Button Corresponding to "On Tapping Row".

 

mobilous_appexe_myproject_sbsg_Remotedbaddnavi2

 

Step 3: Click on "Add" to add Navigation action. Select "Page Transitions" Actions Category and Click on "Go to Child Page" Action. Select Page Name to which the page has to be transited and select "Transfer Data". Click Apply.

 

mobilous_appexe_myproject_sbsg_phonestorage_navi_setparameter

 

Step 3: Action set is shown in the Actions window. Click on Apply to apply the action.

 

mobilous_appexe_myproject_sbsg_phonestorage_navi_actionset

 

Step 4: To Preview the Page. Click on top right corner of the Page. Preview pop up opens. Click on Preview as shown in the Image.

 

mobilous_appexe_myproject_sbsg_phonestorage_navi_clickpreview       mobilous_appexe_myproject_sbsg_phonestorage_navi_clickpreview1

 

Step 5: Observe the Preview Page. As we Click on the Row on the List View Page, Record View Page opens displaying the details of the item of the Row selected.

 

mobilous_appexe_myproject_sbsg_localdbpreview   mobilous_appexe_myproject_sbsg_phonestorage_navi_recordpreview