Hi i am trying to update record inside gridview. although i am not getting any error but its not updating the record either.


<asp:GridView ID="GV_ApproveNomination" runat="server" AutoGenerateColumns ="TRUE" DataKeyNames="ContestantID" DataSourceID ="sqlDataSource1">



<Columns>
<asp:BoundField DataField="ContestantID" HeaderText="ContestantID" />
<asp:BoundField DataField="iContestantName" HeaderText="Contestant Name" />
<asp:BoundField DataField="iContestantCompany" HeaderText="Contestant Company" />
<asp:CommandField ShowEditButton="True"/>

<asp:TemplateField HeaderText="ContestantID" SortExpression="ContestantID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Activate") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Activate") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:GAConnectionString %>"
SelectCommand ="SELECT [ContestantID], [iContestantName] ,[iContestantCompany] ,[iContestantStore] ,[iNominationText] ,[iNominatorPhone] ,[iNominatorEmail], [Activate] FROM [NhmMicrosites].[dbo].[SMOTY_tblContestant]"
UpdateCommand ="UPDATE SMOTY_tblContestant SET Activate =@Activate where ContestantID = @ContestantID"
>
<UpdateParameters>
<asp:Parameter Name="Activate" Type ="int32" />
<asp:Parameter Name="ContestantID" Type ="int32" />
</UpdateParameters>



</asp:SqlDataSource>

__________________
Cheers
Sheraz