基于更多文本框在窗体上过滤不显示我过滤的值是什么

问题描述

大家好我根据动态存储过程进行动态搜索。它是成功的，但我需要当我制作过滤器



基于表格中的任何文本框告诉我你是按A和B和C AS过滤的例子



含义当textbox1有值A时，textbox2有值B，textbox3有值C



留言或标签告诉我你是基于A，B，C的过滤器



所以我需要循环遍历所有文本框，如果任何文本框有价值



消息显示或标签显示你是按a，b，c，d等过滤



我是怎么做的



我的功能动态搜索意思是你通过任何文本框搜索搜索都会起作用



这是我的功能



FleetManagment。





Fleet fleet = new FleetManagment.Fleet（）;





DataTable Table = fleet.SearchEmployeeAllDateBetween（Data Source =+ value1 +; Initial Catalog =+ value2 +; User ID =+ value3 +;密码= + 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（）;

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();

推荐答案

这篇关于基于更多文本框在窗体上过滤不显示我过滤的值是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！