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

Question

I am working on something, and i am stuck, i can't find a solution to it. Is thier a possible way of retrieving multiple data from database using user control and displaying it to another form????

i did be glad if someone can help, even with some samples or ideas

Sachin Singh · Answer

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 "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= ' ' > Friend Name : "lblFriendName" runat= "server" Text= ' ' > Place : "lblPlace" runat= "server" Text= ' ' > Mobile : "lblMobile" runat= "server" Text= ' ' > Email ID : "lblEmailID" runat= "server" Text= ' ' > "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 FriendWebUserControl .ascx” TagName=”WebUserControl” TagPrefix=”uc1” %> // use user control

Jefferson S. Motta · Answer

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 }