gettting data from gridview to dropdownlist

Question

I am trying to get the data from gridview to the controls on the webform. I am able to get all teh values except dropdownlist. Thanks

Rajanikant Hawaldar · Answer

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 ; }

entry level · Answer

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

Rajanikant Hawaldar · Answer

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/

Pranam Bhat · Answer

Code: ' DataSourceID="CustomersDataSource" DataTextField="CustomerName" DataValueField="CustomerId" > 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

gettting data from gridview to dropdownlist

Answers (4)