How to add Data in gridview from Dropdownlist ?

Question

I want to add data from dropdown list to gridview ,,, here my code con.Open(); SqlDataAdapter adpr1 = new SqlDataAdapter( 'select * from ItemMasterFile ' , con); DataSet dspr1 = new DataSet(); adpr1.Fill(dspr1); DropDownList1.DataSource = dspr1.Tables[0]; DropDownList1.DataTextField = 'Descriptionitem' ; DropDownList1.DataValueField = 'Codeitem' ; DropDownList1.DataBind(); i want to insert Datatextfield and Datavalue into gridview...

Priyanka Jain · Answer

As per code provided it is working fine html "http://www.w3.org/1999/xhtml" > "server" > "form1" runat= "server" > CodeItems : "DropDownList1" runat= "server" > Qty : "server" ID= "txtqty" /> "Insert" runat= "server" OnClick= "GVadd_Click" /> "GridView1" runat= "server" AutoGenerateColumns= "false" > "Codeitem" HeaderText= "Code" /> "Descriptionitem" HeaderText= "Name" /> "QTY" HeaderText= "QTY" /> c# code private SqlConnection con = new SqlConnection(@ " " ); private DataTable dt = new DataTable(); private DataRow dr; protected void Page_Load( object sender, EventArgs e) { if (! this .IsPostBack) { dt.Columns.Add( "Codeitem" ); dt.Columns.Add( "Descriptionitem" ); dt.Columns.Add( "QTY" ); ViewState[ "dt" ] = dt; itemload(); } } private void itemload() { con.Open(); SqlDataAdapter adpr1 = new SqlDataAdapter( "select * from ItemMasterFile " , con); DataSet dspr1 = new DataSet(); adpr1.Fill(dspr1); DropDownList1.DataSource = dspr1.Tables[0]; DropDownList1.DataTextField = "Descriptionitem" ; DropDownList1.DataValueField = "Codeitem" ; DropDownList1.DataBind(); } protected void GVadd_Click( object sender, EventArgs e) { dt = ViewState[ "dt" ] as DataTable; dr = dt.NewRow(); dr[ "Codeitem" ] = DropDownList1.SelectedValue; dr[ "Descriptionitem" ] = DropDownList1.SelectedItem.Text.Trim(); dr[ "QTY" ] = txtqty.Text; dt.Rows.Add(dr); GridView1.DataSource = dt; GridView1.DataBind(); clear(); } private void clear() { // Codeitem.Text = ""; txtqty.Text = "" ; } Output will be as below

Priyanka Jain · Answer

You need to use onRowDataBound event of GridView to bind DropdownList in Gridview For more detail you can refer below link https://www.aspsnippets.com/Articles/How-to-populate-DropDownList-in-GridView-in-ASPNet.aspx

Puneet Kankar · Answer

Hi Akhter, Go through given below link, You can use ViewState and session for hold data in grid view and button click event you can write code for put dropdown data in gridview https://forums.asp.net/t/1915866.aspx?How+to+add+Data+To+GridView+From+TextBox+DropDownList

Akhter HUssain · Answer

Hi Puneet kankar, my dropdownlist is not in gridview ,it is out of gridview ,i want to insert data from dropdownlist to gridview... i have provided html below...and i want to insert textfiled and valuefield into gridview.

Akhter HUssain · Answer

No i do not want this.... i want to add data from dropdownlist into gridview here is html %@ Page Language = "C#" AutoEventWireup = "true" CodeBehind = "WebForm2.aspx.cs" Inherits = "WebApplication1.WebForm2" % > > html xmlns = "http://www.w3.org/1999/xhtml" > head runat = "server" > title > title > head > body > form id = "form1" runat = "server" > div > CodeItems : asp:DropDownList ID = "DropDownList1" runat = "server" > asp:DropDownList > br /> Qty : asp:TextBox runat = "server" ID = "txtqty" /> br /> asp:Button Text = "Insert" runat = "server" OnClick = "GVadd_Click" /> asp:GridView ID = "GridView1" runat = "server" AutoGenerateColumns = "false" > Columns > asp:BoundField DataField = "Codeitem" HeaderText = "Code" /> asp:BoundField DataField = "Descriptionitem" HeaderText = "Name" /> asp:BoundField DataField = "QTY" HeaderText = "QTY" /> Columns > asp:GridView > br /> div > form > body > html > here is my c# Code using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; namespace WebApplication1 { public partial class WebForm2 : System.Web.UI.Page { SqlConnection con = new SqlConnection( "Data Source=DESKTOP-5PJ76B9;Integrated Security=SSPI;Initial Catalog=SPS;MultipleActiveResultSets=True;" ); DataTable dt = new DataTable(); DataRow dr; protected void Page_Load( object sender, EventArgs e) { if (! this .IsPostBack) { dt.Columns.Add( "Codeitem" ); // dt.Columns.Add("Descriptionitem"); dt.Columns.Add( "QTY" ); ViewState[ "dt" ] = dt; itemload(); } } private void itemload() { con.Open(); SqlDataAdapter adpr1 = new SqlDataAdapter( "select * from ItemMasterFile " , con); DataSet dspr1 = new DataSet(); adpr1.Fill(dspr1); DropDownList1.DataSource = dspr1.Tables[0]; DropDownList1.DataTextField = "Descriptionitem" ; DropDownList1.DataValueField = "Codeitem" ; DropDownList1.DataBind(); } protected void GVadd_Click( object sender, EventArgs e) { dt = ViewState[ "dt" ] as DataTable; dr = dt.NewRow(); dr[ "Codeitem" ] = DropDownList1.SelectedValue; // dr["Descriptionitem"] = DropDownList1.SelectedItem.Text.Trim(); dr[ "QTY" ] = txtqty.Text; dt.Rows.Add(dr); GridView1.DataSource = dt; GridView1.DataBind(); clear(); } private void clear() { // Codeitem.Text = ""; txtqty.Text = "" ; } } } i want both filed to display in gridview Description item and codeitem DropDownList1.DataTextField = "Descriptionitem" ; DropDownList1.DataValueField = "Codeitem" ;

How to add Data in gridview from Dropdownlist ?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)