Transferring data between matrices

[Former Member]

I am new to this stuff; so I would like to say hello. I will probably need to come here often with questions and hopefully later with some answers.

I need sample code that shows how to transfer data into a matrix on the current form from a matrix on another form. They are two different forms but both are up at the same time. The second form is called from the first form.

We are using VB .NET 2003 and the current version of Business One.

Thanks,

Mike

[Former Member]

I have made some progress on this; I am able to capture the data from the matrix on the other form one cell at a time. But I can't figure out how to add it to the matrix on the current form. I figure that, if it is possible to read data from a matrix one cell at a time, it should also be possible to write that data into another matrix one cell at a time. It seems that the only way to get data into a matrix is from a data source. If this is the case, then it is somewhat problematic.

One reason is that the matrix already has a DB data source. Binding it to a second datasource may not be a good idea or even possible. It may require temporarily disconnecting the first data source, connecting the second one, copying the data into the matrix, disconnecting the second one, and reconnecting the first one. If this is what is necessary, how do I disconnect the first data source?

The second reason is that I am having difficulty figuring out how to get the data into the second data source, which is a user data source. I am also having difficulty finding out how a user data source is constructed. Does it have to have only one column or can it have many? The sample code that came with B1 shows only a case where it is has one column.

Any ideas out there on how this can be done?

[Former Member]

I figured it out. We can close this thread. Thanks.