filter based on more textbox on form not show what i filtere

ahmed sa

12y1.7kVisual Basic .NET

Hi guys i make dynamic search based on dynamic stored procedure. it is working success but i need when i make filter

based on any textbox in form tell me you are filter by A And B and C AS Example

meaning when textbox1 has value A AND textbox2 has value B and textbox3 has value C

message or label tell me you are filter based on A,B,C

So that i need to loop throught all textboxes and if any textbox has value

message show or label show you are filter by a,b,c,d etc

How i do that

my function dynamic search meaning if you search by any textbox search will work

this is my function

FleetManagment.

Fleet fleet = new FleetManagment.Fleet();

DataTable Table = fleet.SearchEmployeeAllDateBetween("Data Source=" + value1 + ";Initial Catalog=" + value2 + ";User ID=" + value3 + ";Password=" + value4 + "", textBox1.Text, textBox2.Text, textBox5.Text, textBox28.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text, textBox11.Text, textBox12.Text, textBox13.Text, textBox14.Text, textBox15.Text, textBox16.Text, textBox17.Text, textBox18.Text, textBox19.Text, textBox20.Text, textBox21.Text, textBox22.Text, textBox23.Text, textBox24.Text, textBox25.Text, textBox26.Text, textBox31.Text, textBox32.Text, textBox27.Text, textBox30.Text, textBox29.Text, textBox6.Text, textBox4.Text, textBox33.Text, textBox53.Text, textBox3.Text, textBox34.Text, textBox56.Text, textBox51.Text, label33.Text, label34.Text);

dataGridView1.DataSource = Table;

dataGridView1.Refresh();

2 Replies

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

Wim Sturkenboom12y ago
Accepted answer
The below demos how you can loop through the controls on a form, check if it is a textbox or label and in case of a textbox adds the text of the box to a string.

Hope it gets you on the way; finetuning required ;)

            int cnt_txt = 0;
            int cnt_lbl = 0;
            string result = "";

            foreach (Control ctrl in this.Controls)
            {
                if (ctrl.GetType() == typeof(TextBox))
                {
                    TextBox tb = (TextBox)ctrl;
                    string txt = tb.Text;
                    if (!String.IsNullOrEmpty(txt))
                    {
                        result += txt + "|";
                    }
                    cnt_txt++;
                }
                if (ctrl.GetType() == typeof(Label))
                {
                    cnt_lbl++;
                }
            }

Tested in a Windows form application. The counters are just implemented for testing.
0
ahmed sa12y ago
Thank you for reply
this is correct answer
0