Hello to all. I am newbie here so I would like someone help me with my first project.
I need to make a search in the grid view depending of multiple fields criteria.
I have 4 ftexboxes: textbox1 textbox2, textbox3 and textbox4.
I have one gridview with data from access database. This is ok.
Problem is search criteria. I need to show only those records what I entered in textboxes.
For example:
textbox1 is filter for column1
textbox2 is filter for column2...etc.
Now is working when I change each textbox text separatelly.
But i need to do it on this way that I can fill multiple texboxes... and filter still must works.
Problem is when some textbox is empty, in that case no one record matches and grid is empty.
Is it possible to ignore texbox which has empty string?
I hope I explained it good, english is not my primary language.
Thanks
I need to make a search in the grid view depending of multiple fields criteria.
I have 4 ftexboxes: textbox1 textbox2, textbox3 and textbox4.
I have one gridview with data from access database. This is ok.
Problem is search criteria. I need to show only those records what I entered in textboxes.
For example:
textbox1 is filter for column1
textbox2 is filter for column2...etc.
Now is working when I change each textbox text separatelly.
But i need to do it on this way that I can fill multiple texboxes... and filter still must works.
Problem is when some textbox is empty, in that case no one record matches and grid is empty.
Is it possible to ignore texbox which has empty string?
I hope I explained it good, english is not my primary language.
Thanks