cancel
Showing results for 
Search instead for 
Did you mean: 

How to bind Matrix with record set?

Former Member
0 Kudos
97

Hello Experts,

I want to bind Matrix with record set please give me suggestion or give me code for bind Matrix

Regards,

Pratik

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Pratik ,

Pleas try this below code ..

oRecordset = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

oRecordset.DoQuery("Select U_Code from [@Table]")

oMatrixProp.AddRow(oRecordset.RecordCount)

For Index = 1 To oRecordset.RecordCount

oMatrixProp.Columns.Item("itemname").Cells.Item(Index).Specific.value = oRecordset.Fields.Item("U_Code").Value

oRecordset.MoveNext()

Next

Thanks

kalpen

Former Member
0 Kudos

Thanx for the quick reply.

Answers (0)