Datagrid with Checkbox

~Bean~ · July 15th, 2005, 02:39 PM

I have a datagrid with a checkbox which displays the boolean result from a database. My code for the datagrid is as follows:

Code:

<asp:DataGrid id="dgQuiz" runat="server" OnEditCommand="dgQuiz_Edit" OnCancelCommand="dgQuiz_Cancel" OnUpdateCommand="dgQuiz_Update" AutoGenerateColumns="False" Width="560px">
                            <columns>
                                <asp:templatecolumn headerstyle-font-bold=True headerstyle-horizontalalign=Center></asp:templatecolumn>
                                <asp:BoundColumn Visible="False" DataField="IDP" SortExpression="id" HeaderText="IDP"></asp:BoundColumn>
                                <asp:templatecolumn headertext="Active">
                                    <itemtemplate>
                                        <asp:checkbox runat="server" enabled="True" name="Checkbox2" id="Checkbox2" checked = '<%# DataBinder.Eval(Container, "DataItem.Active") %>' ></asp:checkbox>
                                    </itemtemplate>
                                    <edititemtemplate>
                                        <asp:checkbox runat="server" name="Checkbox2" id="Checkbox1" checked = '<%# DataBinder.Eval(Container, "DataItem.Active") %>' ></asp:checkbox>
                                    </edititemtemplate>
                                </asp:templatecolumn>
                                <asp:HyperLinkColumn Target="_self" DataNavigateUrlField="IDP" DataNavigateUrlFormatString="QuizQuestions.aspx?TestIDP={0}" DataTextField="Name" HeaderText="Quiz"></asp:HyperLinkColumn>
                                <asp:HyperLinkColumn Target="_self" DataNavigateUrlField="IDP" DataNavigateUrlFormatString="PrintQuizAnswerKey.aspx?TestIDP={0}" DataTextField="Name" HeaderText="Answer Key"></asp:HyperLinkColumn>
                                <asp:HyperLinkColumn Target="_self" DataNavigateUrlField="IDP" DataNavigateUrlFormatString="PrintQuiz.aspx?TestIDP={0}" DataTextField="Name" HeaderText="Print"></asp:HyperLinkColumn>
                                <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" ItemStyle-Wrap="false" HeaderText="Edit Command Column" HeaderStyle-Wrap="false" />

                            </Columns>
                        </asp:DataGrid>

I want to allow the user to change the checkbox value and click update to save the change similar to how this page works: http://samples.gotdotnet.com/quickst...datagrid6.aspx
but I cant figure out how to do the code behind to determine the checkbox value and which row the user is working with...basically I need help with the "dgQuiz_Update" Sub...

-------------------------
Beware of programmers with screwdrivers...

planoie · July 15th, 2005, 02:49 PM

In the edit command handler, you can get at the checkbox with something like this:

objCheckBox = CType(e.Item.FindControl("Checkbox1"), CheckBox)

Then you can access the objCheckBox properties to get the checked state.

Use the grid's DataKeyField property to set the field that holds the key for the table so you can access in the edit command handler with grid.DataKeys[e.Item.ItemIndex]. Then you'll have the record key to hit the database with an update.

-Peter

~Bean~ · July 15th, 2005, 02:59 PM

sweet...I was trying all kinds of things besides the FindControl...I was wrong in thinking that "e" was the Checkbox itself...

thats works perfectly...THANKS!

-------------------------
Beware of programmers with screwdrivers...