Can not Edit gridview having TemplateField

Author Topic
cool coder
Member

Joined: 16 Nov 2007
Country:
Posts: 5

Posted: 05 Mar 2008 10:33:29

Hi,

I have a gridview which is having a TemplateField with a checkbox.When I edit this field an erro is occured saying,"Could not find control 'chkPrimary' in ControlParameter 'Primary_Skill'."I am giving the code below..Plz help me...

<asp:GridView id="gdSkills" runat="server" DataSourceID="SqlDataSource1" DataKeyNames="Emp_code,Skill_Id" PageSize="15" AllowPaging="True" AutoGenerateColumns="False">
<HeaderStyle CssClass="gridViewHeader" />
<RowStyle CssClass="gridViewRowStyle" Wrap="False" Width="100%" />
<AlternatingRowStyle CssClass="gridViewAlternative" Wrap="False" Width="100%" />
<Columns>
<asp:BoundField DataField="Skill_name" HeaderText="Skill" ReadOnly="True" />
<asp:BoundField DataField="No_Months" HeaderText="No of Months" />
<asp:TemplateField HeaderText="Primary">
<ItemTemplate>
<asp:CheckBox ID="chkPrimary" runat="server" Checked='<%# GetBoolean(Eval("Skill_Id",Eval("Emp_code")%>' />
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton= "True"/>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ProviderName="System.Data.SqlClient"

ConnectionString="<%$ ConnectionStrings:MyDatabase%>"


SelectCommand="select ES.Skill_id,Skill_name,emp_code,No_Months,Primary_Skill from Skill S
join Emp_skills ES on S.Skill_id=ES.Skill_id
where emp_code=@Emp_code order by Skill_name"
UpdateCommand="update emp_Skills set No_Months=@No_Months,Primary_Skill=@Primary_Skill where Skill_id=@Skill_id AND EMP_CODE=@Emp_Code">
<SelectParameters>
<asp:SessionParameter Name="Emp_code" SessionField="Empcode" Type="String" />
</SelectParameters>
<UpdateParameters>
&lt;asp<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>arameter Name="No_Months" Type="Double" /&gt;
&lt;asp<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>arameter Name="Skill_id" Type="Int32" /&gt;
&lt;asp:ControlParameter Name="Primary_Skill" ControlID="chkPrimary" /&gt;
&lt;asp:SessionParameter Name="Emp_code" SessionField="Empcode" Type="String" /&gt;
&lt;/UpdateParameters&gt;
&lt;/asp:SqlDataSource&gt;

Hi,

I have a gridview which is having a TemplateField with a checkbox.When I edit this field an erro is occured saying,"Could not find control 'chkPrimary' in ControlParameter 'Primary_Skill'."I am giving the code below..Plz help me...

&lt;asp:GridView id="gdSkills" runat="server" DataSourceID="SqlDataSource1" DataKeyNames="Emp_code,Skill_Id" PageSize="15" AllowPaging="True" AutoGenerateColumns="False"&gt;
&lt;HeaderStyle CssClass="gridViewHeader" /&gt;
&lt;RowStyle CssClass="gridViewRowStyle" Wrap="False" Width="100%" /&gt;
&lt;AlternatingRowStyle CssClass="gridViewAlternative" Wrap="False" Width="100%" /&gt;
&lt;Columns&gt;
&lt;asp:BoundField DataField="Skill_name" HeaderText="Skill" ReadOnly="True" /&gt;
&lt;asp:BoundField DataField="No_Months" HeaderText="No of Months" /&gt;
&lt;asp:TemplateField HeaderText="Primary"&gt;
&lt;ItemTemplate&gt;
&lt;asp:CheckBox ID="chkPrimary" runat="server" Checked='&lt;%# GetBoolean(Eval("Skill_Id",Eval("Emp_code")%&gt;' /&gt;
&lt;/ItemTemplate&gt;
&lt;/asp:TemplateField&gt;
&lt;asp:CommandField ShowEditButton= "True"/&gt;
&lt;/Columns&gt;
&lt;/asp:GridView&gt;
&lt;asp:SqlDataSource ID="SqlDataSource1" runat="server"
ProviderName="System.Data.SqlClient"

ConnectionString="&lt;%$ ConnectionStrings:MyDatabase%&gt;"


SelectCommand="select ES.Skill_id,Skill_name,emp_code,No_Months,Primary_Skill from Skill S
join Emp_skills ES on S.Skill_id=ES.Skill_id
where emp_code=@Emp_code order by Skill_name"
UpdateCommand="update emp_Skills set No_Months=@No_Months,Primary_Skill=@Primary_Skill where Skill_id=@Skill_id AND EMP_CODE=@Emp_Code"&gt;
&lt;SelectParameters&gt;
&lt;asp:SessionParameter Name="Emp_code" SessionField="Empcode" Type="String" /&gt;
&lt;/SelectParameters&gt;
&lt;UpdateParameters&gt;
&lt;asp<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>arameter Name="No_Months" Type="Double" /&gt;
&lt;asp<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>arameter Name="Skill_id" Type="Int32" /&gt;
&lt;asp:ControlParameter Name="Primary_Skill" ControlID="chkPrimary" /&gt;
&lt;asp:SessionParameter Name="Emp_code" SessionField="Empcode" Type="String" /&gt;
&lt;/UpdateParameters&gt;
&lt;/asp:SqlDataSource&gt;
Follow us on twitter Subscribe to our RSS feed
Activate your free membership today | Login | Currency