Can i iterate user control that retrieve data from db into a form???

yes, you can obviously use user control to display the same data in multiple places.

For example, suppose there is a user control that uses a repeater

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="FriendWebUserControl.ascx.cs" Inherits="FriendWebUserControl" EnableViewState="True" %>
Friend Detail From User Control
"rptFriend" runat="server">
"1" style="border-color:darkorange;background-color:lightgray">
Friend ID :
"lblFriendID" runat="server" Text='<%# Eval("FriendID") %>'>
Friend Name :
"lblFriendName" runat="server" Text='<%# Eval("FriendName") %>'>
Place :
"lblPlace" runat="server" Text='<%# Eval("Place") %>'>
Mobile :
"lblMobile" runat="server" Text='<%# Eval("Mobile") %>'>
Email ID :
"lblEmailID" runat="server" Text='<%# Eval("EmailAddress") %>'>
"Default.aspx">Back To Main Page

code behind of user control

public partial class FriendWebUserControl: System.Web.UI.UserControl
{
string ConStr = ConfigurationManager.ConnectionStrings["MemberCDACConnectionString"].ConnectionString;
public int FriendID
{
get;
set;
}
protected void Page_Load(object sender, EventArgs e)
{
BindRepeater(FriendID);
}
///
/// To load data into Repeater control
///
public void BindRepeater(int SelectedFriendID)
{
SqlConnection con = new SqlConnection(ConStr);
SqlDataAdapter da = new SqlDataAdapter("Select * From tblFriends where FriendID = " + SelectedFriendID, ConStr);
DataSet ds = new DataSet();
da.Fill(ds, "FriendsTable");
rptFriend.DataSource = ds;
rptFriend.DataBind();
}
}

now you can use this control on any aspx page

// after page directive register your user control
<%@Register Src=~/FriendWebUserControl.ascx” TagName=”WebUserControl” TagPrefix=”uc1” %>
// use user control

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
yes, you can obviously use user control to display the same data in multiple places.
For example, suppose there is a user control that uses a repeater
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="FriendWebUserControl.ascx.cs" Inherits="FriendWebUserControl" EnableViewState="True" %>

Friend Detail From User Control

    "rptFriend" runat="server">


            "1" style="border-color:darkorange;background-color:lightgray">

                    Friend ID :
                        "lblFriendID" runat="server" Text='<%# Eval("FriendID") %>'>



                    Friend Name :
                        "lblFriendName" runat="server" Text='<%# Eval("FriendName") %>'>



                    Place :
                        "lblPlace" runat="server" Text='<%# Eval("Place") %>'>



                    Mobile :
                        "lblMobile" runat="server" Text='<%# Eval("Mobile") %>'>



                    Email ID :
                        "lblEmailID" runat="server" Text='<%# Eval("EmailAddress") %>'>





       "Default.aspx">Back To Main Page
code behind of user control
public partial class FriendWebUserControl: System.Web.UI.UserControl
{
    string ConStr = ConfigurationManager.ConnectionStrings["MemberCDACConnectionString"].ConnectionString;
    public int FriendID
    {
        get;
        set;
    }
    protected void Page_Load(object sender, EventArgs e)
        {
            BindRepeater(FriendID);
        }
        ///

        /// To load data into Repeater control
        ///
    public void BindRepeater(int SelectedFriendID)
    {
        SqlConnection con = new SqlConnection(ConStr);
        SqlDataAdapter da = new SqlDataAdapter("Select * From tblFriends where FriendID = " + SelectedFriendID, ConStr);
        DataSet ds = new DataSet();
        da.Fill(ds, "FriendsTable");
        rptFriend.DataSource = ds;
        rptFriend.DataBind();
    }
}
now you can use this control on any aspx page
// after page directive register your user control

<%@Register Src=~/FriendWebUserControl.ascx” TagName=”WebUserControl” TagPrefix=”uc1” %>

// use user control
Jefferson S. Motta5y ago
From Form1 you Open Form2.

I don't know how is your data, but I make a sample:
Form1:
__________________________


public List DataUC()
{
    var data = new List();

    // READ DATA FROM Database to data;

    ...
    return data;
}

public void ShowForm2()

{

    var f = New Form();

    f.ShowDataFromMyUserControlData(DataUC());

    f.Show();

}

__________________

Form2:

public void ShowDataFromMyUserControlData(List data)
{

    // DISPLAY DATA

}

Can i iterate user control that retrieve data from db into a form???

Friend Detail From User Control