how use drop down list as as search text

Question

Sir How to use drop down list as a search text box like if country name Like U press then come like United states United Kingdom etc. how to use drop down in this way Anil Jain

Senthilkumar · Answer

Hi Design the gridview control. AllowPaging=True AllowSorting=true DataSourceID=dsGridview Width=540px PageSize=10> HighlightText(Eval(FirstName)) %>' runat=server /> HighlightText(Eval(LastName)) %>' runat=server /> SortExpression=Department ItemStyle-Width=130px /> SortExpression=Location ItemStyle-Width=130px /> Place the drop down list as well. Bind the all country names into the drop down list control. Fill the drop down string _ConnectionString = Data Source=SSD438\SQLEXPRESS;Initial Catalog=Master;Integrated Security=true;; SqlConnection sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = _ConnectionString; sqlConnection.Open(); string sqlQuery = SELECT * FROM Country; SqlCommand sqlCommand = new SqlCommand(sqlQuery sqlConnection); sqlCommand.CommandType = CommandType.Text; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); ddlCountry.DataSource = dataSet.Tables[0]; ddlCountry.DataTextField = CountryName; ddlCountry.DataValueField = CountryID; ddlCountry.DataBind(); protected void ddlCountry_SelectedIndexChanged(object sender EventArgs e) { SqlConnection sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = _ConnectionString; sqlConnection.Open(); string sqlQuery = SELECT * FROM Employees WHERE name LIKE +ddlCountry.SelectedItem.Value.ToString(); SqlCommand sqlCommand = new SqlCommand(sqlQuery sqlConnection); sqlCommand.CommandType = CommandType.Text; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); GridView1.DataSource = dataSet.Tables[0]; gridView1.DataBind(); }