Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Since you are creating the TextBoxesbased on org.Registrations, you can use a Repeater in the ItemTemplate of GirdVIew and then bind the org.Registrations as DataSource to the repeater in the RowCreated event. i.e: <strong>in your aspx:</strong></p> <pre><code>&lt;asp:GridView ...... OnRowDataBound="gv_RowDataBound"&gt; . . . &lt;asp:TemplateField ...&gt; &lt;ItemTemplate&gt; &lt;asp:Repeater id="rptRegistrations" runat="server"&gt; &lt;asp:TextBox id="txtRegistration" runat="server" Text='&lt;%#Eval("Name")%&gt;'&gt;&lt;/asp:TextBox&gt;&lt;br/&gt; &lt;/asp:Repeater&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateField ...&gt; &lt;/asp:GridView&gt; </code></pre> <p><strong>in your code behind</strong> </p> <pre><code> protected void gv_RowDataBound(object sender, GridViewRowEventArgs e) { if(e.Row.RowType == DataControlRowType.DataRow) { Students org = (namespace.Students )(e.Row.DataItem); Repeater rptrRegistrations = e.Row.Cells[7].FindControl("rptrRegistrations") as Repeater ; rptrRegistrations.DataSource = org.Registrations; rptrRegistrations.DataBind(); } } public void gv_SelectedIndexChanged(Object sender, EventArgs e) { // Get the currently selected row using the SelectedRow property. GridViewRow row = gvOrg.SelectedRow; Repeater rptrRegistrations = row.Cells[7].FindControl("rptrRegistrations") as Repeater; foreach(RepeaterItem item in rptrRegistrations.Items) { TextBox txtRegistration = item.FindControl("txtRegistration") as TextBox; //Now you have access to the textbox. } } </code></pre> <p><strong>Ignore the following text based on OP's comment</strong></p> <p>Instead of creating the TextBox dynamically, add the Textbox in the Grid ItemTemplate in ASPX and then use e.Row.Cells.FindControl to access the textbox. Something like:</p> <pre><code>protected void gv_RowCreated(object sender, GridViewRowEventArgs e) { Students org = (namespace.Students )(e.Row.DataItem); foreach (Registration reg in org.Registrations) { int _count = org.Registrations.Count; for (int rowId = 0; rowId &lt; _count; rowId++) { TextBox txtBox = e.Row.Cells[7].FindControl("txtRegistration") as TextBox ; //txtBox.ID = "_registration" + e.Row.RowIndex + "_" + rowId; txtBox.Text = reg.Name; txtBox.Visible = true; //e.Row.Cells[7].Controls.Add(txtBox); } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POfinding control in collection tree
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChandu
    1. USChandu
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POfinding control in collection tree
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COi wish i could have used but i have a situation where i have to create dynamic control and i have already posted the question here http://stackoverflow.com/questions/4798644/how-to-retain-viewstate-for-the-dynamic-controls-created-in-gridview
      singulars
      1. PO
      1. USNick Kahn
    2. COUpdated the post.. You might need to tweak the code posted a little to suit your needs..But it gives you the idea..
      singulars
      1. PO
      1. USChandu
    3. CO@Cybernate: if you look at my code and i am doing `for` loop statement to create # of textbox based on how many counts i get from db but looking at your code you have declarative text-box in .aspx page.... i am wondering how would that help in my situation?
      singulars
      1. PO
      1. USNick Kahn
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload