Dynamic Display of text controls in content frame

[sai120042]

Hi,

We are using Oracle Stored Procedure. It will dynamically

return any number of columns 9 1 to 10) based up on the user

input. So our problem is to put them dynamically in the

content frame. We tried the following approaches which I am

briefing.

Approach1:

We have overridden the datastreams OnRow() method and

creating the textcontrols dynamically. The logic is we re

having the number of columns that will be returned by the

storedprocedure in a parameter which we are using in the

OnRow() method. For all the values that will be returned by

the parameter ( 1 to 10 in our case) we are creating that

many textcontrols and assigning values to them . But we have

found that overriding datastreams OnRow() method effects the

performance drastically. So tried the next approach.

Approach2:

The example given in the ERD Pro . How to handle a

storedprocedure which results multiple resultsets.
Here the logic is we have to create cursors for all the

possible resultsets that may be returned by the

storedprocedure and then bind them to the datarow columns.

But here the order of the columns also matter. We may get

the 10 columns in any order so we must create
the cursors for all the possible combination . So it turns

out to around 200 cursors we need to create. So we left this

out.

Approach:

Overriding the makecontents() method of the content frame is

also effecting the performance as it is getting execute for

each and every row same as the OnRow() method.

So anyone could you please help me out in this. If anyone

has any sample code which may be useful to me. Please share.

Thanks in advance.