How to search based on selection of column name in the combox?

Question

How to search based on selection of column name in the combox and give the corresponding text in the text box in windows using LinqTo sql Query

paddu v · Answer

Thank u Satyapriya nayak But i need Query in linqToSql

Jignesh Trivedi · Answer

hi, Same thing you can acheive by Java Script. Example : if you have drop down and text on aspx page. changeCombo (this); return false;"> And Write in javascript function changeCombo(obj) { var w = document.getElementById(obj.id).selectedIndex; var selectedtext = document.getElementById(obj.id).options[w].text; document.getElementById(' ').value = selectedtext; } hope this will help you.

Satyapriya Nayak · Answer

Hi Padmaja, 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

How to search based on selection of column name in the combox?

Answers (3)