Combobox multiselection search like filter in MS Excell

Konstantin Pankarican

Hello,
I am working on a project where I need to display data from database to datagridview depending on combobox multiselection. Something like Data filter in MS Excell.
On checking or unckecking combobox item populate datagridview.
I was thinking to achieve this in this way?

SELECT * FROM articles WHERE name LIKE
Combobox is populating from database.

I am working in VS 2010, sqlCEserver, .net 3.5
Can someone have any idea how to do it?

Thank you.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
it is only combobox, you said you have checkbox also

Regards,
Iftikar
Konstantin Pankarican13y ago
Hello,
here's the code:

conn.Open();
SqlCommand sc = new SqlCommand("select naziv,cena from artikli", conn);
SqlDataReader reader; reader = sc.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add("naziv", typeof(string));
dt.Columns.Add("cena", typeof(string));
dt.Load(reader); comboBox1.ValueMember = "naziv"; comboBox1.DisplayMember = "cena"; comboBox1.DataSource = dt; conn.Close();
Iftikar Hussain13y ago
can you share the code for binding combobox with checkbox from database?

Regards,
Iftikar
Konstantin Pankarican13y ago
Hello, no it's not the same post. In my second program I have client's name and items that he bought from my store shown in datagridview. Items are from database. What I want to do is to have a combobox with checkboxes and filter bought item. Also I want in combobox to have select all items checkbox. Maybe there is more simple way to do this. Please help.
Iftikar Hussain13y ago
Hi,
Is it the same post

http://www.c-sharpcorner.com/Forums/Thread/221920/filtering-database-data.aspx

Regards,
Iftikar