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