Update all checkboxes in GridView using one Submit
How can I code an update routine attached to one submit button at the bottom of my GridView to update all checkboxes at once? I am using a stored proc in my SQLDataSource for the Updatecommand and my GridView only has checkboxes as the only control type
<asp:SqlDataSource
ID="ds_dashboard"
runat="server"
ConnectionString="<%$ ConnectionStrings:DashboardConn %>"
SelectCommand="Get_Customer_DashboardGraphs"
SelectCommandType="StoredProcedure"
UpdateCommand="Update_Customer_DashboardGraphs"
UpdateCommandType="StoredProcedure"
>
<UpdateParameters>
<asp:Parameter Name="CustomerID" Type="Int32" />
<asp:Parameter Name="CurrentMonthCollections" Type="Int16" />
<asp:Parameter Name="RevenueByMonth" Type="Int16" />
<asp:Parameter Name="PDCsCCsMonthly" Type="Int16" />
<asp:Parameter Name="RevenueByClient" Type="Int16" />
</UpdateParameters>
</asp:SqlDataSource>
Now how do I code an update to all? I do not want to use individual edit buttons for each row...because this grid is all checkboxes and the users need to be able to just fly through and uncheck or check the boxes. The boxes come from the SelectCommand which are from fields of type Bit from my source table.
|