How to link a dropdown in gridview?

Question

I have a gridview in which each row contains a drop down list. I want to dynamically link each dropdown. Can someone tell me how I can do this. Thanks at Advance

Answer 1

If you use a column of templates, you can bind a drop-down menu from the markup using data binding expressions. For instance,

<asp:TemplateField HeaderText="XYZ">
  <ItemTemplate>
    <asp:DropDownList runat="server" ID="MyDD" DataSourceId="MyDataSource" />
  </ItemTemplate> 
</asp:TemplateField>

The above assumes your dropdown data is row-wise. If it changes, you can use a data binding expression such as

<asp:DropDownList runat="server" DataSource='<%# GetDropDownData(Container) %>' DataTextField="Text" DataValueField="Value"  />

GetDropDownData will be a protected method in the code that will return data (data table, list, array) for a given row.

GridView.RowDataBound ( RowCreated) . ,

  protected void GridView_RowDataBound(Object sender, GridViewRowEventArgs e)
  {

    if(e.Row.RowType == DataControlRowType.DataRow)
    {
      // Find the drop-down (say in 3rd column)
      var dd = e.Row.Cells[2].Controls[0] as DropDownList;
      if (null != dd) {
         // bind it
      }

      /*
      // In case of template fields, use FindControl
      dd = e.Row.Cells[2].FindControl("MyDD") as DropDownList;
      */
    }

  }

Answer 2

:

<asp:GridView ID="MyGrid" runat="server" DataSourceID="MyDataSource1">
    <Columns>
        <asp:TemplateField>
            <EditItemTemplate>
                <asp:DropDownList ID="DropDownList1" runat="server" SelectedValue='<%# Bind ("CustomerId") %>' DataSourceID="CustomersDataSource" DataTextField="CustomerName" DataValueField="CustomerId" >
                </asp:DropDownList>
            </EditItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Answer 3

gridview

<asp:GridView ID="grvExcelData" runat="server" onrowdatabound="GridView2_RowDataBound">
    <HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" />
      <Columns>
          <asp:TemplateField>
              <ItemTemplate>
                 <asp:DropDownList ID="DrdDatabase" Width="100px" runat="server">
                 </asp:DropDownList>
              </ItemTemplate>
          </asp:TemplateField>
      </Columns>
  </asp:GridView>

RowDataBound gridview

    protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
    {
       string cities = "maxico,chennai,newdelhi,hongkong";
       string [] arr = cities.Split(',');
    // Instead of string array it could be your data retrieved from database.
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DropDownList ddl = (DropDownList)e.Row.FindControl("DrdDatabase");
            foreach (string colName in arr )
                ddl.Items.Add(new ListItem(colName));
        }
    }

Answer 4

Microsoft, DropDownList DropDownList. , DropDownList, GridView, , ? , - , . ID ddl ; , ASPX , "NULLEXCEPTION", . , : ", - ? ...

Answer 5

protected void gvSalesAppData_RowDataBound(Object sender, GridViewRowEventArgs e)

    {

        if (e.Row.RowType == DataControlRowType.DataRow)
        {

            DropDownList ddlCurrentPhase = (DropDownList)e.Row.FindControl("ddlCurrentPhase");
            DropDownList ddlProductFamily = (DropDownList)e.Row.FindControl("ddlProductFamily");
            DropDownList ddlProductGroup = (DropDownList)e.Row.FindControl("ddlProductGroup");
            DropDownList ddlETProgramManager = (DropDownList)e.Row.FindControl("ddlETProgramManager");
            DropDownList ddlPLMForTheProduct = (DropDownList)e.Row.FindControl("ddlPLMForTheProduct");

            TrackingToolObj.BindCurrentPhases(ddlCurrentPhase);
            TrackingToolObj.BindCurrentPhases(ddlProductFamily);
            TrackingToolObj.BindProductGroups(ddlProductGroup);
            TrackingToolObj.GetEmployeesBasedOnRoleTypeId(ddlETProgramManager, (int)OSAEnums.RoleTypes.ProgramManager, false);
            TrackingToolObj.GetEmployeesBasedOnRoleTypeId(ddlPLMForTheProduct, (int)OSAEnums.RoleTypes.PLM, false);


        }

    }

Answer 6

GridView Binding

The following is the data binding code for the GridView control.

WITH#

protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack) 
   {
     this.BindData();   
   }
} 

private void BindData()
{
   string query = "SELECT top 10 * FROM Customers";    
   SqlCommand cmd = new SqlCommand(query);    
   gvCustomers.DataSource = GetData(cmd);    
   gvCustomers.DataBind(); 
}

private DataTable GetData(SqlCommand cmd)
{    
    string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;    
    using (SqlConnection con = new SqlConnection(strConnString))   
    {        
       using (SqlDataAdapter sda = new SqlDataAdapter())     
       {            
          cmd.Connection = con;            
          sda.SelectCommand = cmd;            
          using (DataTable dt = new DataTable())  
          {                
              sda.Fill(dt);                
              return dt;
          }     
       }   
    }
}