DataGrid Demo of a Radio Button Column Using a TemplateColumn
This demo illustrates how one can (erroneously) create a column of radio buttons in a DataGrid using
a TemplateColumn. Note that you can select multiple radio buttons! This is because the DataGrid Web
control gives a unique name to each radio button, so the browser doesn't realize that these radio buttons
are grouped.
Source Code
<% @Import Namespace="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %>
<script language="vb" runat="server">
Sub Page_Load(sender as Object, e as EventArgs)
If Not Page.IsPostBack then
BindData()
End If
End Sub
Sub BindData()
'1. Create a connection
Dim myConnection as New SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
'2. Create the command object, passing in the SQL string
Const strSQL as String = "sp_Popularity"
Dim myCommand as New SqlCommand(strSQL, myConnection)
'Set the datagrid's datasource to the datareader and databind
myConnection.Open()
dgPopularFAQs.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
dgPopularFAQs.DataBind()
End Sub
</script>
<form runat="server">
<h3>What FAQs Would Your Like to Learn More About?</h3>
<asp:DataGrid runat="server" id="dgPopularFAQs"
BackColor="#eeeeee" Width="85%"
HorizontalAlign="Center"
Font-Name="Verdana" CellPadding="4"
DataKeyField="FAQID"
Font-Size="10pt" AutoGenerateColumns="False">
<HeaderStyle BackColor="Black" ForeColor="White" Font-Bold="True" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="White" />
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:RadioButton runat="server" GroupName="ThisDoesntWork" id="NeitherDoesThis" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="FAQID" HeaderText="FAQ ID" />
<asp:BoundColumn DataField="Description" HeaderText="FAQ Description" />
</Columns>
</asp:datagrid>
</form>