Filter Combo box or make combo box searchable

Question

I have two combobxo. One is Product and second is Model No.

When i am selecting any product from Product combo box associated Model_no fill into Model combo box but one product having thousand of model's.

I want to filter data into Model combo box.

Suppose If model no is : LED UA65ES8000

When i type 65 into Model Combo box all model no should come those having 65

Satyapriya Nayak · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Filter_Combobox { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { bind(); } private void bind() { comboBox1.Text = "--Select--"; OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from prod "; com = new OleDbCommand(str, con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds, "prod"); comboBox1.Items.Clear(); comboBox1.DataSource = ds.Tables["prod"]; comboBox1.ValueMember = "Modelid"; comboBox1.DisplayMember = "ModelNo"; con.Close(); } private void comboBox1_MouseDown(object sender, MouseEventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from prod where ModelNo like '%" + comboBox1.Text + "%'"; com = new OleDbCommand(str, con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds, "prod"); comboBox1.DataSource = ds.Tables["prod"]; comboBox1.ValueMember = "Modelid"; comboBox1.DisplayMember = "ModelNo"; con.Close(); comboBox1.Text = ""; } } } Thanks If this post helps you mark it as answer

Mayur Dighe · Answer

Hey Michale.......... you can do it....buddy........ just include the previous string into your search operation....means.. if you want search all records from LED UA65 series , just make sure that you are comparing LED UA letters along with your entered number... so first...make a code for verifying in which series you want search....then use search for entered number. happy Programming...........

Filter Combo box or make combo box searchable

Answers (2)