gettting data from gridview to dropdownlist

Refer below sample.

HTML:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />
<asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" />
<asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" />
<asp:CommandField ShowSelectButton="true" />
Columns>
asp:GridView>
<asp:DropDownList runat="server" ID="ddlId">
asp:DropDownList>
<asp:DropDownList runat="server" ID="ddName">
asp:DropDownList>
<asp:DropDownList runat="server" ID="ddlCountry">
asp:DropDownList>

C#:

protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
new DataColumn("Name", typeof(string)),
new DataColumn("Country",typeof(string)) });
dt.Rows.Add(1, "John Hammond", "United States");
dt.Rows.Add(2, "Mudassar Khan", "India");
dt.Rows.Add(3, "Suzanne Mathews", "France");
dt.Rows.Add(4, "Robert Schidner", "Russia");
GridView1.DataSource = dt;
GridView1.DataBind();
ddlId.DataSource = dt;
ddlId.DataTextField = "Id";
ddlId.DataValueField = "Id";
ddlId.DataBind();
ddName.DataSource = dt;
ddName.DataTextField = "Name";
ddName.DataValueField = "Name";
ddName.DataBind();
ddlCountry.DataSource = dt;
ddlCountry.DataTextField = "Country";
ddlCountry.DataValueField = "Country";
ddlCountry.DataBind();
ListItem select = new ListItem("Select", "0");
ddlId.Items.Insert(0, select);
ddName.Items.Insert(0, select);
ddlCountry.Items.Insert(0, select);
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
ddlId.ClearSelection();
ddlId.Items.FindByText(row.Cells[0].Text).Selected = true;
ddName.ClearSelection();
ddName.Items.FindByText(row.Cells[1].Text.Trim()).Selected = true;
ddlCountry.ClearSelection();
ddlCountry.Items.FindByText(row.Cells[2].Text.Trim()).Selected = true;
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Refer below sample.
HTML:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />
        <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" />
        <asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" />
        <asp:CommandField ShowSelectButton="true" />
    Columns>
asp:GridView>
<asp:DropDownList runat="server" ID="ddlId">
asp:DropDownList>
<asp:DropDownList runat="server" ID="ddName">
asp:DropDownList>
<asp:DropDownList runat="server" ID="ddlCountry">
asp:DropDownList>
C#:
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
                        new DataColumn("Name", typeof(string)),
                        new DataColumn("Country",typeof(string)) });
        dt.Rows.Add(1, "John Hammond", "United States");
        dt.Rows.Add(2, "Mudassar Khan", "India");
        dt.Rows.Add(3, "Suzanne Mathews", "France");
        dt.Rows.Add(4, "Robert Schidner", "Russia");
        GridView1.DataSource = dt;
        GridView1.DataBind();
        ddlId.DataSource = dt;
        ddlId.DataTextField = "Id";
        ddlId.DataValueField = "Id";
        ddlId.DataBind();

        ddName.DataSource = dt;
        ddName.DataTextField = "Name";
        ddName.DataValueField = "Name";
        ddName.DataBind();

        ddlCountry.DataSource = dt;
        ddlCountry.DataTextField = "Country";
        ddlCountry.DataValueField = "Country";
        ddlCountry.DataBind();
        ListItem select = new ListItem("Select", "0");
        ddlId.Items.Insert(0, select);
        ddName.Items.Insert(0, select);
        ddlCountry.Items.Insert(0, select);
    }
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
    GridViewRow row = GridView1.SelectedRow;
    ddlId.ClearSelection();
    ddlId.Items.FindByText(row.Cells[0].Text).Selected = true;
    ddName.ClearSelection();
    ddName.Items.FindByText(row.Cells[1].Text.Trim()).Selected = true;
    ddlCountry.ClearSelection();
    ddlCountry.Items.FindByText(row.Cells[2].Text.Trim()).Selected = true;
}
+1
entry level5y ago
Hi

My dropdownlist is not inside gridview. It is on the form. I am trying to get the value from gridview to the dropdownlist which is on the form.

Thanks
+1
Rajanikant Hawaldar5y ago
check below article, in GridView1_RowUpdating event code is there.

https://www.c-sharpcorner.com/UploadFile/009464/crud-operation-of-dropdownlist-inside-gridview-in-Asp-Net/
+1
Pranam Bhat5y ago
Code:

Here is the demo:

https://www.aspsnippets.com/Articles/How-to-populate-DropDownList-in-GridView-in-ASPNet.aspx

https://www.c-sharpcorner.com/UploadFile/009464/use-dropdownlist-in-gridview-in-Asp-Net-using-C-Sharp/

https://www.codeproject.com/Articles/53559/Accessing-a-DropDownList-inside-a-GridView
+1