how can show selected drop down list value in gridview

Question

Satyapriya Nayak · Answer

Hi Anuj, Try this... Untitled Page onselectedindexchanged="DropDownList1_SelectedIndexChanged"> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Select_dropdownlist_value_gridview { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; DataSet ds; SqlDataAdapter sqlda; protected void Page_Load(object sender, EventArgs e) { DropDownList1.AutoPostBack = true; SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { DropDownList1.Items.Add("Choose id"); con.Open(); str = "select * from test"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader["id"].ToString()); } reader.Close(); con.Close(); } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select * from test where id='" + DropDownList1.SelectedItem.Text + "'"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "test"); GridView1.DataMember = "test"; GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } } } Thanks If this post helps you mark it as answer

how can show selected drop down list value in gridview

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)