Databases
StackOverflow2013
Postsdbo
POGridView not returning databound rows when OnClick event fires
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGridView not returning databound rows when OnClick event fires
    primarykey
    data
    text
    <p>I have a GridView that is made up of two database fields populated via a stored procedure and then three fields for user input (two checkbox controls and one textbox) when I click on the save button I can get the information from the three controls but nothing from the two that were populated via the database. How can I get the first two fields?</p> <pre><code>&lt;asp:GridView ID="gvA1" runat="server" AutoGenerateColumns="false" DataKeyNames="CodeNo" AutoGenerateSelectButton="false" EnablePersistedSelection="True" Visible="false"&gt; &lt;Columns&gt; &lt;asp:TemplateField Visible="false" &gt; &lt;ItemTemplate&gt; &lt;%#DataBinder.Eval(Container.DataItem, "CodeNo")%&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField ItemStyle-Wrap="true" ItemStyle-Width="400px" HeaderText="Violation"&gt; &lt;ItemTemplate&gt; &lt;%#DataBinder.Eval(Container.DataItem, "CodeViolationCited") %&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField&gt; &lt;ItemTemplate&gt; &lt;asp:CheckBox ID="A1Accordion_cbPool" runat="server" Text="Pool:" /&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField&gt; &lt;ItemTemplate&gt; &lt;asp:CheckBox ID="A1Accordion_cbSpa" runat="server" Text="Spa:" /&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="Additional Comments" Visible="true"&gt; &lt;ItemTemplate&gt; &lt;asp:TextBox ID="A1Accordion_tb" runat="server" TextMode="MultiLine"&gt;&lt;/asp:TextBox&gt; &lt;/ItemTemplate&gt; &lt;/asp:TemplateField&gt; &lt;/Columns&gt; &lt;/asp:GridView&gt; </code></pre> <p>Code Behind:</p> <pre><code>protected void SaveAndCollapseA1(object sender, EventArgs e) { //good stuff CheckBox myCheckBox_1 = gvA1.Rows[0].FindControl("A1Accordion_cbPool") as CheckBox; CheckBox myCheckBox_2 = gvA1.Rows[0].FindControl("A1Accordion_cbSpa") as CheckBox; TextBox myTextBox = gvA1.Rows[0].FindControl("A1Accordion_tb") as TextBox; //not so good stuff String myString1 = gvA1.Rows[0].Cells[0].ToString(); String myString2 = gvA1.Rows[0].Cells[1].ToString(); } </code></pre> <p>I figured it out but I haven't been hear long enough to post the solution via the links but if you change the columns as so:</p> <pre><code>&lt;asp:label ID="lblA1CodeNo" runat="server" text='&lt;%# Eval("CodeNo") %&gt;'&gt;&lt;/asp:label&gt; </code></pre> <p>then the values are available...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGrixxly
    1. USGrixxly
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGridView not returning databound rows when OnClick event fires
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POGridView not returning databound rows when OnClick event fires
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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