I have an array that was made via some dynamic SQL that has a variable number of rows and a variable (unknown at design time) number of columns (minimum 2).
I wish to use that array to populate a Datagrid...essentially the process is obtaining data from several tables (unknown which subset of the queried tables will have the data) for a particular name...the one name may be common to more than one person, therefore there may be multiple rows of data.
I want to convert the data from having several LONG rows to several columns (rotating the table).
I have the data into an array (no small feat). now I want to get it into an array. The examples that I have seen seem to be contingent on a known number of columns...
Can someone help me?