Skip to Content
0
Former Member
Jun 22, 2016 at 12:12 PM

Data Bind to Matrix

774 Views

Hi All,

Am trying to bind more data to matrix, its getting late and required more time.

Like

if there is 1000 records to bind, i will take 5 minutes time.

My code as bellow.

If rsGetSalGenDetailswoCategory.RecordCount > 0 Then

oMatrix.Columns.Item("V_3").Cells.Item(oMatrix.RowCount).Specific.Value = rsGetSalGenDetailswoCategory.Fields.Item("U_CrGlCode").Value

oMatrix.Columns.Item("V_2").Cells.Item(oMatrix.RowCount).Specific.Value = rsGetSalGenDetailswoCategory.Fields.Item("U_CrGlName").Value

oMatrix.Columns.Item("V_0").Cells.Item(oMatrix.RowCount).Specific.Value = rsGetSalGenDetailswoCategory.Fields.Item("AB").Value

End If

Please help if any faster solution.