i want to bind two dropdownlist into grid view

See more:

ASP.NET

I would like to bind two DropDownList into a GridView in ASP.NET.

I did bind one DropDownList with Databound event, but the problem is how can I bind the second DropDownList in the GridView?

One DropDownList completely binds with database, but the other does not bind with the same event or GridView.

My code:

public DataTable FetchCustomerType()
   {
       string sql = "Select Distinct type From cust_info";
       SqlDataAdapter da = new SqlDataAdapter(sql, conn);
       DataTable dt = new DataTable();
       da.Fill(dt);
       return dt;
   }

   public DataTable FetchCustomerGender()
   {
       string sql = "Select Distinct gender From cust_info";
       SqlDataAdapter da = new SqlDataAdapter(sql, conn);
       DataTable dt = new DataTable();
       da.Fill(dt);
       return dt;
   }

   protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
           DropDownList cmbtype = (DropDownList)e.Row.FindControl("cmbType");
           DropDownList cmbgender = (DropDownList)e.Row.FindControl("cmbGender");
           if (cmbtype != null && cmbgender !=null)
           {
               cmbtype.DataBind();
               cmbgender.DataBind();
               cmbtype.DataSource = FetchCustomerType();
               cmbgender.DataSource = FetchCustomerGender();
               cmbtype.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values[1].ToString();
               cmbgender.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values[2].ToString();
           }
       }



       if (e.Row.RowType == DataControlRowType.Footer)
       {
           DropDownList cmbnewtype = (DropDownList)e.Row.FindControl("cmbNewType");
           DropDownList cmbnewgnder =(DropDownList)e.Row.FindControl("cmbNewGender");
           cmbnewtype.DataSource = FetchCustomerType();
           cmbnewgnder.DataSource = FetchCustomerGender();
           cmbnewtype.DataBind();
           cmbnewgnder.DataBind();
       }

   }

Where should I put the other DropDownList coding into this code which executes properly?

Thank you.