on 12-15-2011 11:08 AM
Hi,
Can we bind dataset to matrix in SAP same as we can do in windows form?
HI PRAVINAUG17
its better to use Record set for binding Matrix .
Refer this below code .
oRecordset = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
oRecordset.DoQuery("Select U_Code from [@STPROPMST]")
oMatrixProp.AddRow(oRecordset.RecordCount)
For Index = 1 To oRecordset.RecordCount
oMatrixProp.Columns.Item("cProp").Cells.Item(Index).Specific.value = oRecordset.Fields.Item("U_Code").Value
oRecordset.MoveNext()
Next
Thanks
kalpen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello.
I guess you are referring to System.Data.DataSet. I don't think it is possible to bind that to matrix objects. You will have to use the DataTable object from the Business One API.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.