need help on multiple filters

Question

0.00/5 (No votes)

See more:

I have a datagridview, 8 textboxes, and a button, datagrid is filled with dataadapter, textboxes are used as filters, and they work fine when used one by one, but I want to combine them, only thing there is 8 of them, and there is a lot of combinations, how can I overcome this, here is the code I use for filtering one by one

C#

private void ACpodaci_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'tMNcentarDataSet.ACpodaci' table. You can move, or remove it, as needed.
            this.aCpodaciTableAdapter.Fill(this.tMNcentarDataSet.ACpodaci);
            
        }
        private void centrala_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACCentrala LIKE \'{0}%\'", this.centrala.Text);
        }
        private void lokal_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACLokalUKorporativnojMrezi LIKE \'{0}%\'", this.lokal.Text);
        }
        private void klasa_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACKlasa LIKE \'{0}%\'", this.klasa.Text);
        }
        private void tip_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACTipAparata LIKE \'{0}%\'", this.klasa.Text);
        }
        private void shelf_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACShelf LIKE \'{0}%\'", this.shelf.Text);
        }
        private void ploca_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACPloca LIKE \'{0}%\'", this.ploca.Text);
        }
        private void direkcija_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACDirekcija LIKE \'{0}%\'", this.direkcija.Text);
        }
        private void stanje_TextChanged(object sender, EventArgs e)
        {
            this.aCpodaciBindingSource.Filter = string.Format("ACStanje LIKE \'{0}%\'", this.stanje.Text);
        }

Posted 20-Jun-11 23:58pm

shonezi

Updated 21-Jun-11 0:05am

Tarun.K.S

v2

Add a Solution

2 solutions

Solution 1

Your best bet is a single function that creates filters using every textbox that has text in it. Every event should call it.

Posted 21-Jun-11 0:05am

Christian Graus

Comments

shonezi 21-Jun-11 6:06am

ok, how do I do that, I mean the code?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mart Rijkers · Accepted Answer · 2011-06-21T00:09:00

Can't you use a function to calculate the filter like:

private void filterAll()
{
string filter = string.Format("ACCentrala LIKE \'{0}%\'", this.centrala.Text);
filter += " AND ";
filter += string.Format("ACLokalUKorporativnojMrezi LIKE \'{0}%\'", this.lokal.Text);
.
.
.
this.aCpodaciBindingSource.Filter = filter;
}

Ofcourse you will need to test the values and see where you need to add the AND operators to construct a nice filter string