1 / 14

Advanced Integration - Grid Control

Advanced Integration - Grid Control. In this presentation… The enhanced Grid control. Application integration. New properties and events. Connecting to data sources. Advanced Integration - Grid Control. Enhanced Grid control Supports advanced refacing and new development.

stellaallen
Download Presentation

Advanced Integration - Grid Control

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced Integration - Grid Control • In this presentation… • The enhanced Grid control. • Application integration. • New properties and events. • Connecting to data sources.

  2. Advanced Integration - Grid Control • Enhanced Grid control • Supports advanced refacing and new development. • Extends existing 5250 support. • Provides link to alternate data sources, e.g. databases loaded using script or macros. • Removes constraints of 24x80 ‘green screen’. Grids can hold more information than typical ‘green screens’. • Improves user productivity. • Improves aesthetic appeal.

  3. Advanced Integration - Grid Control • Enhanced Grid control • Automatically displays iSeries subfile data (5250). • Displays data in a series of rows and columns. • New functionality • New Row, Column, Cell objects. • Use the Collections property to add columns. • Resize grid columns (Designer & User). • Sort columns (User). • Re-order columns (in Designer only). • Horizontal scrolling. • Saves screen space. • Grid Supports use of other controls. • Use Designer to change field recognition, e.g. DateCombo etc. • Makes integration easier.

  4. Advanced Integration - Grid Control • The Grid control and Enterprise Integration • Combine data from multiple layers: • Presentation. • Application. • Data. • Use the enhanced Grid to retrieve data from: • Databases. • iSeries apps. • Other.

  5. Advanced Integration - Grid Control • Grid properties • Properties: • CaptionText • CaptionBackColor • CaptionForeColor • ImageList • ShowCaption • ShowColumnHeaders • FoldCount • ScrollBars • Columns • Events: • OnBeginEdit • OnEndEdit • OnLoadRecord • OnScroll • OnSort

  6. Advanced Integration - Grid Control • Collections: • Modify individual column properties. • Customize look and feel • Cells • Modify cell collections for each row using macro or script properties.

  7. Advanced Integration - Grid Control • The Enhanced Grid control and data integration • Databases supported • Inserting a grid control • Database types • DDM • ADO

  8. Advanced Integration - Grid Control • DDM databases • iSeries • zSeries • SSL encryption • ADO databases • Microsoft SQL Server • Oracle • iSeries, zSeries • Microsoft Access • Any database that has ADO driver.

  9. Advanced Integration - Grid Control • Inserting a Grid control • Insert Grid from Designer menu. • Set properties to bind to a database. • Bind fields to Grid control.

  10. Advanced Integration - Grid Control • Data connection properties • Server • Specify the server type (ServerDDM, ServerADO) • Source • If Server property is DBServerADO then the Source property is a Command object variable, an SQL statement, a stored procedure, or a table name • If the Server property is set to DBServerDDM, the Source property specifies a file or member name.

  11. Advanced Integration - Grid Control • Data connection properties • ConnectionString • Prompter to help build connection string • For ADO connections, the contents of the connection string are determined by the OLE DB provider. • Sample DDM connection string • Network Address=192.168.1.1;Network Port=447;Use Encryption for Data=False;User ID=brendan;Host CCSID=37;Mode=Read|ShareDenyNone;Isolation Level=ReadCommitted;Process Binary as Character=False • Sample ADO connection string • Provider=MSDASQL.1;Persist Security Info=False;Data Source=MS Access Database;Initial Catalog=newlookdemo.mdb

  12. Advanced Integration - Grid Control • Database description tool • Available from Tools menu • View Connection String • View properties • View database structure

  13. Workshop 6 centric 8 Training

  14. This page is intentionally left blank.

More Related