Skip to Content
0
Former Member
Sep 24, 2008 at 08:33 AM

Matrix problem (again)

53 Views

I try to fill-in a matrix using a recordset and userdatasource.

here is a part of codes:

For i As Integer = 1 To rs.RecordCount

oMatrix.AddRow(i)

oUDSCardCode.ValueEx = rs.Fields.Item("CardCode").Value

oUDSCardName.ValueEx = rs.Fields.Item("CardName").Value

oUDSItemCode.ValueEx = rs.Fields.Item("ItemCode").Value

oUDSItemName.ValueEx = rs.Fields.Item("ItemName").Value

oMatrix.SetLineData(i)

oMatrix.FlushToDataSource()

rs.MoveNext()

Next i

my problem is, there is only 3 records in the recordset:

i.e.

AAACode AAAName AAAItem AAADesc

BBBCode BBBName BBBItem BBBDesc

CCCCode CCCName CCCItem CCCDesc

but the Matrix shows:

AAACode AAAName AAAItem AAADesc

BBBCode BBBName BBBItem BBBDesc

BBBCode BBBName BBBItem BBBDesc

CCCCode CCCName CCCItem CCCDesc

CCCCode CCCName CCCItem CCCDesc

CCCCode CCCName CCCItem CCCDesc

Any ideas?

Thanks