GridView could not find control 'xxx' in controlparameter 'xxx'

[Guest]

I have a checkbox control in a GridView EditItemTemplate. My SqlDataAdapter
complains when I try and use UpdateCommand

Thanks on any binding clarification.

GridView:
<asp:TemplateField HeaderText="Active">
<ItemTemplate>
<asp:CheckBox ID="ActiveCheckBox" runat="server" Checked='<%#
Eval("Active") %>' />
</ItemTemplate>
<EditItemTemplate>
<asp:CheckBox ID="ActiveCheckBox" runat="server" Checked='<%#
Bind("Active") %>' />
</EditItemTemplate>
</asp:TemplateField>


UpdateCommand="Update dbo.Vans set VendorVanNo=@VendorVanNo, ...
Active=@Active ... where VanId=@VanId">
<UpdateParameters>
<asparameter Name="VendorVanNo"/>
...
<asp:ControlParameter Name="ActiveCheckBox"
ControlId="ActiveCheckbox" PropertyName="Checked"/>
...
</UpdateParameters>

 

[Guest]

The way that databinding on the GridView works is that the ASP.NET passes an
IorderedDictionary containing the controls values extracted from the Bind
expression.

The updateparameters should not be referring to controls within the
templates because the checkbox “ActiveCheckbox†is not visible as indepdent
control, it only exists within the EditItemTemplate of the GridView. All you
needed to do within the updateparameters collection is list the fieldnames
(the same the ones you used in the Bind expressions) that have been databound
or that are DataKeys on the GridView, e.g.,

<UpdateParameters>
<asparameter Name="VendorVanNo" Type="Int32"/>
<asparameter Name="Active" Type="Boolean"/>
</UpdateParameters>

 

[Guest]

Aha, the fog is clearing! and the UpdateParameter uses the C# datatype, not
the SQL datatype as in boolean vs bit.

Thanks Phillip

 

[Mike Larkin]

Thanks for the tip! I was trying to use a ControlParameter