ASP.NET 2.0 with conditional radio button in a GridView
<p>Ugh... spent a lot of time googling this but can't find a good sample.  I can see how to change an asp label text but not display a radio button...</p>

<p>Can anyone provide a code sample so that I can:</p>

<p>Have a GridView displaying "Events" from a database,  and then in the last column I want to do another database lookup (for each row) to see if that event is full or not.</p>

<p>If it's not full, display a radio button.   If it is full display text "Full".</p>

<p>I <em>think</em> this is best done with OnRowDataBound event but could use a little help</p>

<p>Thanks</p>

<p>Update with code:</p>

<p>register.aspx</p>

<pre><code>&lt;asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource2" AutoGenerateColumns=false CellPadding="5" HeaderStyle-BackColor="DarkGray" Width="450px" OnRowDataBound="GridView2_OnRowDataBound"&gt;
            &lt;Columns&gt;
                &lt;asp:BoundField DataField="sessionDate" HeaderText="Date" DataFormatString="{0:D}" /&gt;
                &lt;asp:BoundField DataField="sessionTime" HeaderText="Time" /&gt;
                &lt;asp:BoundField DataField="site" HeaderText="Site" /&gt;
                &lt;asp:BoundField DataField="room" HeaderText="Room" DataFormatString="{0:D}" /&gt;
                &lt;asp:TemplateField HeaderText=""&gt;
                    &lt;ItemTemplate&gt;
                        &lt;input type="radio" name="rdoSessionID" value='&lt;%# Eval("ses_ID") %&gt;' /&gt;



                    &lt;/ItemTemplate&gt;
                &lt;/asp:TemplateField&gt;
            &lt;/Columns&gt;
            &lt;HeaderStyle BackColor="#99CCFF" /&gt;
        &lt;/asp:GridView&gt;
        &lt;br /&gt;


        &lt;asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="&lt;%$ ConnectionStrings:sqlConnection2 %&gt;"
            SelectCommand="SELECT * FROM dbo.sessions WHERE site LIKE @ses_site AND sessionDate = @ses_date ORDER BY sessionDate"&gt;

            &lt;SelectParameters&gt;
             &lt;asp:SessionParameter name="ses_site" SessionField="ses_site" Type="String" /&gt;
             &lt;asp:SessionParameter name="ses_date" SessionField="ses_date" Type="String" /&gt;
            &lt;/SelectParameters&gt;



        &lt;/asp:SqlDataSource&gt;
</code></pre>
