DataWindow Example in PowerBuilder For .Net

DataWindow Example in PowerBuilder For .Net

Workspace – test

Target – testapp3.pbl

Window -  w_tst3

Datawindow - d_tst3

The PowerBuilder solution looks like this:

Coding

Page_name : Testapp3

SQLCA.DBMS                    = "OLE DB"

SQLCA.LogId                      ='user'

SQLCA.LogPass                 = pass'

SQLCA.Database              =             ‘mydb’

SQLCA.Servername        =             ‘servername’

SQLCA.Lock                        = "RU"

SQLCA.AutoCommit       = False

string is_server_name =‘servername’

string is_database=‘mydb’

SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='" + is_server_name + "',PROVIDERSTRING='Database=" + is_database  +   "'"

Connect Using Sqlca ;

open(w_tst3)

Page_name :w_tst3

dw_1.SetTransObject(Sqlca)

dw_1.retrieve()

I will publish the video soon about this topic. Check the youtube channel