gridview limit check boxes to only one checked
I have a gridview control that's bound to a stored procedure, but also contains four non bound checkboxes. What I want to do is limit the user to only one check box checked. That is to say, if the user already has a check box checked and checks a second check box the first is unchecked. I've tried a number of things but can't seem to get it to work. I assume, which is always dangerous for me, that what I need to do is on the onClick event of the checkbox, is to get the id of the ckeckboxand then loop through the other check boxes and uncheck them. I'm just not sure how using the click event of the checkbox I can get the reference to row and what the syntax would be to loop through the check box columns to get only one checked.
Any help would be appreciated.
Thanks,
Tom
<div id="GridView" style="height:375px; overflow-y:auto; overflow-x:hidden">
<asp:GridView ID="grdItems" runat="server" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="SqlDataSource1" Height="400px"
CellPadding="5">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="ID" Visible="False" />
<asp:BoundField DataField="HoseID" HeaderText="Hose ID"
SortExpression="HoseID" />
<asp:BoundField DataField="HoseSize" HeaderText="Hose Size"
SortExpression="HoseSize" />
<asp:BoundField DataField="HoseLength" HeaderText="Hose Length"
SortExpression="HoseLength" />
<asp:BoundField DataField="StationDesc" HeaderText="Station"
SortExpression="StationDesc" />
<asp:BoundField DataField="ServiceDate" HeaderText="Service Date"
SortExpression="ServiceDate" DataFormatString="mm/dd/yyyy" />
<asp:TemplateField HeaderText="Cond Good">
<ItemTemplate>
<div class="selectme">
<asp:CheckBox CssClass="selectme" onClick="cbChecked(this);" ID="cbGood" name="cbGood" runat="server" Checked="false">
</asp:CheckBox>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Cond Good">
<ItemTemplate>
<div class="selectme">
<asp:CheckBox CssClass="selectme" onClick="cbChecked(this);" ID="cbFair" name="cbFair" runat="server" Checked="false">
</asp:CheckBox>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Cond Fair">
<ItemTemplate>
<div class="selectme">
<asp:CheckBox CssClass="selectme" onClick="cbChecked(this);" ID="cbPoor" name="cbPoor" runat="server" Checked="false">
</asp:CheckBox>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Discard">
<ItemTemplate>
<div class="selectme">
<asp:CheckBox CssClass="selectme" onClick="cbChecked(this);" ID="cbDiscard" name="cbDiscard" runat="server" Checked="false">
</asp:CheckBox>
</div>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>