Skip to Content
0
Former Member
Dec 13, 2009 at 07:52 AM

Reading data & copying to the matrix taking much time

12 Views

Hello Experts,

I am trying to copy data from Stock Transfer to the Stock Revalution form based on the docentry for that i have created a button in

Stock Transfer form as "Copy To Revaluation" on click of that that button data get copied to the matrix of Stock Revalution

like Item Code,Quantity .I have done that using Record set reading line from database and putting in the matrix row by row

which is taking much time to fill the matrix one row by row using following :-

While Not Recordset.EOF

Omatrix.Columns.Item("1").Cells().Item(i).specific.Value=Recordset.Fields.Item(0).Value

Its taking much time but i want to make the data filling much quicker how to do that as i am not able to fill the data quickly in the matrix.

Thanks & Regards,

Amit