How to load data of UserTables

[Former Member]

hi

I need to load data of UserTables. after this, i have that insert in a Form.

may Anybody help me?

thanks

wesley

[Former Member · Accepted solution]

Dear do u want to Add Data from User Table to Matrix on Form ?

reply so that I can reply in correct sence

Regards,

Mansoor

[Former Member · Accepted solution]

HI Mansoor,

my problem already was resolved. it wasn't this that i wanted.

i wanted add data from user table to fields on form.

thanks.

[Former Member · Accepted solution]

In the SDK samples there are several samples of this. Just look in the folder that has the datasources samples.

For example take a look at:

C:\Program Files\SAP\SAP Business One SDK\Samples\COM UI\VB.NET\06.MatrixAndDataSources

Regards,

WB

[Former Member]

there various ways ... through use of a recordset, dbdatasource, and/or datatable.

Look up these in the SAP SDK Help Center... in the meantime here's an example

        Dim strSQL As string = "SELECT * FROM [@USRT]"
        Dim rst As SAPbobsCOM.Recordset
        rst = msboCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
        rst.DoQuery(strSQL) 'Execute query

[Former Member]

thanks Neftali

the example that you passed for me, was good.

bye

Message was edited by:

wesley souza