Gridview dropdown fill on Gridview_Editing

See more:

C#

ASP.NET

Hi!

I am doing a code to edit row in gridview but I have a query.
I need my dropdown city to be filled and selected in on edition.
So how to do it?

<asp:GridView ID="gvAdmin" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
           CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%" OnRowEditing="gvAdmin_RowEditing"
           OnRowCancelingEdit="gvAdmin_RowCancelingEdit" OnRowDeleting="gvAdmin_RowDeleting"
           OnRowUpdating="gvAdmin_RowUpdating">
           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
           <EditRowStyle BackColor="#999999" />
           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" HorizontalAlign="Left" />
           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
           <SortedAscendingCellStyle BackColor="#E9E7E2" />
           <SortedAscendingHeaderStyle BackColor="#506C8C" />
           <SortedDescendingCellStyle BackColor="#FFFDF8" />
           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
           <Columns>
               <asp:TemplateField>
                   <HeaderTemplate>
                       <asp:CheckBox ID="chkHeader" runat="server" OnClick="javascript:SelectAll();" />
                   </HeaderTemplate>
                   <ItemTemplate>
                       <asp:CheckBox ID="chkDelete" runat="server" OnClick="javascript:DeselectHeader();" />
                   </ItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="Full Name">
                   <ItemTemplate>
                       <%#Eval("firstname")+" "+ Eval("lastname") %>
                   </ItemTemplate>
                   <EditItemTemplate>
                       <asp:TextBox ID="txtFirstName" Width="70px" Text='<%#Eval("firstname")%>' runat="server"></asp:TextBox>
                       <asp:TextBox ID="txtLastName" Width="70px" Text='<%#Eval("lastname")%>' runat="server"></asp:TextBox>
                   </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="Gender">
                   <ItemTemplate>
                       <asp:Label ID="lblGender" runat="server" Text='<%#Convert.ToInt32(Eval("gender"))==1?"Male":"Female"%>'></asp:Label>
                   </ItemTemplate>
                   <EditItemTemplate>
                       <asp:RadioButton ID="rbMale" GroupName="gnGender" runat="server" Text="Male" Checked='<%#Eval("gender") %>' />
                       <asp:RadioButton ID="rbFemale" GroupName="gnGender" runat="server" Text="Female"
                           Checked='<%#Eval("gender") %>' />
                   </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="Email-Id">
                   <ItemTemplate>
                       <%#Eval("email")%>
                   </ItemTemplate>
                   <EditItemTemplate>
                       <asp:TextBox ID="txtEmail" Text=' <%#Eval("email")%>' runat="server"></asp:TextBox>
                   </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="Username">
                   <ItemTemplate>
                       <%#Eval("username")%>
                   </ItemTemplate>
                   <EditItemTemplate>
                       <asp:TextBox ID="txtUsername" Text=' <%#Eval("username")%>' runat="server" Width="65px"></asp:TextBox>
                   </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="City">
                   <ItemTemplate>
                       <%#Eval("cityname")%>
                   </ItemTemplate>
                   <EditItemTemplate>
                       <asp:DropDownList ID="ddlCity" runat="server">
                           <asp:ListItem Text="Select" Value="0" Selected="True"></asp:ListItem>
                           <asp:ListItem Text="Ahmedabad" Value="1"></asp:ListItem>
                           <asp:ListItem Text="Aanand" Value="2"></asp:ListItem>
                           <asp:ListItem Text="Bharuch" Value="3"></asp:ListItem>
                           <asp:ListItem Text="Valsad" Value="4"></asp:ListItem>
                           <asp:ListItem Text="Vadodra" Value="5"></asp:ListItem>
                       </asp:DropDownList>
                   </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="IsActive">
                   <ItemTemplate>
                       <asp:LinkButton OnClick="lnkActive_Click" CommandArgument='<%#Convert.ToInt32(Eval("isactive")) %>'
                           ID="lnkActive" runat="server" Text='<%#Eval("isactive").ToString()=="True"?"Yes":"No"%>'></asp:LinkButton>
                   </ItemTemplate>
                   <EditItemTemplate>
                       <asp:CheckBox ID="chkIsActive" runat="server" Checked='<%#Eval("isactive") %>' />
                   </EditItemTemplate>
               </asp:TemplateField>
               <asp:CommandField ShowEditButton="true" ShowDeleteButton="true" />
           </Columns>
       </asp:GridView>

protected void gvAdmin_RowEditing(object sender, GridViewEditEventArgs e)
   {
       gvAdmin.EditIndex = e.NewEditIndex;
       FillData();
   }
   protected void gvAdmin_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
   {
       gvAdmin.EditIndex = -1;
       FillData();
   }
   protected void gvAdmin_RowUpdating(object sender, GridViewUpdateEventArgs e)
   {
       obj.id = Convert.ToInt64(gvAdmin.DataKeys[e.RowIndex].Value.ToString());
       TextBox txtFirstName = (TextBox)(gvAdmin.Rows[e.RowIndex].FindControl("txtFirstName"));
       TextBox txtLastName = (TextBox)(gvAdmin.Rows[e.RowIndex].FindControl("txtLastName"));
       DropDownList ddlCity = (DropDownList)(gvAdmin.Rows[e.RowIndex].FindControl("ddlCity"));
       TextBox txtEmail = (TextBox)(gvAdmin.Rows[e.RowIndex].FindControl("txtEmail"));
       TextBox txtUsername = (TextBox)(gvAdmin.Rows[e.RowIndex].FindControl("txtUsername"));
       //TextBox txtPassword = (TextBox)(gvAdmin.Rows[e.RowIndex].FindControl("txtPassword"));
       RadioButton rbMale = (RadioButton)(gvAdmin.Rows[e.RowIndex].FindControl("rbMale"));
       RadioButton rbFemale = (RadioButton)(gvAdmin.Rows[e.RowIndex].FindControl("rbFemale"));
       CheckBox chkActive = (CheckBox)(gvAdmin.Rows[e.RowIndex].FindControl("chkIsActive"));
       obj.flag = "Update";
       obj.firstname = txtFirstName.Text;
       obj.lastname = txtLastName.Text;
       obj.emailid = txtEmail.Text;
       obj.username = txtUsername.Text;
       obj.password = "ravi123";
       obj.isactive = chkActive.Checked;
       obj.city = Convert.ToInt64(ddlCity.SelectedValue);
       if (rbMale.Checked == true)
       {
           obj.gender = Convert.ToBoolean(1);
       }
       else
       {
           obj.gender = Convert.ToBoolean(0);
       }
       obj.update();
       gvAdmin.EditIndex = -1;
       FillData();
   }
   protected void gvAdmin_RowDeleting(object sender, GridViewDeleteEventArgs e)
   {
       obj.id = Convert.ToInt64(gvAdmin.DataKeys[e.RowIndex].Value);
       obj.flag = "Delete";
       obj.Delete();
       gvAdmin.EditIndex = -1;
       FillData();
   }