how to retrieve specific row from database in gridview?

Question

i want, when i choose item from drop down list the selected column's item of database will show me that row data in grid view what i suppose to do?

selva kumar · Answer

set dropdownlist auto post back= True.... then..write the code on dropdownlist selected index changed event.... protected void ddl1_SelectedIndexChanged(object sender, EventArgs e) { if(ddl1.selecteditem==columnname) { sql dataadapter SDA=new sql dataadapter("Select column name from table name",Con); dataset Ds=new dataset(); SDA.Fill(Ds); gridview1.datasource=Ds; gridview1.databind(); } elseif(//column name//) { // same code // } } try this code this Will be working.....

Satyapriya Nayak · Answer

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 Dropdownlist_gridview { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { DropDownList1.Items.Add("Choose Id"); con.Open(); str = "select * from employee"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader["empid"].ToString()); } reader.Close(); con.Close(); } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select * from employee where empid='" + DropDownList1.SelectedItem.Text + "'"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(str,con); ds = new DataSet(); sqlda.Fill(ds, "employee"); GridView1.DataMember = "employee"; GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } } }

how to retrieve specific row from database in gridview?

Answers (2)