how to get values from databa into my lables

Question

hi friends
iam having a dropdownlist when iam selecting employee name from that dropdownlist

i want to display that perticuler employee details will display in to my lables.

please help me iam new to this topic..

thank you..

Satyapriya Nayak · Answer

Here the code is working fine.

chandu gummadi · Answer

DropDownList1.Items.Add(reader[empname].ToString()); IAM GETTING ERROR IN PLACE OF [empname] like indexoutofrange exception was unhandled by user code wt whould i write there

Satyapriya Nayak · Answer

Untitled Page Text=Search /> 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_click_data_in_textbox { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { DropDownList1.Items.Add(Choose name); con.Open(); str = select * from employee; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader[empname].ToString()); } reader.Close(); con.Close(); } } private void clear() { Label1.Text = ; Label2.Text = ; } protected void btn_search_Click(object sender EventArgs e) { clear(); SqlConnection con = new SqlConnection(strConnString); con.Open(); str = select * from employee where empname=' + DropDownList1.SelectedItem.Text + '; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { Label1.Text = reader[empaddress].ToString(); Label2.Text = reader[sal].ToString(); } reader.Close(); con.Close(); } } }

chandu gummadi · Answer

friend how is it possible to write dropdownlist selected index code why should we write. i want write code in search button only. like first i want 2 select employee name from dropdown list next i will click search button. after click the search button i want to display that perticuler employee details will diplay in to my labels. i want this code.

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_click_data_in_textbox { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; 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); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { TextBox1.Text = reader[name].ToString(); } reader.Close(); con.Close(); } } }