Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 23rd, 2006, 07:15 PM
Authorized User
 
Join Date: Feb 2006
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get GridView to update xr280xr ASP.NET 2.0 Professional 5 February 15th, 2008 12:45 PM
Checkboxes in Gridview ramuis78 ASP.NET 2.0 Basics 0 October 11th, 2007 09:55 AM
Gridview with checkboxes kgaughan1 ASP.NET 2.0 Professional 0 February 11th, 2007 11:31 PM
delete using checkboxes in gridview aspvbnet ASP.NET 2.0 Basics 1 November 22nd, 2006 08:28 PM
Insert and update with one submit dorothee Dreamweaver (all versions) 1 June 14th, 2004 06:25 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.