Submit button function to update all GridView checkboxfields

[dba123]

How do I take my GridView and create a function that will update -all-
checkbox values for the submit button's OnClick event? I have posted both my
SQLDataSource and my GridView below:

<asp:SqlDataSou rce
ID="ds_dashboar d"
runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:DashboardCon n %>"
SelectCommand=" Get_Customer_Da shboardGraphs"
SelectCommandTy pe="StoredProce dure"
UpdateCommand=" Update_Customer _DashboardGraph s"
UpdateCommandTy pe="StoredProce dure"

<UpdateParamete rs>
<asp:Paramete r Name="CustomerI D" Type="Int32" />
<asp:Paramete r Name="CurrentMo nthCollections"
Type="Int16" />
<asp:Paramete r Name="RevenueBy Month" Type="Int16" />
<asp:Paramete r Name="PDCsCCsMo nthly" Type="Int16" />
<asp:Paramete r Name="RevenueBy Client" Type="Int16" />

</UpdateParameter s>

</asp:SqlDataSour ce>

--------------------------------------------------------------------------------------

<table id="Table1" class="main_tab le" cellspacing="0" cellpadding="2"
border="1" runat="server">
<tr>
<td class="main_hea der">Filter Tool</td>
</tr>
<tr><td colspan="2"><br />For month: <asp:Label runat="server"
id="lblCurrentM onth" /><br /><br /></td></tr>
<tr><td>
<asp:GridView
ID="gv_dashboar d"
runat="server"
AutoGenerateCol umns="False"
AutoGenerateEdi tButton = "TRUE"
DataSourceID="d s_dashboard"
CellPadding="4"
ForeColor="#333 333"
ShowFooter="Tru e"
GridLines="None "
CssClass="Forma tFont">

<Columns>
<asp:TemplateFi eld HeaderText="Cus t #"
SortExpression= "CustomerID ">
<HeaderStyle HorizontalAlign ="Left"></HeaderStyle>
<ItemTemplate >
<asp:Label runat="server" id="lblCustomer ID"
Text='<%# Bind("CustomerI D") %>' />
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Cur rent Month Collections"
SortExpression= "Name">
<HeaderStyle HorizontalAlign ="Left"></HeaderStyle>
<ItemTemplate >
<asp:checkboxfi eld runat="server"
datafield="Curr entMonthCollect ions" />
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Rev enue By Month"
SortExpression= "Name">
<HeaderStyle HorizontalAlign ="Left"></HeaderStyle>
<ItemTemplate >
<asp:checkboxfi eld runat="server"
datafield="Reve nueByMonth" />
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="PDC s & CCS Monthly"
SortExpression= "Name">
<HeaderStyle HorizontalAlign ="Left"></HeaderStyle>
<ItemTemplate >
<asp:checkboxfi eld runat="server"
datafield="PMon thly" />
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Rev enue By Client"
SortExpression= "Name">
<HeaderStyle HorizontalAlign ="Left"></HeaderStyle>
<ItemTemplate >
<asp:checkboxfi eld runat="server"
datafield="Reve nueByClient" />
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>

<FooterStyle BackColor="#5D7 B9D" Font-Bold="True"
ForeColor="Whit e" />
<RowStyle BackColor="#F7F 6F3" ForeColor="#333 333" />
<EditRowStyle BackColor="#DDD DDD" />
<SelectedRowSty le BackColor="#DDD DDD" Font-Bold="True"
ForeColor="#333 333" />
<PagerStyle BackColor="#284 775" ForeColor="Whit e"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#5D7 B9D" Font-Bold="True"
ForeColor="Whit e" />
<AlternatingRow Style BackColor="Whit e" ForeColor="#284 775" />
</asp:GridView>
</td></tr>
<tr>
<td align="right">
<asp:Button CssClass="submi tbutton" Text="Update" ID="Button1"
OnClick="Update Fees" Runat="server" />
</td>
</tr>
</table>

--
dba123

[Neutrino]

If I understand correctly you want to have the GridView to update
several rows in a single postback. The GridView control does not
support this functionality, it can only have one row in edit mode at a
time and send updates to the database for one row at a time only.
However, there are work arounds. To update several rows one alternative
is to iterate the GridView.Rows collection of the gridview, and issue
the necesarry Update statements to the database (you will probably need
to use FindControl method to find the controls and extract the values
within each row).

[dba123]

Thanks yes...I have used that to update textboxes before but not for
checkboxfield. How can I change my Function (that does what you say,
iterates through the rows) for a checkboxfield when a checkboxfield has no ID?

Here's the code I used to do just that but with a textbox...I need to know
how to change this to update all my checkboxes:

Public Sub UpdateCustomer_ DashboardGraphs (ByVal sender As Object, ByVal
e As System.EventArg s)
For Each gvr As GridViewRow In gv_dashboard.Ro ws
If gvr.RowType = DataControlRowT ype.DataRow Then
Dim intCustomerID As Integer = CType(gvr.FindC ontrol("lblCust omerID"),
Label).Text.Tri m()
Dim intCurrentMonth Collections As Integer =
CType(gvr.FindC ontrol("txtFeeG oalAZ"), TextBox).Text.T rim()
Dim intRevenueByMon th As Integer =
CType(gvr.FindC ontrol("txtFeeG oalIL"), TextBox).Text.T rim()
Dim intPDCsCCsMonth ly As Integer =
CType(gvr.FindC ontrol("txtFeeG oalIL"), TextBox).Text.T rim()
Dim intRevenueByCli ent As Integer =
CType(gvr.FindC ontrol("txtFeeG oalIL"), TextBox).Text.T rim()

ds_dashboard.Up dateParameters( "CustomerID").D efaultValue =
intCustomerID

ds_dashboard.Up dateParameters( "CurrentMonthCo llections").Def aultValue =
intFeeGoalAZ
ds_dashboard.Up dateParameters( "RevenueByMonth ").DefaultV alue
= intFeeGoalIL
ds_dashboard.Up dateParameters( "PDCsCCsMonthly ").DefaultV alue
= intFeeGoalIL
ds_dashboard.Up dateParameters( "RevenueByClien t").DefaultValu e
= intFeeGoalIL
ds_dashboard.Up date()
End If
Next
End Sub

--
dba123
"Neutrino" wrote:

If I understand correctly you want to have the GridView to update
several rows in a single postback. The GridView control does not
support this functionality, it can only have one row in edit mode at a
time and send updates to the database for one row at a time only.
However, there are work arounds. To update several rows one alternative
is to iterate the GridView.Rows collection of the gridview, and issue
the necesarry Update statements to the database (you will probably need
to use FindControl method to find the controls and extract the values
within each row).