Display Record

Question

Hi...

I am working in asp.net and i want to display record in database when we select the item in dropdownlist and gridview ie. show gridview record (like particular column value)and dropdownlist(select value) in database?

Vincent Maverick Durano · Answer

In case if someone stumble to this thread then h ere's a quick example using the ADO.NET way: private string GetConnectionString(){ //DBConnection is the name of the connection string that was set up from the web config file return System.Configuration.ConfigurationManager.ConnectionStrings[DBConnection].ConnectionString; } private void BindGridView(string field){ DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(GetConnectionString()); try { connection.Open(); string sqlStatement = SELECT * FROM TableName WHERE ColumnName = @Value1; SqlCommand sqlCmd = new SqlCommand(sqlStatement connection); sqlCmd.Parameters.AddWithValue(@Value1 field); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(dt); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } else { // NO RECORDS FOUND } } catch (System.Data.SqlClient.SqlException ex) { string msg = Fetch Error:; msg += ex.Message; throw new Exception(msg); } finally { connection.Close(); } } protected void DropDownLis1_SelectedIndexChanged(object sender EventArgs e) { BindGridView(DropDownList1.SelectecItem.Value); } Note: Make sure to set AutoPostback to TRUE in your dropdownlist to trigger the selectedindexchanged event.

Gowtham Rajamanickam · Answer

onselectedindexchanged=DropDownList1_SelectedIndexChanged. And grid autopostback = true

Raghav Mehra · Answer

Put your whole select query and fire that query on dropdown event of onselectedindexchanged=DropDownList1_SelectedIndexChanged. Also put the grid autopostback = true. If you still have any question show me your html code and the sql query you are firing at back. And I will implement it for you. Thanks.

Satyapriya Nayak · Answer

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 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(strcon); ds = new DataSet(); sqlda.Fill(ds employee); GridView1.DataMember = employee; GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } } }