Match the value In the DropDownlist through SQL IN ASP.NET?

Question

Hi Friends,
I made a table in the SQL DATABASE in which two values are displayed one is the value and other is the code of that particular value. Now In Asp.net all these values are displayed in the dropdownlist. I want when I click on any value in the dropdownList the corresponding code of that clicked value will be fetch from the database and Display that code in the label. How can this possible? Please help me out.

Santhosh Kumar Jayaraman · Answer

In the dropdownlist selection changed event if (DropDownList1.SelectedIndex != 0) { string strValue = string.Empty; SqlConnection con = new SqlConnection(" Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; "); SqlCommand cmd = new SqlCommand(" select Empname from Employee where empid='"+ DropDownList1.SelectedValue.ToString()+"'", con); con.Open(); strValue = (string)cmd.ExecuteScalar(); con.Close(); TextBox1.Text = strValue; }

prakash kumawat · Answer

what to do if the selection mode is multiple in listbox and I want to display those records which are selected in the list box

Satyapriya Nayak · Answer

Hi Richa, 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(); } } } Thanks If this post helps you mark it as answer

Match the value In the DropDownlist through SQL IN ASP.NET?

Nitin Sontakke