How to create Visual Components in PowerBuilder for Visual Studio Developers

[former_member190719]

Another of the latest videos from the SAP Database and Tools Academy (http://www.youtube.com/user/saptechnology/videos?query=PowerBuilder).

The video is pretty much self explanatory.  Just reiterate the main points here and provide some of the sample code.

1.  Create a .Net assembly target and select CustomVisual as the object type to be created.

2.  Create your visual user object in the WPF panel that is presented.

3.  Go to the Objects tab on the project and make sure you select the visual component you want to deploy.

4.  In addition to the assembly containing your visual component, PowerBuilder will place the following runtime assemblies in the output folder.  Give all of them to the Visual Studio developer.

 com.sybase.iiop.net.dll

Sybase.DataWindow.Common.dll

Sybase.DataWindow.Core.dll

Sybase.DataWindow.Interop.dll

Sybase.DataWindow.Shared.dll

Sybase.DataWindow.WPF.dll

Sybase.PowerBuilder.Common.dll

Sybase.PowerBuilder.Common.xml

Sybase.PowerBuilder.Compiler.Assist.dll

Sybase.PowerBuilder.Core.dll

Sybase.PowerBuilder.Core.xml

Sybase.PowerBuilder.DataSource.Db.dll

Sybase.PowerBuilder.DataSource.dll

Sybase.PowerBuilder.Interop.dll

Sybase.PowerBuilder.WPF.Controls.dll

Sybase.PowerBuilder.WPF.Controls.Skins.dll

Sybase.PowerBuilder.WPF.Controls.xml

Sybase.PowerBuilder.WPF.dll

Sybase.PowerBuilder.WPF.xml

5.  The visual studio developer will create a reference in their Toolbar to the new WPF control by selecting Choose Items... and then using the Browse option under WPF control to navigate to your assembly and then select the visual control within it.

6.  The Visual Studio developer can now drop the PowerBuilder visual object onto a WPF window in their application.  There may be a couple of errors the first time they attempt to compile the application:

a.  If the WPF application has been created with a Target Framework Reference of ".Net Framework 4 Client Profile" they will need to change it to ".Net Framework 4".  The assembly that PowerBuilder created indicates it has a dependency on System.Web, which is not included in the Client Profile version of the target framework.

b.  When the Visual Studio developer added your component to their WPF window, Visual Studio automatically added a reference to it to the project.  The Visual Studio developer will also need to add an explicit reference to Sybase.PowerBuilder.WPF.Controls to the project.

If you are incorporating a DataWindow control in your custom visual user object, you will need to make a few additional changes.

1.  Assuming that you are going to be using ADO.Net to connect to the database, you will need to provide these additonal runtime assemblies to the Visual Studio developer.  Note that PowerBuilder will not automatically copy them to the output folder for you.

Sybase.PowerBuilder.ADO.dll

Sybase.PowerBuilder.DataSource.Db2.dll

Sybase.PowerBuilder.DataSource.Sharing.dll

Sybase.PowerBuilder.Db.dll

Also note that the following runtime assemblies will also need to be given to the Visual Studio developer, because the DataWIndow uses them to read SRD files:

antlr.runtime.dll

Antlr3.Runtime.dll

2.  The Visual Studio developer will need to add explicit references to the antlr3.runtime.dll and Sybase.PowerBuilder.DataSource.Sharing.dll assemblies.

3.  If you want to have the Visual Studio developer pass in an established connection to the database and have the DataWindow within the PowerBuilder component use it instead of establishing it's own seperate connection to the database, you'll need to add a method to the custom visual user object that takes an argument of System.Object and then uses the SetAdoConnection method on the transaction object to assign that argument as a proxy connection.  For example:

boolean  lb_rc

integer  li_rc

try

  SQLCA.DBMS = "ADO.Net"

  SQLCA.DBParm = "Namespace='Oracle.DataAccess.Client'"

  lb_rc = sqlca.SetAdoConnection(a_conn)

  if not lb_rc then

    MessageBox ( "Error", "SetAdoConnection failed" )

    return -1

  else

    connect using sqlca ;

    if sqlca.SQLCode <> 0 then

      MessageBox ( "Error", "Connect failed: " + sqlca.SQLErrText )

      return -1

    else

      li_rc = dw_1.SetTransObject ( sqlca )

      if li_rc < 0 then

        MessageBox ( "Error", "SetTransObject failed" )

        return -1

      else

        return 1

      end if

    end if

  end if

catch ( Throwable e )

  Exception exp

  exp = create Exception

  exp.SetMessage(e.GetMessage())

  throw exp

end try

4.  The Visual Studio developer then creates a proxy object based on the IAdoConnectionProxy interface, create it based on AdoConnectionProxy, assigns the connection and transaction to it, and passes into your method on the custom visual user object.

short rc;

           

String connectString = "Data Source=//oracle:1521/orcl;User Id=scott;Password=tiger2";

Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(connectString);

conn.Open();

Oracle.DataAccess.Client.OracleTransaction trans = conn.BeginTransaction();

 

Sybase.PowerBuilder.DataSource.Sharing.IAdoConnectionProxy proxy;

proxy = new Sybase.PowerBuilder.DataSource.Sharing.AdoConnectionProxy();

           

proxy.Connection = conn;

proxy.Transaction = trans;

           

rc = u_customvisual1.AssignConnection(proxy);

5.  Note that when you have methods you want to expose on the custom visual user object, you select those rather than the custom visual user object in the project painter, so that PowerBuilder knows it needs to expose those methods on the control in the assembly.