×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Dynamic Display of text controls in content frame

Dynamic Display of text controls in content frame

Dynamic Display of text controls in content frame

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close