How to bind dropdown in a gridview?

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {

            DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList1");
            // then bind the ddl
        }
    }

Posted 11-Jun-11 3:31am

Parwej Ahamad

Updated 11-Jun-11 3:32am

v2

Comments

manuthebos 30-Jun-13 4:50am

i typed this code but its only work with first items .. (VS 2012 C# )

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList dl = (DropDownList)e.Row.FindControl("DropDownList1");
if (dl != null)
{
SqlDataReader dr = obj.Reader("select * from category");
dl.DataSource = dr;
dl.DataTextField = "name";
dl.DataValueField = "id";
dl.DataBind();
}
}
}

Shahriar Iqbal Chowdhury/Galib · Answer 2 · 2011-06-11T04:25:00

Hi,

You can use either GridView RowDataBound event to bind dropdown or you can use a simple Foreach loop to iterate and bind each dropdown in a

GridView<br />

. If you use RowDataBound Event, On *.aspx page

XML

<asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound">
</asp:GridView>

and on *.aspx.cs use this code below

C#

void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)
{
  if(e.Row.RowType == DataControlRowType.DataRow)
  {
    DropDownList  drdList=(DropDownList)e.Row.FindControl("DropDownList1");
  }
}

Or alternatively you can use the code below after DataBinding on GridView1

C#

DropDownList drdList;
foreach (GridViewRow grdRow in GridView1.Rows)
{
    /// Nested DropDownList Control reference is passed to the DrdList object. 
    ///This will allow you access the properties of dropdownlist placed inside the GridView Template column.
    drdList = (DropDownList)( GridView1.Rows[ grdRow.RowIndex ].Cells[1].FindControl( "DropDownList1" ));

    // DataBinding of nested DropDownList Control for each row of GridView.
    drdList.DataSource = myDataSet;
    drdList.DataValueField = "ColumnName";
    drdList.DataTextField = "ColumnName";
    drdList.DataBind();
}

You will find more details here[^]
Hope this will help.

chaosgray · Answer 3 · 2011-06-11T23:41:00

i think you should use a Data Set for that.
on the Data set, add a datatable. when you finish adding.
add another Query then from that. Write this

WHERE column name=@column name
then rebuild your code.

after that, choose a datasource from your dropdown.
choose objectdatasource

select the one you first created on your dataset.
and from there you will select from which you want to control.

then from your gridview.
select the second one.

-CG-

ambarishtv · Answer 4 · 2011-06-11T23:56:00

Solution 4

This links will help you

http://csharpdotnetfreak.blogspot.com/2009/08/radiobuttonlist-dropdown-gridview-edit.html[^]
http://www.aspnettutorials.com/tutorials/controls/dropdownlist-gridview-csharp.aspx[^]

Posted 11-Jun-11 23:56pm

ambarishtv

How to bind dropdown in a gridview?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

How to bind dropdown in a gridview?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us