update dropdown value in db

Sheraz Khan · June 9th, 2010, 03:32 PM

I want to update when someone click on UPDATE button. But for somereason its not updating.

Code:

            <asp:TemplateField HeaderText="Gender">
                <ItemTemplate>
                   <asp:Label ID="lblGender" runat="server" Text='<%# Bind("Gender") %>'></asp:Label>
                </ItemTemplate>
        
                <EditItemTemplate>
                
                 <asp:DropDownList ID="DdlGender" runat="server" SelectedValue ='<%# Bind("Gender")%>'>
                        <asp:ListItem Value="M" Text="Male"></asp:ListItem>
                        <asp:ListItem Value="F" Text="Female"></asp:ListItem>
                </asp:DropDownList>
                
                    
                </EditItemTemplate>
            </asp:TemplateField>

Code:

    Protected Sub GV_ApproveNomination_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GV_ApproveNomination.RowUpdating

        Dim dl As DropDownList = DirectCast(GV_ApproveNomination.Rows(e.RowIndex).FindControl("DdlGender"), DropDownList)
        e.NewValues("Gender") = dl.SelectedValue

    End Sub

And my sql query is:

Code:

SelectCommand="SELECT [ContestantID], [iNominatorEmail], RTrim(ltrim([iGender])) as Gender  FROM [mydb].[dbo].[abc_tblxyz]"