Dynamically Load User Control

[dauphian]

Greetings,

I have a user control, that I will need to display on a specific page
based on the number of records in database:

I have to query a site table to get the number of entries as well as a
specific column field for each entry. I then pass that to the user
control to grab a specific set of information from another table and
display.

I have the user control all setup to do this based on a variable passed
to it, but I am not sure how to get the user control to display on the
page more than once without adding it in there manually. Which in the
long run will not be very good to have to edit the code everytime we
add a site...

Any help or examples appreciated.

Thanks!

-Kevyn

[Galcho[MCSD.NET]]

you have add refference to your user control as you insert it from
designer....

after this from code you can do this:

MyUserControl ctrl = new MyUserControl();
Page.Control.Add(ctrl); // instead page here can be any container

hope this helps
Galin Iliev[MCSD.NET]
www.galcho.com

[dauphian]

Thanks for the response. I sorta got it working the way I need, but
have one little issue still...

On my control page, I have a asp:datasource setup that seems to work if
I pass the paramter in for the where the clause, but whenever I try to
pass the table to get the data from, it errors out on me. Below is the
code from the control page:

<asp:SqlDataSource ID="dsGetSites" runat="server" ConnectionString="<%$
ConnectionStrings:CRM_SystemConnection %>"
SelectCommand="SELECT [campaign_id],[campaign_name],[prod_id],
[type], [isActive] FROM @site_code ">
<SelectParameters>
<asp:Parameter Name="site_Code" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

I can supply the full code for both pages if needed to help in solving
this problem I am having.

[dauphian]

Actually..Let me break this down a little bit so it makes more sense to
myself and to whomever can help :-)

1. I have a query that gets 2 columns from a table.

2. For the total number of results (x), I need to pass those 2 values
to a custom control so that it appears (x) amount of times on a page.

Thanks in advance!